SQL Server Forums - displaying variable values

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

General SQL Server Forums

New to SQL Server Programming

displaying variable values

New Topic

Reply to Topic

Printer Friendly

Author

Topic

bill_
Starting Member

29 Posts

Posted - 05/17/2010 : 18:07:15

How do you display variable values ?

Trying to learn how to loop through a cursor and take totals and counts.

Tried the PRINT @totalfee but when I did exec mystoredproc I saw query results but no total.

Edited by - bill_ on 05/17/2010 19:05:42

visakh16
Very Important crosS Applying yaK Herder

India
47023 Posts

Posted - 05/18/2010 : 01:01:39

print willl display results in messages tab

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

dattatreysindol
Starting Member

India
20 Posts

Posted - 05/18/2010 : 05:16:25

Hi There -

You can even use SELECT @totalfee to display the results in the results tab.

Dattatrey Sindol
http://mytechnobook.blogspot.com/

This information is provided "AS IS" with no warranties, and confers no rights.

bill_
Starting Member

29 Posts

Posted - 05/18/2010 : 08:14:06

Thank you very much visakh16 and dattareysindol !

visakh16
Very Important crosS Applying yaK Herder

India
47023 Posts

Posted - 05/18/2010 : 13:54:36

welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

SQL Server Forums

This page was generated in 0.03 seconds.