how to print in sql server

Posted by Vijay.Kumar under Sql Server on 9/24/2012 | Points: 10 | Views : 1606 | Status : [Member] | Replies : 3
hi guys


In my task i have to print the output in sql server
where 1 is in and 2 is out pls help and respont soon




Responses

Posted by: Jayakumars on: 9/24/2012 [Member] [MVP] Bronze | Points: 25

Up
0
Down
hi

try this
Create Procedure

Create Proc sp_List
as
declare @edi varchar(20)
set @edi=(select COUNT(*) from tbl_Time)
print @edi


Execute Query

exec sp_List



Mark as Answer if its helpful to you

Vijay.Kumar, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jayakumars on: 9/24/2012 [Member] [MVP] Bronze | Points: 25

Up
0
Down
hi

Please mark as answer if it helpful to you.

Mark as Answer if its helpful to you

Vijay.Kumar, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Pandians on: 9/25/2012 [Member] [MVP] Silver | Points: 25

Up
0
Down
@Vijay.Kumar

You can use PRINT statement.

Kindly explain about your scenario, so, we can help you better!

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Vijay.Kumar, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response