Passing parameter to store SQL procedure ??? -- dotnet ado.net

Robbe Morris - [MVP] C#
9/12/2007 12:48:17 PM

Uh, if you don't know the variables, how do you know which column
to put the value in?

No, sql server doesn't have the concept of arrays for stored
procedure parameters. Yes, you could pass in XML but I suspect
that you'll quickly find that is a painful alternate based on your
requirements.

The only way I can think of is that you are using dynamic sql
in your stored procedure. If that is the case, then why bother
with passing it to a stored procedure at all? You could just
package up the sql in your .NET code instead.

--
Robbe Morris [Microsoft MVP - Visual C#]
..NET PropertyGrid Control - ListBox, ComboBox, and Custom Classes
http://www.eggheadcafe.com/tutorials/aspnet/270e9432-d236-47e7-b1af-5cd3abe27a75/net-propertygrid-control.aspx

[quoted text, click to view]

William Vaughn
9/13/2007 12:23:48 PM

SQL Server 2008 introduces Table-valued parameters that might help, but
there are ways that you can pass structured data to a SP in SQL Server 2005
(or 2000 for that matter--but it's harder). For example, you can pass a
delimited string that has multiple values or a structure of your own
choosing that can feed a logic engine to process the query. In 2005 you can
write a SQL CLR stored procedure to parse the structure or write it in TSQL.

Another approach (as was indicated by another contributor) is to create
dynamic SQL. This is possible, but can be dangerous as it can lead to SQL
injection attacks.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about dotnet ado.net

dotnet ado.net : Passing parameter to store SQL procedure ???