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