建议改成:
declare @s varchar(100)
set @s='SELECT * FROM '+@TABLE_NAME+' WHERE KTMC LIKE @XMMC+'%'
exec @s
declare @s varchar(100)
set @s='SELECT * FROM '+@TABLE_NAME+' WHERE KTMC LIKE @XMMC+'%'
exec @s
@TABLE_NAME CHAR(2),
@XMMC VARCHAR(100)
ASUse @TABLE_NAME SELECT * FROM @TABLE_NAME WHERE KTMC LIKE @XMMC+'%'
GO
@TABLE_NAME CHAR(2),
@XMMC VARCHAR(100)
ASSELECT * FROM [@TABLE_NAME] WHERE KTMC LIKE @XMMC+'%'
GO
@TABLE_NAME CHAR(2),
@XMMC VARCHAR(100)
ASSELECT * FROM [@TABLE_NAME] WHERE KTMC LIKE @XMMC+'%'
GO
试一试,我试过了没问题
declare @TABLE_NAME [CHAR](2)
declare @XMMC [VARCHAR](100)
ASSELECT * FROM @TABLE_NAME WHERE KTMC LIKE @XMMC+'%'
GO
试一下
@TABLE_NAME CHAR(2),
@XMMC VARCHAR(100)
ASdeclare @s nvarchar(500)
select @s='Select * from '+@table_name where ktmc like '''+@xmmc+'%'''
exec sp_executesql @s
GO
select @s='Select * from '+@table_name where ktmc like '''+@xmmc+'%'''
exec sp_executesql @s
这在query中可以这样编写
在sql server中可以么?我试了则么不行
select @xmmc='过滤条件'
exec xxx '你的表名','过滤条件'