Update using DataSet & Stored Proc.
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
Next message: William \(Bill\) Vaughn: "Re: Differences in execution times for a stored procedure"
Date: Mon, 4 Oct 2004 13:27:02 -0700
Can I pass a DataSet to a Stored Procedure (in Sql Server 2000)?
If yes, Do I just specify the parameters and let the SqlDataAdapter handle
passing the rows of data from the DataSet into the Stored Procedure?
Have you a good reference I can go to?
Thank you.
Next message: William \(Bill\) Vaughn: "Re: Differences in execution times for a stored procedure"
Relevant Pages
- Re: Was Create Stored Procedure wizard droped from SQL Server 2005
... In SQL server 2005 management studio, you can use the "Specify Values for ... connect to an instance of SQL Server 2005 Database ... Right-click Stored Procedures, and then click New Stored Procedure. ... click Specify Values for Template Parameters. ...
(microsoft.public.sqlserver.tools) - Re: Exec Stored procedure issue.
... You can't pass an expression as a stored procedure parameter; ... Since you are building a SQL statement string ... appears the easiest method is to specify the parameter as a ... supports Post Alerts, Ratings, and Searching. ...
(microsoft.public.sqlserver.programming) - Re: runtime error 800a01a8
... > results from the stored procedure. ... > form and how do I specify that I want the input parameter to be taken ... > dim dbcn, dbrs, byclassnoprice ... > Set objParam = byclassnoprice.CreateParameter ...
(microsoft.public.inetserver.asp.db) - Hitting Sql Server Stored Procedure Breakpoint from ASP.NET app
... I am not able to stop at a stored procedure breakpoint in SQL Server from an ... ASP.NET application unless I specify a username and password in my connection ... different user in DB connection string. ... debugging rights in SQL Server? ...
(microsoft.public.dotnet.framework.aspnet) - Re: EXEC syntax for SP which returns row set
... > you'd call a stored procedure and return data using an OUT parameter. ... and some others) that return result sets, and one is using a command line ... type interface (not a java program), you don't need to specify the OUT ... You do have to specify the IN parms. ...
(comp.databases.oracle.server) |
|
