Answer / hokar

SELECT * INTO tabname1 FROM tabname2 WHERE 1=2 (TO copy
only the structure)

Answer / pradip jain

SELECT * INTO tblNew FROM tblOld WHERE 1=2

Answer / kumar.t

Select * into newnew1 from newnew WHere 1=2

Answer / jaydev

SELECT TOP 0* INTO tabname2 FROM tabname1

Answer / naik

select * into oldtable from newtable where oldtable
=newtable

Answer / kunal sain

create table table_name
as select * from another_table
where 1>2;

Answer / narsing

SELECT * INTO tabname1 FROM tabname2 WHERE 1<>2 (TO copy
only the structure)

How to access the inserted record of an event?

0 Answers  

what is difference between view and Dip.

0 Answers   IBM, L&T,

what is meant by deafult in sql server?

2 Answers  

How will you collect the date from current date to last older 6 days date in sql server 2005

4 Answers  

How does using a separate hard drive for several database objects improves performance right away?

0 Answers  

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

0 Answers  

Hi All, I want to display all duplicate records in the table. My query has to fetch all the records which are duplicate(First Name or Last Name). Also I want the ability to also pull names where there might be a middle initial placed in the end of the first name field, (i.e., "Maria Z. " vs. "Maria") as well. Please guide me to find this. Table: ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 4 Shawn Livermore 5 Prem S 6 Jony Hoffman H 7 Zach Modan I need the query to filter......... ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 6 Jony Hoffman H 7 Zach Modan I hope this example will give you clear idea..... Thanks in Advance Prem

2 Answers  

What are various ways to enhance the ssrs report?

0 Answers  

How to connect sql server management studio express to sql server 2005 express?

0 Answers  

What command do we use to rename a db?

5 Answers   IBM,

Explain DBMS, RDBMS?

6 Answers  

What is INTVAL( )and where we use Plz any body help me

1 Answers