Re: Output Parameter To Global Variable (DTS) ... >article and used the dummy code.... >end of the stored procedure thereby having the SP return a result set. ... Sorry, I am at a loss, as the sample code I posted previously works fine ... DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals... (microsoft.public.sqlserver.dts)
Re: Desparete for advice on stored proc from asp.net ... > I have no hairs left and what is has gone gray.... > I have a datagrid page which allows the user to select certain records ... within my stored procedure that gets called the ... here is sample code... (microsoft.public.dotnet.framework.aspnet.datagridcontrol)
RE: C# SQL SERVER LAST INSERT ID EXAMPLES ... In a stored procedure, you can certainly get SCOPE_IDENTITY for an IDENTITY ... column, or even query using the last row values, to get the last inserted ID ..."Sheraz Khan via .NET 247" wrote: ... > does anyone have sample code of data being inserted to a table, then the last insert id is retrived and inserted into another table. ... (microsoft.public.dotnet.framework.adonet)
Re: Passing text file to SQL Server ... > I need to pass the entries in a text file to corresponding tables in a ...database.... Can I pass the entire text file to a stored procedure or can I ... > Can you show me some sample code?... (microsoft.public.dotnet.general)
Need help on Stored Procedure ... Can anyone give me sample code, how to call stored procedure from vba with ... output and input parameter?... (microsoft.public.access.gettingstarted)