CREATE PROCEDURE aa
@sheetname nvarchar (10),
@xxcode nvarchar (11)
AS
execute('SELECT *  FROM  '+@SheetName+' where xxcode like '+@xxcode+'% order by xxcode' )

这个存储过程不对，问题在最后的%位置，不知如何处理，请高手帮忙

'+@xxcode+%'
試下

还是不能，创建都不成立

CREATE PROCEDURE aa
@sheetname nvarchar (10),
@xxcode nvarchar (11)
AS
exec ('SELECT *  FROM  '+ @sheetname +' where xxcode like '+ @xxcode + '% order by xxcode')

我也是这样写的啊，没出问题。
有点奇怪哦

CREATE PROCEDURE aa
@sheetname nvarchar (10),
@xxcode nvarchar (11)= '%'
AS
execute('SELECT *  FROM  @SheetName where xxcode like @xxcode order by xxcode' )

使用带通配符的也行。。。

ALTER PROC PROC_CX

   @TABLE CHAR(10),
   @ZDM   VARCHAR(10),
   @ZDM_1 CHAR(10)

AS

    SELECT * FROM @TABLE WHERE @ZDM_1 LIKE '%' + @ZDM + '%'

CREATE PROCEDURE aa
@Sheetname nvarchar (10),--是不是這個大小寫的問題
@xxcode nvarchar (11)
AS
execute('SELECT *  FROM  '+@SheetName+' where xxcode like '+@xxcode+'% order by xxcode' )

大小写没关系

CREATE PROCEDURE aa
@sheetname nvarchar (10),
@xxcode nvarchar (11)
AS
execute('SELECT *  FROM  '+@SheetName+' where xxcode like'% '+@xxcode+'%'' order by xxcode' )

%是个字符要用单引号