strored procedures in sql server 2005

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

SQL Server 2000 Forums

SQL Server Development (2000)

strored procedures in sql server 2005

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-11-03 : 08:06:57

pradeep writes "how to create a stored procedure with input parameters (varying) which are taken from front end in asp.net application

i.e our stored procedure must take take the input parameters as the values that are selected at the front end"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-11-03 : 08:17:08

Read about Stored procedures in sql server help file
Also you need to know how to do it in .NET

Madhivanan

Failing to plan is Planning to fail

mightypenny_ph
Yak Posting Veteran

54 Posts

Posted - 2006-11-06 : 07:01:52

yes. you need parameterized stored procedures

create procedure [dbo].[spname]
@param1 int,
@param2 int
AS
BEGIN
...
..
.
END
GO

SlayerS_`BoxeR` + [ReD]NaDa

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-11-06 : 07:30:18

If you need REALLY need "varying" input parameters, try consider using an options table where you insert things and run the stored procedure against that.
Or take the time to read http://www.sommarskog.se/dynamic_sql.html

Peter Larsson
Helsingborg, Sweden

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources