n********6
发帖数: 1511 | 1 objective:
SELECT * FROM TABLE1
WHERE @COLUMEVariable = 'xyz'
(SQL SERVER 2005)
请问：以下dynamic sql哪里出错了？有没有其他办法？谢谢。
Declare @testvar varchar(50)
Declare @testval varchar(50);
Set @testvar = Col1;
Set @testval = 'on';
SELECT * FROM ...
WHERE @testvar is not null
and @testvar =
CASE UPPER(@testval)
WHEN 'ON' THEN 'on'
END |
i****a
发帖数: 36252 | 2 google "dynamic sql"
http://www.sqlteam.com/article/introduction-to-dynamic-sql-part
【在 n********6 的大作中提到】
: objective:
: SELECT * FROM TABLE1
: WHERE @COLUMEVariable = 'xyz'
: (SQL SERVER 2005)
: 请问：以下dynamic sql哪里出错了？有没有其他办法？谢谢。
: Declare @testvar varchar(50)
: Declare @testval varchar(50);
: Set @testvar = Col1;
: Set @testval = 'on';
: SELECT * FROM ...
|
g***l
发帖数: 18555 | 3 需要把SQL变成STRING
Declare @SQL VarChar(1000)
SELECT @SQL = 'SELECT * FROM '
SELECT @SQL = @SQL + @TableName
Exec ( @SQL) |
B*****g
发帖数: 34098 | 4 first you may need to check if @COLUMEVariable is a valid column name?
【在 n********6 的大作中提到】
: objective:
: SELECT * FROM TABLE1
: WHERE @COLUMEVariable = 'xyz'
: (SQL SERVER 2005)
: 请问：以下dynamic sql哪里出错了？有没有其他办法？谢谢。
: Declare @testvar varchar(50)
: Declare @testval varchar(50);
: Set @testvar = Col1;
: Set @testval = 'on';
: SELECT * FROM ...
|
n********6
发帖数: 1511 | 5 Thank you all. Problem solved. I used it in ASP. Already in string. Just
misplaced the single quote(') for the object name (varname).
The above question is oversimplified and misrepresented. |
B*****g
发帖数: 34098 | 6 Who still use ASP!!!
【在 n********6 的大作中提到】
: Thank you all. Problem solved. I used it in ASP. Already in string. Just
: misplaced the single quote(') for the object name (varname).
: The above question is oversimplified and misrepresented.
|
a9
发帖数: 21638 | 7 they，哈哈
现在用asp的还挺多的。
【在 B*****g 的大作中提到】
: Who still use ASP!!!
|
