 Related Questions Latest Answer : Data objects are basic runtime entities. ... 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 to deny insert, update, delete, update permissions for a specific user of a specific user database? Latest Answer : So what context is the user in? A role a datareader? Datawriter?You want no permissions?USE Drop USER In a role?EXEC sp_droprolemember 'rolename' , 'Member'single objects?Revoke SELECT, ... 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? 1. how to insert five rows in a table using single query(in ms-sql or oracle)2.how to delete duplicate values in a table. for example, the table containing five duplicate values(like name rani). Latest Answer : Inset data:insert into targettableselect top 5 * from sourcetabledelete data:1. select distinct * into targettable from sourcetable2. delete from sourcetable3. insert into sourcetable    select * from targettable ... 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
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
