return value of EXECUTE sp_executesql(SQLString)

return value of EXECUTE sp_executesql(SQLString)

• srirams

  I'm not sure what "return value" means -- if you mean that your SQL generates a value that you need to assign to a variable, you can use an OUTPUT param:

   

   

  DECLARE @x int

   

  EXEC sp_executesql

      N'SELECT @x = 1',

      '@x int OUTPUT',

      @x OUTPUT

   

  PRINT @x

   

   

  
  --
  Adam Machanic
  Pro SQL Server 2005, available now
  http://www..apress.com/book/bookDisplay.html bID=457
  --

   

   

  <JIM.H.@discussions.microsoft.com> wrote in message news:0192cb2b-5029-4e6f-af64-74e46ae9feed@discussions.microsoft.com...

  Hi,

  How can I check return value from

  EXECUTE sp_executesql(SQLString)

  Thanks,

  
  
• return value of EXECUTE sp_executesql(SQLString)