sql存储过程
SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =============================================-- Author: <Author,,Name>-- Create date: <Create Date,,>-- Description: <Description,,>-- =============================================CREATE PROCEDURE Bolg_SelectByUser@clanID int,@UserID text,@topNum intASBEGIN EXECUTE Clan_SelectByIDUserID @ClanID,@UserID OUTPUT select top @topNum * from GH_BLog where UserID in (@UserID) order by LastModTime descENDGO
SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =============================================-- Author: <Author,,Name>-- Create date: <Create Date,,>-- Description: <Description,,>-- =============================================CREATE PROCEDURE Bolg_SelectByUser@clanID int,@UserID text,@topNum intASBEGIN Declare @SqlStr varchar(max) EXECUTE Clan_SelectByIDUserID @ClanID,@UserID OUTPUT Set @SqlStr = 'select top ' + Cast(@topNum As Varchar(10)) + ' * from GH_BLog where UserID in (' + @UserID + ') order by LastModTime desc ' Exec(@SqlStr)ENDGO
[解决办法]
就是把报错的那句改成动态sql 执行应该就没问题了