我要实现的功能是删除某个用户的某个表.
用户名和表名都是变量
create procedure delete_all
@username varchar(50),
@delete_table varchar(50)
as
execute( '
delete *
from ' [email protected]_table+ '
where userID=(selecte userID from blog_users where username= '[email protected])
我写的这个好像是错误的?
应该怎么写呢?谢了!
------解决方案--------------------
try
create procedure delete_all
@username varchar(50),
@delete_table varchar(50)
as
execute( '
delete *
from ' [email protected]_table+ '
where userID=(selecte userID from blog_users where username= ' ' '[email protected] + ' ' ') ')
GO
------解决方案--------------------
1 delete from而不是delete * from
2 单引号之中引用单引号，需要把 '变成 ' '
create procedure delete_all
@username varchar(50),
@delete_table varchar(50)
as
execute( '
delete
from '[email protected]_table+ '
where userID=(selecte userID from blog_users where username= ' ' '[email protected] + ' ' ')
')
GO