set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[GetFreeTeacherID]
@tName varchar(50),
@cName varchar(50),
@sStatus varchar(50)
as
declare @sql varchar(2000)
set @sql ='select TS_TeacherID from tableName='+@tName+'where cellName='+@cName+'like" status='+@sStatus+'"'
exec(@sql)报错是 = 号附近有错误 不知道哪里错了 大家帮帮忙 谢谢了
set QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[GetFreeTeacherID]
@tName varchar(50),
@cName varchar(50),
@sStatus varchar(50)
as
declare @sql varchar(2000)
set @sql ='select TS_TeacherID from tableName='+@tName+'where cellName='+@cName+'like" status='+@sStatus+'"'
exec(@sql)报错是 = 号附近有错误 不知道哪里错了 大家帮帮忙 谢谢了
ALTER proc [dbo].[GetFreeTeacherID]
@tName varchar(50),
@cName varchar(50),
@sStatus varchar(50)
as
declare @sql varchar(2000)
set @sql ='select TS_TeacherID from tableName='+@tName+'where cellName='''+@cName+''' like" status='''+@sStatus+'''"'
exec(@sql)
你PRINT @sql
出来看是不是你想要的SQL
like " 没看明白
ALTER proc [dbo].[GetFreeTeacherID]
@tName varchar(50),
@cName varchar(50),
@sStatus varchar(50)
asdeclare @sql varchar(2000)
set @sql ='select TS_TeacherID from tableName='+@tName+' where cellName='''+@cName+''' and status like ''%'+@sStatus+'%'''
exec(@sql)
这是不是你想要的