No announcements
Found 3587145 threads
-
0 VotesAdd-on for Visual Studio 2005 to generate Insert statements for SQL 2005
However you might take a look at T4, I'm not sure if it has an add-in for 2005 but this is one way to generate such code in VS 2008-2010.Answered | 1 Replies | 8961 Views | Created by kotayk - Friday, November 20, 2009 5:09 PM | Last reply by justin.m.chase - Monday, November 23, 2009 6:45 PM
-
0 Votes
SQL Merge Statement - Identify Cuase of Insert \ Update
As suggested you need to OUTPUT the inserted/deleted columns into a log file and compare what changed.Answered | 7 Replies | 5895 Views | Created by dougieday - Friday, February 18, 2011 9:55 AM | Last reply by Kalman Toth - Friday, February 25, 2011 8:21 AM -
1 Votes
BULK INSERT query - any equivalent for updates and deletions?
Then you can use that in an UPDATE statement if you so desire.Answered | 6 Replies | 769 Views | Created by Oakwinds - Thursday, June 7, 2018 5:24 PM | Last reply by Erland Sommarskog - Thursday, June 7, 2018 10:40 PM -
0 Votes
SSMA generates TRUNCATE TABLE statements for data migration, want DELETE instead
Based on my search, there isn’t a feature or project setting in SQL Server Migration Assistant (SSMA) for access to generate DELETE ...Answered | 1 Replies | 1686 Views | Created by G Britton - Tuesday, March 8, 2016 8:38 PM | Last reply by copu - Friday, March 11, 2016 10:30 AM -
0 Votes
Insert Statement in execute sql task
Take a execute SQL task and configure it like: SQL Statement: INSERT INTO [tempdb].Answered | 3 Replies | 8091 Views | Created by muppasuresh - Tuesday, December 8, 2009 6:17 AM | Last reply by Nitesh Rai - Tuesday, December 8, 2009 8:06 AM -
0 Votes
bdc insert, delete and update
As for pulling information/data from underlying datasources you specify the connection string, sql query or sprc, return value of data, credentials and many more ...Answered | 4 Replies | 9693 Views | Created by kkmick - Wednesday, June 24, 2009 3:32 PM | Last reply by kkmick - Monday, June 29, 2009 1:21 PM -
1 Votes
Is it posible to combine an delete and insert statement in the same stored procedure
Welcome to the transact SQL forum.Answered | 6 Replies | 3960 Views | Created by jylland - Tuesday, November 24, 2009 2:20 PM | Last reply by jylland - Friday, December 11, 2009 2:06 PM -
3 Votes
Update statement inserts a new row instead of updating
I tried to insert update statement (see below) with static values directly to c# code and it again inserted a new row...Answered | 68 Replies | 762 Views | Created by Emil Huseynov - Sunday, April 12, 2015 8:30 AM | Last reply by Kareninstructor - Monday, April 13, 2015 1:08 PM -
0 Votes
CDC records Updates as Insert and Delete
Hi, This isn't specific to CDC; it's regular SQL Server behaviour.Answered | 2 Replies | 2294 Views | Created by dsagar - Thursday, August 8, 2013 2:27 PM | Last reply by dsagar - Thursday, August 8, 2013 6:07 PM -
0 Votes
OUTPUT clause in INSERT statement
When using INSERT, you can only access the inserted and deleted pseudo tables.Answered | 3 Replies | 1733 Views | Created by Murali_CHN - Thursday, December 6, 2012 1:50 PM | Last reply by Murali_CHN - Friday, December 7, 2012 5:21 AM -
3 Votes
Insert/update Statement on two identical tables
Hope this will help you declare @t1 table (c1 int) insert into @t1 values (1),(2),(3),(4),(5),(6) declare @i int = 3 declare @t2 table (c1 ...Answered | 7 Replies | 4985 Views | Created by pradeepmanne - Saturday, February 18, 2012 5:36 AM | Last reply by pradeepmanne - Saturday, February 18, 2012 12:08 PM -
0 Votes
Generating automatically insert statements
I have a table with 100 lines in my UAT (user aceptance tests) environment and I have to generated all insert statement to be used during my release to production.Answered | 5 Replies | 4236 Views | Created by Lant - Saturday, January 17, 2009 9:57 AM | Last reply by Jingyang Li - Sunday, January 18, 2009 4:43 PM -
0 Votes
Package with DataSource as T-Sql statement Table Variable
My sql looks like: set nocount on declare @t table(col1,col2) --declaring table variable insert into ...Answered | 5 Replies | 4755 Views | Created by prvnkreddy - Tuesday, November 17, 2009 8:08 PM | Last reply by Bharani 3010 - Wednesday, November 18, 2009 4:30 AM -
0 Votes
Updating multiple rows with 1 update statement - trigger that does insert question
Not exactly sure why that won't work.Answered | 8 Replies | 3801 Views | Created by bsh17 - Thursday, September 27, 2012 7:11 PM | Last reply by bsh17 - Friday, September 28, 2012 3:04 PM -
1 Votes
DeleteCommand Generated SQL - why is it so complex?
Because a record could have been modified after it was returned from the SELECT statement, but before the UPDATE or DELETE statement is issued, the automatically ...Answered | 4 Replies | 4035 Views | Created by ckelker - Wednesday, October 21, 2009 1:34 PM | Last reply by Michael Sun [MSFT] - Tuesday, October 27, 2009 10:42 AM -
2 Votes
Generating Insert Script using Select statement
Yes we can do this to make it possible i made i store procedure which works perfectly for any situations : visit this link for store ...Answered | 6 Replies | 14421 Views | Created by WonderPanda - Tuesday, January 17, 2012 6:11 PM | Last reply by neeraj prasad sharma - Wednesday, October 24, 2012 12:43 PM -
10 Votes
Method to generate insert statements for data in a table
You can find the text here: INSERT statement(s) generator Just as a simple and quick ...Answered | 7 Replies | 19557 Views | Created by Kemnet - Thursday, May 30, 2013 10:38 AM | Last reply by Arturas Drumsta - Sunday, December 6, 2015 4:01 AM -
0 Votes
How can I loop an SQL INSERT statement?
I don't understand why I would need a select statement.Answered | 3 Replies | 7465 Views | Created by Christan - Friday, August 31, 2012 3:26 PM | Last reply by Paul Ishak - Friday, August 31, 2012 6:13 PM -
1 Votes
Different ways to add Insert, Update, Delete commands to SqlDataAdapter object ?
It’s important to understand how the DataAdapter uses that SELECT statement as the basis for automatically generating the INSERT, UPDATE, and ...Answered | 2 Replies | 7002 Views | Created by JsFn - Saturday, July 10, 2010 2:08 PM | Last reply by Paras Sanghani - Monday, July 12, 2010 7:04 AM -
0 Votes
About the Insert, Update, and Delete operations in LINQ to SQL
There is a forum for Linq-2-SQL.Answered | 3 Replies | 827 Views | Created by e-mzRoy - Sunday, October 11, 2015 2:45 PM | Last reply by DA924 - Sunday, October 11, 2015 3:16 PM
No announcements
