DECLARE @ShopCode NVARCHAR(20)
SET @ShopCode='01058'
DECLARE @sql NVARCHAR(100)
SET @sql = 'SELECT TOP 1 * FROM dbo.T_ShopBaseInfo WHERE ShopCode=@ShopCode or @ShopCode IS NULL'
EXEC sp_executesql @sql,N'@ShopCode NVARCHAR(20)',@ShopCode
--输出参数
SET @sql = 'SELECT @ShopCode=2';
EXEC sp_executesql @sql,N'@ShopCode NVARCHAR(20) output',@ShopCode output
--拼接语句中有给参数赋值,外面要获得,必须采用 output输出参数方式