SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
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
 Help: Urgent please: sql server stored procedure
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sruthiloga
Starting Member

2 Posts

Posted - 08/16/2011 :  11:22:20  Show Profile  Reply with Quote
Hi,
Im in need of

Calling a stored procedure with single argument(that holds different values) in a sql script or stored procedure.

eg:

loop start{
sin(A) : A=1,2,...n(any random value)
}loop ends

Thanks,
L


tkizer
Almighty SQL Goddess

USA
35937 Posts

Posted - 08/16/2011 :  12:45:59  Show Profile  Visit tkizer's Homepage  Reply with Quote
I love how this is urgent. Use a varchar data type. If you want more help, you'll need to provide better info.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

sruthiloga
Starting Member

2 Posts

Posted - 08/16/2011 :  13:39:24  Show Profile  Reply with Quote
i never ever executed/worked with MS sql server before. Need to write sql script to call a stored procedure.

example:

storedprocedure(argument) argument could be 1 to n ;



how to call a stored procedure from another procedure?

Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35937 Posts

Posted - 08/16/2011 :  13:44:35  Show Profile  Visit tkizer's Homepage  Reply with Quote
Here's a simple example:

EXEC sprocName @var1 = 5

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000