我要实现的功能是删除某个用户的某个表.
用户名和表名都是变量
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)我写的这个好像是错误的?应该怎么写呢?谢了!
用户名和表名都是变量
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)我写的这个好像是错误的?应该怎么写呢?谢了!
@username varchar(50),
@delete_table varchar(50)
as
execute('
delete
from ' +@delete_table+'
where userID=(selecte userID from blog_users where username='+@username)
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
第 4 行: 'userID' 附近有语法错误。
@username varchar(50),
@delete_table varchar(50)
as
execute('
delete
from ' +@delete_table+'
where userID=(select userID from blog_users where username='''+@username + ''')')
GO
delete 後面多了*2.
“selecte userID ”,select 拼寫錯誤。
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
我想问一下
'
where userID=(select userID from blog_users where username='''+@username + ''')')这里的'''+@username + '''都是为什么要用三个单引号?
所有2 + 1就是三個了。表述的不好,不知道講明白沒有。
@username varchar(50),
@delete_table varchar(50)
as
execute('
delete from ' +@delete_table+'
where uid=user_ID('+ @username+')')
go
?????过程嵌套?还是