DECLARE @Name varchar(50)
DECLARE @Query nvarchar(200)
DECLARE @ParmDefinition NVARCHAR(500)
SET @Query =’Select @Name=CompanyName from CompanyDetail’
SET @ParmDefinition = N’@Name varchar(50) OUTPUT’
EXEC SP_EXECUTESQL @Query,@ParmDefinition,@Name=@Name OUTPUT
SELECT @Name
Archive for the ‘SQL’ Category
How to get value using SP_EXECUTESQL
Posted by Rajesh on March 10, 2009
Posted in SQL, SQL Question | Leave a Comment »
