create procedure Pro_test (@username nvarchar(100)) as select * from user where id=@username
create procedure pro_1 (@username varchar(100)) as begin declare @sql varchar(8000) select @sql='select * from user where id='''+@username+'''' exec(@sql)end
sql="select * from user where id='"+request("username")+"'" rs.open sql,conn
(@username nvarchar(100))
as
select * from user where id=@username
as
begin
declare @sql varchar(8000)
select @sql='select * from user where id='''+@username+''''
exec(@sql)end
rs.open sql,conn
写成语句直接执行,莫如 zjcxc(: 邹建 :) 的方法,直接。
如果麻烦的话,可以如sunshareforever(阳光) 。
他们都是高手。