PRINT in transact-SQL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I have a question regarding PRINT statement in transact-SQL.
The following is my test environment
* Vuisual Studion 2003, server explorer
* either in SQL pane or using stored procedur
The scenerio are like belo
* alter procedure myProcedure as PRINT 'HELLO' <===== It work
* alter procedure myProcedure as begin PRINT 'HELLO' end <===== It does not work
Please advice
Peter
 
Hi Peter,

I tried both scenarios using sql server 2000 - both worked fine. Did you
check the status of myprocedure in sql's enterprise manager?

Bernie Yaeger
 
Hi Bernie
After I saw your reply, I found that I had not defined my isuue more precisely. I use MSDE. I might make some mistake and might not. Anyway I can use "SELECT" for output instead. Thanks
Peter
 
Back
Top