No announcements
Found 3942639 threads
-
0 VotesUsing one Stored Procedure to Insert data into multiple tables in EF4.0
how should I map a single stored procedure that inserts data into multiple tables.Answered | 5 Replies | 13821 Views | Created by gmanchin - Monday, June 21, 2010 7:39 PM | Last reply by William Aitken - Monday, January 17, 2011 11:40 PM
-
0 Votes
Stored Procedure Returning Multiple Datasets
Orlanzo said: Hi All, Is it possible to consume and dispense multiple recordsets from a stored procedure in Integration Services?Answered | 2 Replies | 4565 Views | Created by Orlanzo - Wednesday, December 31, 2008 2:30 PM | Last reply by Duane Douglas - Thursday, January 1, 2009 6:26 AM -
1 Votes
writing stored Procedure to insert data in multi table
You can use this template: CREATE PROC dbo.spInsert AS SET NOCOUNT ON; BEGIN TRY SET XACT_ABORT ON; --set xact_abort option BEGIN ...Answered | 2 Replies | 1385 Views | Created by sun28 - Wednesday, October 9, 2013 5:34 AM | Last reply by sun28 - Wednesday, October 9, 2013 7:04 AM -
0 Votes
insert data in database using stored procedure
http://connectedcircuits.wordpress.com/2011/08/17/using-sql2008-data-table-type-biztalk-to-insert-parent-child-rows/ http://b ...Answered | 15 Replies | 5628 Views | Created by Sharmishtha - Friday, November 4, 2011 7:22 AM | Last reply by Sharmishtha - Friday, November 4, 2011 11:24 AM -
0 Votes
How to write insert statements in a text file using Stored Procedure
I agree this is not SSIS forum, but I am calling the stored procedure in execute SQL Command.Answered | 7 Replies | 1934 Views | Created by MustafaH - Tuesday, April 16, 2013 11:11 AM | Last reply by MustafaH - Wednesday, April 24, 2013 10:03 AM -
0 Votes
Issue using SQL stored procedure to insert/update
You need to rewrite your stored procedure to take care of the whole set of rows.Answered | 8 Replies | 956 Views | Created by sid_siv - Friday, April 10, 2015 6:34 PM | Last reply by Charlie Liao - Tuesday, April 14, 2015 6:03 AM -
0 Votes
How to iterate in data when data return by store procedure
Hi Sudip_inn, Would you like to return data from a Stored Procedure?Answered | 11 Replies | 921 Views | Created by Sudip_inn - Friday, October 18, 2019 12:58 PM | Last reply by Naveen Thummalapenta - Monday, October 21, 2019 11:02 AM -
2 Votes
call stored procedure with parameter to insert entered data
Never had an issues and I always write unit test to ensure code works as expected.Answered | 13 Replies | 883 Views | Created by zleug - Thursday, March 26, 2020 6:39 PM | Last reply by Naomi N - Thursday, March 26, 2020 10:45 PM -
0 Votes
Best Practice for returning rows from a stored procedure
What are your thoughts on the best way to write the proc if it will be used by SSIS?Answered | 10 Replies | 4468 Views | Created by ckbkyne - Tuesday, October 13, 2009 7:27 PM | Last reply by ckbkyne - Wednesday, October 14, 2009 1:32 PM -
2 Votes
Procedure to insert data in multiple rows
You can insert multiple rows using a single SQL INSERT statement: INSERT INTO Table ( Column1, Column2 ) VALUES ( Value1, Value2 ), ...Answered | 5 Replies | 1479 Views | Created by sreekanth.jonna - Saturday, September 20, 2014 5:16 PM | Last reply by Ahsan Kabir - Monday, September 22, 2014 1:20 PM -
0 Votes
SSRS Using a single Stored Procedure to return all the DataSets declared in a Report
the data on the report preview The other way is modifying the store procedure at the beginning, to something like ...Answered | 3 Replies | 8720 Views | Created by RukaPort - Thursday, May 26, 2011 6:17 PM | Last reply by Jason A Long - Friday, May 27, 2011 2:26 PM -
0 Votes
Bulk Inserts in a Stored Procedure
BULK INSERT imports a data file into a database table or view in a user-specified format, if your tables are all physical tables in SQL Server, there is ...Answered | 5 Replies | 1187 Views | Created by AlwaysLearner08 - Tuesday, March 3, 2020 5:33 PM | Last reply by Lily Lii - Thursday, March 5, 2020 6:40 AM -
0 Votes
DataAdapter UpdateCommande using Stored procedure
This is a bit tricky if you do not have any primary keys returned in the select.Answered | 1 Replies | 3961 Views | Created by singhhome - Tuesday, April 7, 2009 10:14 PM | Last reply by Michael Aspengren - MSFT - Wednesday, April 8, 2009 8:57 AM -
0 Votes
Using Store Procedures with a (None) Return Type
In the current EF release, we don't do code generation for stored procedures with return type "none".Answered | 3 Replies | 4446 Views | Created by Jeremy Sullivan - Tuesday, April 7, 2009 5:44 PM | Last reply by Jiri {x2} Cincura - Wednesday, April 8, 2009 8:59 PM -
0 Votes
Stored Procedure Dataset parameter
So, in order that I don’t have to keep writing the same queries for my select-lists, I have moved this out to a stored procedure.Answered | 5 Replies | 4649 Views | Created by Jay_l_a - Wednesday, February 18, 2009 7:21 PM | Last reply by Raymond-Lee - Saturday, February 21, 2009 8:10 AM -
1 Votes
execute stored procedure as a dataset
Hi, For use a stored procedure in dataset follow these steps as: In the dataset ...Answered | 2 Replies | 3612 Views | Created by tsql_new - Monday, December 10, 2012 5:46 PM | Last reply by Avanish Tomar - Tuesday, December 11, 2012 6:54 AM -
0 Votes
How to create a stored procedure to insert data in the table
Even tho it is a skeleton, try to use proper data element names.Answered | 3 Replies | 3439 Views | Created by satwick - Tuesday, November 8, 2011 9:56 PM | Last reply by --CELKO-- - Wednesday, November 9, 2011 5:17 AM -
0 Votes
Insert row into a Dataset.
When you start dealing with large tables, you wont be able to load them into memory.Answered | 2 Replies | 802 Views | Created by aniyahudi - Monday, June 16, 2014 5:46 PM | Last reply by Nick Holmes - Eurofins - Monday, June 16, 2014 9:00 PM -
2 Votes
use stored procedure to insert a row in a table with a lot of columns
If I write a stored procedure to insert a row into the table, I need declare more than 30 parameters.Answered | 2 Replies | 4045 Views | Created by peter 9 - Wednesday, June 2, 2010 5:50 AM | Last reply by Sorna Kumar Muthuraj - Wednesday, June 2, 2010 7:34 AM -
2 Votes
Error while updating the data in datagridview (binded with the dataset) using a stored procedure
We use adapter.fill() method in disconnected mode and use adapter.update() to replicate the changes made in dataset or datatable back to DB.Answered | 4 Replies | 12413 Views | Created by Gaurang Naik - Saturday, March 19, 2011 9:08 AM | Last reply by Gaurang Naik - Monday, March 21, 2011 6:53 AM - Items 1 to 20 of 3942639 Next ›
No announcements
