No announcements
Found 2178541 threads
-
1 Votes
Insert XML data into a table
You can insert XML into a table, using the XML datatype.Answered | 3 Replies | 2036 Views | Created by Dave Papworth - Tuesday, March 5, 2013 10:16 AM | Last reply by Dave Papworth - Tuesday, March 5, 2013 3:53 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 | 3536 Views | Created by S.Vairamuthu - Friday, April 20, 2012 5:57 AM | Last reply by Hilary Cotter - Friday, April 20, 2012 1:03 PM -
0 Votes
Junction table data insertion
> This is first time I am trying to insert data in such junction table.Answered | 5 Replies | 1997 Views | Created by Inayat Ullah - Saturday, June 22, 2013 4:24 AM | Last reply by --CELKO-- - Saturday, June 22, 2013 6:21 PM -
0 Votes
table insert script with data
3)Now You can write Insert Script in Excel Sheet(search in google.)Answered | 9 Replies | 3038 Views | Created by skc_chat - Thursday, February 2, 2012 6:05 AM | Last reply by Syed Shakeer Hussain - Friday, February 3, 2012 6:39 AM -
0 Votes
Copy data from InMemory-Table to Normal Table
Copying data is independent of the internal storage systemOlaf Helper [ Blog] [ Xing] [ MVP]Answered | 1 Replies | 967 Views | Created by Shaik Chandol - Friday, February 6, 2015 11:31 AM | Last reply by Olaf Helper - Friday, February 6, 2015 11:33 AM -
0 Votes
un normalization data to normalized data
hi, say i have table student.Answered | 2 Replies | 3190 Views | Created by Kayadhu - Friday, July 27, 2012 3:09 PM | Last reply by Jordan Johnson Business Analyst - Friday, July 27, 2012 4:18 PM -
0 Votes
insert data to linked table
Hi, If you are doing it inside stored procedure you can use this method.Answered | 3 Replies | 6765 Views | Created by Heba Khojah - Thursday, October 13, 2011 10:12 AM | Last reply by Shkumar - Thursday, October 20, 2011 12:06 PM -
0 Votes
Inserting Data to a temporary table
The posted code is not syntactically correct IF(UserId = 0) wont compile successfully as it seems to be a table field. you cant use ...Answered | 6 Replies | 1346 Views | Created by zoldyk15 - Friday, March 21, 2014 5:49 PM | Last reply by zoldyk15 - Saturday, March 22, 2014 3:22 AM -
0 Votes
How to use an open query to insert data into a table?
Yes, this is how you insert data into SQL - you need to do an INSERT statement as you mentioned above.Answered | 1 Replies | 3075 Views | Created by Lee90s - Sunday, April 29, 2012 9:46 PM | Last reply by Ali Hamdar - Sunday, April 29, 2012 10:34 PM -
0 Votes
Junction table data insertion
Inayat, yes you have to manually insert the data to the junction table, because only busines knows about below things One Student belong to multiple ...Answered | 1 Replies | 2093 Views | Created by Inayat Ullah - Thursday, June 27, 2013 1:05 PM | Last reply by Parixit - Thursday, June 27, 2013 1:54 PM -
5 Votes
insert data from different tables into single table
Use NOT EXISTS instead.Answered | 4 Replies | 14426 Views | Created by Sd4u - Sunday, March 7, 2010 10:30 AM | Last reply by Albert Zheng - Thursday, March 18, 2010 1:15 AM -
0 Votes
How to Insert data into a Table
Temporal data should use ISO-8601 formats.Answered | 6 Replies | 2699 Views | Created by Noel20052006 - Tuesday, July 3, 2012 6:10 PM | Last reply by --CELKO-- - Tuesday, July 3, 2012 8:28 PM -
0 Votes
Fetch data from one table and insert into two tables in desired format
> I have similar to the following data in a table and it is not normalized.Answered | 4 Replies | 1404 Views | Created by vmrao - Friday, September 19, 2014 5:29 PM | Last reply by vmrao - Friday, September 19, 2014 8:43 PM -
0 Votes
inserting Dummy data into tables
Probably this might work without any syntax error.this will directly insert data into tables..Answered | 9 Replies | 8211 Views | Created by Sunil Yoganna - Monday, February 7, 2011 7:29 AM | Last reply by Sunil Yoganna - Tuesday, February 8, 2011 11:35 AM -
1 Votes
Data is inserted in order in the table
Rows in a table, like a resultset, have no inherent and reliable order.Answered | 2 Replies | 964 Views | Created by Shwegc - Wednesday, May 30, 2018 1:22 PM | Last reply by Shwegc - Wednesday, May 30, 2018 2:27 PM -
1 Votes
Concurently inserting data in table
You can load the different chunks of data into staging tables in parallel and then switch them into the partitions of the final target table.Answered | 2 Replies | 6431 Views | Created by Sarah2005 - Tuesday, May 29, 2012 7:50 PM | Last reply by Brent Greenwood - Wednesday, May 30, 2012 1:31 PM -
0 Votes
Inserting Data into a New Column on an already existing table
I would like to out that eName column into the emp_bonus table, complete with the correct corresponding data.Answered | 2 Replies | 1068 Views | Created by Marcus Claudius - Friday, August 17, 2018 2:48 PM | Last reply by Mohammad Waheed - Friday, August 17, 2018 4:28 PM -
0 Votes
inserting data in two tables
Fro inserting new rows in primary table and then in history table, you would better go for TRIGGER option or a post insert batch operation.Answered | 7 Replies | 3531 Views | Created by justin_rock - Friday, August 19, 2011 3:50 PM | Last reply by Kalman Toth - Wednesday, August 24, 2011 9:26 AM -
0 Votes
Insert data to Parent and Child table
Perhaps the best approach is to use OUTPUT clause which will guarantee that the correct value is captured for insert into child table.Answered | 10 Replies | 22610 Views | Created by SQL Insane - Wednesday, August 15, 2012 2:14 AM | Last reply by shriprasanna - Thursday, August 16, 2012 12:53 PM -
0 Votes
How to Normalize the table structure
Can you show us the typical query ?Answered | 8 Replies | 2073 Views | Created by BaskaranR - Tuesday, March 11, 2014 2:00 PM | Last reply by Louis Davidson - Wednesday, March 19, 2014 6:55 PM - Items 1 to 20 of 2178541 Next ›
No announcements