how to create table using a subquery in sql server
Home > IT Answers > Development > how to create table using a subquery in sql s...
carbuncle
0 pts.
0
Q:
how to create table using a subquery in sql server
SQL, SQL Server


hai everybody,
everyone knows tht a table can be created using a subquery in oracle.||y how to do the same task in sql server.

in oracle i tried as "create table table1 as select * from table2"

my requirement is to create dynamic tables in stored procedure based on existing tables.

so desperately i need help from IT kings like u..
ASKED: Feb 8 2006  5:53 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
gauravsapra
0 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Select * into new_table from old_table;
Last Answered: Feb 8 2006  6:46 AM GMT by gauravsapra   0 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0