定义表 u ,属性有uid varchar50
定义存储过程
CREATE proc my (@tbname varchar(50),@kv varchar(50) )
as
exec( ' delete from '+@tbname+'where uid ='+@kv)
GOasp.net 中调用
string cn = "Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=cbmsXP_db;server=(local)";
SqlConnection con=new SqlConnection(cn ) ;
con.Open();
string sql="my";
SqlCommand comm=new SqlCommand(sql,con);
comm.CommandType=CommandType.StoredProcedure;
SqlParameter s1 = comm.Parameters.Add("@tbname", SqlDbType.VarChar,50);
s1.Value = 'u';
//SqlParameter s2=comm .Parameters .Add ("@key",SqlDbType .VarChar,50 );
//s2 .Value ="uid" ;
SqlParameter s3 = comm.Parameters.Add("@kv", SqlDbType.VarChar, 50);
s3.Value = "001";
TextBox1.Text = comm.ExecuteNonQuery().ToString();
在最后一句提示:第 1 行: 'uid' 附近有语法错误。
请大家帮忙啊
定义存储过程
CREATE proc my (@tbname varchar(50),@kv varchar(50) )
as
exec( ' delete from '+@tbname+'where uid ='+@kv)
GOasp.net 中调用
string cn = "Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=cbmsXP_db;server=(local)";
SqlConnection con=new SqlConnection(cn ) ;
con.Open();
string sql="my";
SqlCommand comm=new SqlCommand(sql,con);
comm.CommandType=CommandType.StoredProcedure;
SqlParameter s1 = comm.Parameters.Add("@tbname", SqlDbType.VarChar,50);
s1.Value = 'u';
//SqlParameter s2=comm .Parameters .Add ("@key",SqlDbType .VarChar,50 );
//s2 .Value ="uid" ;
SqlParameter s3 = comm.Parameters.Add("@kv", SqlDbType.VarChar, 50);
s3.Value = "001";
TextBox1.Text = comm.ExecuteNonQuery().ToString();
在最后一句提示:第 1 行: 'uid' 附近有语法错误。
请大家帮忙啊
set @sql='delete from '+@tbname+' where uid='+@kv
exec @sql
GO
你看看你的语句能执行么