How to print the @variable RSS

• • Reply
  

  customer22

  Member

  67 Points

  164 Posts

  How to print the @variable

  Oct 18, 2010 08:49 PM|LINK

  Hello:

  Thanks for everyone help.
  

  I have a procedure. I need to print the variable to debug.

  Here is my code:

  begin

  select @UIT= TYPE from tableone where name = @name and id = @id

  print  @UIT

  end

  I got the error: Msg 102, Level 15, State 1, Line 9
  Incorrect syntax near '@UIT

  How to print the variable in procedure.

  Thank you very much!
  

  
  

• • Reply
  

  sansan

  All-Star

  53942 Points

  8147 Posts

  Re: How to print the @variable

  Oct 18, 2010 09:37 PM|LINK

  Did you declare that UIT variable

  Declare @out varchar(100)
  select @out=SomeColumn  from TableName where SomeColumn=SomeValue
  print @out;

  Santhosh
  • Marked as answer by customer22 on Oct 21, 2010 03:25 PM
• • Reply
  

  customer22

  Member

  67 Points

  164 Posts

  Re: How to print the @variable

  Oct 21, 2010 03:25 PM|LINK

  Thank you very much!