Help: Urgent please: sql server stored procedure

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Help: Urgent please: sql server stored procedure

Author

Topic

sruthiloga
Starting Member

2 Posts

Posted - 2011-08-16 : 11:22:20

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

38200 Posts

Posted - 2011-08-16 : 12:45:59

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

sruthiloga
Starting Member

2 Posts

Posted - 2011-08-16 : 13:39:24

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?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-08-16 : 13:44:35

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources