Question

关于存储过程的应用

string sql="select * from Customers where "+ DropDownList1.Text +" is null";此sql语句如何写成存储过程？请高手指点.数据库用的是sql server的Northwind数据库。页面有一个GridView,一个DropDownList（已经绑定Customers表的所有列）.

Answer 1

create procedure P(@DropDownList1 sysname)
as

exec('select * from Customers where '+@DropDownList1+' is null')

Answer 2

CREATE PROCEDURE test (@n narchar(255))
as
exec sp_executesql "select * from Customers where "+ @n +" is null"