No announcements
Found 2031960 threads
-
0 Votesinsert into 2 tables sql server 2005
Use this table in join for second insert.Answered | 5 Replies | 4313 Views | Created by collie12 - Thursday, May 6, 2010 12:55 PM | Last reply by collie12 - Thursday, May 13, 2010 10:18 AM
-
0 Votes
Insert into 2 SQL tables at once and produce Guid
There is a different way also but only if there is no FK relationship between 2 tables: insert into Job (JobID, JobTitle) OUTPUT ...Answered | 2 Replies | 2685 Views | Created by dev-13 - Monday, April 2, 2012 10:19 PM | Last reply by Naomi N - Monday, April 2, 2012 10:35 PM -
0 Votes
Insert Query from unleated 2 tables
Actually 2 columns in table 3.Answered | 11 Replies | 1494 Views | Created by akhilrajau - Thursday, May 9, 2013 12:30 PM | Last reply by akhilrajau - Thursday, May 9, 2013 2:07 PM -
1 Votes
Insert to a table after an Insert Trigger.
create trigger trgInsert on dbo.Account after insert as Insert into FlowDB.dbo.CustomerInfo(no,name) select no,name from ...Answered | 1 Replies | 1080 Views | Created by Ashis_K - Sunday, April 26, 2015 7:05 PM | Last reply by Stan210 - Sunday, April 26, 2015 7:22 PM -
1 Votes
Triggers - after insert trigger on table 1 fires a before insert trigger on table 2.
2) the instead of trigger needs to actually do the insert itself after you validate acceptable conditions.Answered | 4 Replies | 4620 Views | Created by krkolli - Tuesday, September 29, 2009 2:49 PM | Last reply by krkolli - Tuesday, September 29, 2009 5:37 PM -
3 Votes
insert into table
Please avoid postingAnswered | 3 Replies | 1359 Views | Created by PriviyaBelieves - Monday, June 24, 2019 10:29 AM | Last reply by scott_morris-ga - Monday, June 24, 2019 12:22 PM -
0 Votes
Insertion in A table
Hi, There are four columns in your table .If you do not provide the column list in your Insert statement, barring identity columns sql server will expect ...Answered | 2 Replies | 741 Views | Created by anupkumarmishra - Thursday, July 3, 2014 12:15 PM | Last reply by Amit Deshmukh(SELECT MAX (FUN) FROM LIFE ) - Thursday, July 3, 2014 12:49 PM -
1 Votes
Want to insert a new row in table-2 when insert rows in table-1
Hi, I have two tables in my database (table-1 and table-2).Answered | 4 Replies | 4237 Views | Created by Kashif Chotu - Sunday, May 3, 2009 8:57 AM | Last reply by Jeffrey N. Sarmiento - Monday, May 4, 2009 7:45 AM -
1 Votes
Help with inserting data into table
/* CREATE TABLE [dbo].Answered | 5 Replies | 6281 Views | Created by Pure Deal - Friday, July 16, 2010 4:13 PM | Last reply by Pure Deal - Saturday, July 17, 2010 9:16 AM -
0 Votes
Want to Insert Data into Table-1, which exists on Server-1 from Table-2, which exists on Server-2.
Hi, In addition to the reply above, we need to specify the schema name in your statements as follows: INSERT INTO ...Answered | 3 Replies | 5169 Views | Created by Shivendoo Kumar Dubey - Tuesday, January 4, 2011 10:28 AM | Last reply by Rishabh K - Thursday, January 6, 2011 6:18 AM -
0 Votes
Insert data to Parent and Child table
Hence I recommend using IDENT_CURR(Parent Table) which will ensure we pick up the last inserted identity from the Parent Table and use it for ...Answered | 10 Replies | 22099 Views | Created by SQL Insane - Wednesday, August 15, 2012 2:14 AM | Last reply by shriprasanna - Thursday, August 16, 2012 12:53 PM -
1 Votes
SqlDataSource insert: How to get values from a SQL Command?
Thanks, Hermano.Answered | 2 Replies | 6192 Views | Created by Bruno Saboia de Albuquerque - Sunday, October 19, 2008 2:34 PM | Last reply by Bruno Saboia de Albuquerque - Monday, October 20, 2008 11:52 AM -
0 Votes
insert into table
So, if you have 2 same IDs, it will pick up the min. date (for the same member)For every expert, there is an equal and opposite expert. - Becker's ...Answered | 7 Replies | 986 Views | Created by coool_sweet - Friday, May 30, 2014 3:54 PM | Last reply by --CELKO-- - Friday, May 30, 2014 10:31 PM -
0 Votes
Joining tables and inserting flag
USE tempdb IF object_id('tempdb..table1') IS NOT NULL DROP TABLE table1 IF object_id('tempdb..table2') IS NOT ...Answered | 4 Replies | 875 Views | Created by lrj1985 - Friday, October 10, 2014 11:21 AM | Last reply by Visakh16 - Friday, October 10, 2014 11:56 AM -
1 Votes
Using Hashbytes and inserting into a table
Here are 2 ways declare @a as table(col1 int identity(1,1), col2 char(1)) insert into @a(col2) values('a'), ('b'), ...Answered | 5 Replies | 11671 Views | Created by MrFlinstone - Friday, January 18, 2013 6:14 PM | Last reply by Tom Phillips - Tuesday, January 22, 2013 2:27 PM -
0 Votes
Delete records if it is not getting inserted and also in the related tables
> Every stored proc does some kind of insert into one or more tables and involve cursors for inserting records [sic] and they are executed one after another [sic].Answered | 8 Replies | 4230 Views | Created by JR1811 - Wednesday, September 15, 2010 5:35 PM | Last reply by JR1811 - Friday, September 17, 2010 9:57 PM -
0 Votes
Does a temp table is reuired to insert into a table
I would just insert the records into the history table and delete the records from your main table by joining back to it on the delete with the PK.Answered | 2 Replies | 937 Views | Created by Jeevan Vinay - Monday, March 30, 2015 2:47 PM | Last reply by chipmunkofdoom2 - Monday, March 30, 2015 6:37 PM -
0 Votes
query to insert images into table
Hello, If you use the Insert query, you will add a new row into the table.Answered | 4 Replies | 23657 Views | Created by fanu987 - Sunday, December 23, 2012 6:10 PM | Last reply by Fanny Liu - Monday, December 24, 2012 6:46 AM -
0 Votes
Inserting records into a table 2 from table 1 to avoid duplicates.
The best I can do with so little is: CREATE VIEW Table2Distinct -- awful table name!Answered | 5 Replies | 1230 Views | Created by NitaM - Monday, November 2, 2015 5:59 PM | Last reply by NitaM - Tuesday, November 3, 2015 2:27 PM -
0 Votes
Insert / Add data into a Table
If you want ONLY the new data replicated you can put the schema (tables) in place on d2, and then do a no sync subscription from the publication you create on t1.Answered | 2 Replies | 3370 Views | Created by S.Vairamuthu - Friday, April 20, 2012 5:57 AM | Last reply by Hilary Cotter - Friday, April 20, 2012 1:03 PM - Items 1 to 20 of 2031960 Next ›
No announcements
