 Related Questions Latest Answer : Data objects are basic runtime entities. ... Assume that I have created a employees table which has 10 records. How to create a stored procedure to export all the records into the log file. Read Answers (3) | Asked by : vani Latest Answer : We can copy the Table structure also from one table to another tableExample: CREATE table emp1 as ... Read Answers (3) | Asked by : penchal Latest Answer : select * into new table name from old table name where 1=0 ... Read Answers (2) | Asked by : mvkrishna How we can pulish the connectivity of SQL query to the HTML file or web page? Please Explain. Latest Answer : Normally connection of SQL file to a web page can be done in two ways1. Through the code2. In web config fileIf we give through the code, we need to alter the relevant pages, where as if we give through web config , this will be a common file and will ... How to transfer data from a text file to SQL table, Which is the best method to do that? Latest Answer : By using OPENROWSET commandExample: INSERT INTO dbo.ImportTestSELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:ImportData.xls', ... How to read the data from a pdf in SSIS? How to insert data in multiple tables at same time. using SQL Server 2000 Latest Answer : Here is the example for you question.
USE YourDB
GO
INSERT INTO
MyTable (FirstCol,
SecondCol)
SELECT ‘First’
,1
UNION ALL
SELECT ‘Second’
,2
UNION ALL
SELECT ‘Third’
,3
UNION ALL
SELECT ‘Fourth’
,4
UNION ALL
SELECT ... How to insert bulk data into the SQL Server? Latest Answer : Table to table data transferselect * into targettable from tableflat file to table data transferuse bcp command bcp pubs2..publishers in pub_out -c -t , -r r ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
