No announcements
Found 2179952 threads
-
1 Votes
Insert XML data into a table
You can insert XML into a table, using the XML datatype.Answered | 3 Replies | 1713 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
Copy data from InMemory-Table to Normal Table
Copying data is independent of the internal storage systemOlaf Helper [ Blog] [ Xing] [ MVP]Answered | 1 Replies | 741 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
insert data to linked table
Hi, If you are doing it inside stored procedure you can use this method.Answered | 3 Replies | 6445 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
un normalization data to normalized data
hi, say i have table student.Answered | 2 Replies | 2873 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
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 | 1008 Views | Created by zoldyk15 - Friday, March 21, 2014 5:49 PM | Last reply by zoldyk15 - Saturday, March 22, 2014 3:22 AM -
0 Votes
Junction table data insertion
> This is first time I am trying to insert data in such junction table.Answered | 5 Replies | 1666 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
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 | 1757 Views | Created by Inayat Ullah - Thursday, June 27, 2013 1:05 PM | Last reply by Parixit - Thursday, June 27, 2013 1:54 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 | 3264 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
How to Insert data into a Table
Temporal data should use ISO-8601 formats.Answered | 6 Replies | 2390 Views | Created by Noel20052006 - Tuesday, July 3, 2012 6:10 PM | Last reply by --CELKO-- - Tuesday, July 3, 2012 8:28 PM -
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 | 708 Views | Created by Shwegc - Wednesday, May 30, 2018 1:22 PM | Last reply by Shwegc - Wednesday, May 30, 2018 2:27 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 | 7834 Views | Created by Sunil Yoganna - Monday, February 7, 2011 7:29 AM | Last reply by Sunil Yoganna - Tuesday, February 8, 2011 11:35 AM -
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 | 3244 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
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 | 2840 Views | Created by Lee90s - Sunday, April 29, 2012 9:46 PM | Last reply by Ali Hamdar - Sunday, April 29, 2012 10:34 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 | 6197 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
table insert script with data
3)Now You can write Insert Script in Excel Sheet(search in google.)Answered | 9 Replies | 2747 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 -
1 Votes
Help with inserting data into table
/* CREATE TABLE [dbo].Answered | 5 Replies | 6076 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
How to Normalize the table structure
Can you show us the typical query ?Answered | 8 Replies | 1802 Views | Created by BaskaranR - Tuesday, March 11, 2014 2:00 PM | Last reply by Louis Davidson - Wednesday, March 19, 2014 6:55 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 | 816 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
Use dynamic sql to 'insert into @table'
You may also have developed some bad habits - an insert statement should generally specify the columns that will be populated in the inserted ...Answered | 9 Replies | 5245 Views | Created by TheBrenda - Friday, September 13, 2013 6:41 PM | Last reply by scott_morris-ga - Monday, September 16, 2013 2:32 PM -
1 Votes
Uses of normalization
One table only River (violation of 1st Normal Form!).Answered | 15 Replies | 8556 Views | Created by Rajendra Kumbar - Tuesday, February 9, 2010 4:35 AM | Last reply by Brian Tkatch - Tuesday, February 9, 2010 8:01 PM - Items 1 to 20 of 2179952 Next ›
No announcements