>>>declare @SQL nvarchar(max) >>> >>>set @SQL = 'select * from ' + quotename(@TableName) + ' where UserName = @cUser' >>> >>>execute sp_ExecuteSQL @SQL, N'@cUser varchar(20)', @cUser>>
TEXT TO lcQuery TEXTMERGE NOSHOW ALTER PROCEDURE [dbo].[UserHasAccess] @tnCoID int = 0, @tcUsKey varchar(36) = '' AS BEGIN SET NOCOUNT ON; DECLARE @lcSQL nvarchar(max) SET @lcSQL = 'select CAST(COUNT(*) AS int) AS FXCount from ' + 'Payroll' + ltrim(str(@tnCoId)) + '..Roles' + ' where DelFlag = 0 AND roUsKey = @tcUsKey' EXECUTE sp_ExecuteSQL @lcSQL, N'@tcUsKey varchar(36)', @tcUsKey END TRANSACTION ENDTEXT SQLEXEC(nConn,lcQuery)