get a return value

• MoreanK

  Mr or Mrs. 500

  Points: 540

  More actions

  September 2, 2005 at 9:16 pm

  #89600

  Hello,

          I would like to get a return value from the following query script.

  eg:

  declare @Table varchar(30)

  declare @output int

  set @Table = 'UserList'

  set @output = execute('Select count(*) from ' + @Table)

  I want to reuse that output in another query. but I have a problem.

  Thanks a lot!

   

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  September 2, 2005 at 9:24 pm

  #587427

  To do this you must use sp_executesql

  use pubs

  declare @sql nvarchar(100),

  @Table varchar(30),

  @Output int

  set @Table = 'authors'

  set @sql = 'select @output = count(*) from ' + @Table

  exec sp_executesql @sql, N'@output int OUTPUT', @output OUTPUT

  select @Output

   

• MoreanK

  Mr or Mrs. 500

  Points: 540

  More actions

  September 3, 2005 at 12:19 am

  #587429

  Thanks a lot! I got it.