T-SQL语句的拼接后，查询结果集语句
DECLARE @Sql NVARCHAR(MAX),@ReceiveID NVARCHAR(50)
SET @ReceiveID = ' WHERE AreaID = 11'
SET @Sql = 'SELECT * FROM dbo.Area_Info'
IF (ISNULL(@ReceiveID, '') <> '')
BEGIN www.2cto.com
SET @Sql = @Sql +@ReceiveID
END
--PRINT @Sql
EXEC (@Sql)
作者 love_may555