存程中sql句~~~救命~~
外部六，我要根的情sql句！;;
似于：
sql= "select * from tablename where 1=1 ";
if(@para1 not is null)
sql=sql+ " and field1=@para1 ";
if(@para2 not is null)
sql=sql+ "and field2=@para2 ";
...
...

高手指教怎么？
或者有有更好的法，行理的多?

[解决办法]
declare @sql varchar(1000)

set @sql= 'select * from tablename where 1=1 '
if @para1 is not null
set @sql=@sql+ ' and field1= '+@para1--如果field1是字符型要 field1= ' ' '+@para1+ ' ' ' '
.
.
.
[解决办法]
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 @sql=@sql+ ' and field1= ' + @para1
/*@para1字符*/
set @sql=@sql+ ' and field1= ' ' ' + @para1 + ' ' ' '
end
.....
[解决办法]
DATETIME在sql中就是一个字符串