從外部傳進來六個參數，我要根據參數的情況來組裝sql語句！;;
類似于：
sql= "select * from tablename where 1=1 ";
if(@para1 not is null)
sql=sql+ " and [email protected] ";
if(@para2 not is null)
sql=sql+ "and [email protected] ";
...
...
高手指教怎么寫？
或者有沒有更好的辦法，來進行處理這樣的多參數問題?
------解决方案--------------------
declare @sql varchar(1000)
set @sql= 'select * from tablename where 1=1 '
if @para1 is not null
set @[email protected]+ ' and field1= '[email protected] field1= ' ' '[email protected]+ ' ' ' '
.
.
.
------解决方案--------------------
sql= "select * from tablename where 1=1 and field1=isnull(@para1,field1) and field2=isnull(@para2,field2) "
------解决方案--------------------
declare @sql varchar(1000)
set @sql= ' '
set @sql= 'select * from tablename where 1=1 '
if(@para1 is not null)
begin
set @[email protected]+ ' and field1= ' + @para1
[email protected]*/
set @[email protected]+ ' and field1= ' ' ' + @para1 + ' ' ' '
end
.....
------解决方案--------------------
DATETIME在sql中就是一个字符串