22,206
社区成员
发帖
与我相关
我的任务
分享
ALTER PROCEDURE proc_ExsitUserName
(
@userName nvarchar(12),
@table nvarchar(10),
@prefix nvarchar(10)
)
AS
DECLARE @sql nvarchar(MAX)
SET @sql='SELECT COUNT('+@prefix+'_userName) FROM '+@table+' WHERE '+@prefix+'_userName='+@userName
EXECUTE(@sql)
RETURN
SET @sql='SELECT COUNT('+@prefix+'_userName) FROM '+@table+' WHERE '+@prefix+'_userName='+@userName
更改为:
SET @sql='SELECT COUNT('+@prefix+'_userName) FROM '+@table+' WHERE '+@prefix+'_userName='''+@userName+''''
ALTER PROCEDURE proc_ExsitUserName
(
@userName nvarchar(12),
@table nvarchar(10),
@prefix nvarchar(10)
)
AS
DECLARE @sql nvarchar(MAX)
SET @sql='SELECT COUNT('+@prefix+'_userName) FROM '+@table+' WHERE '+@prefix+'_userName='''+@userName+''''
EXECUTE(@sql)
RETURN
go