var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: create table as
I want to create table from
selecting records from another table In sql server 7.0
create table tablename
select * from another table/view.
How is it possible ??
Thanx in Advance.
Hi To create a new table use
IT will fail if fred already exists
To empty and reuse then use
INSERT INTO fred
Did I get the question right ?
Originally Posted by dbtechzala
WOW, you sound like a DB2 person...
Just don't use SELECT * if it's for Production......
Quite right about the "*" of course... I'm just a lazy typer
As for the DB2 guess:- not even close !
Gerry, not you....dbtechzala
The syntax is close to a DB2 syntax.....
Be careful of the TRUNCATE though....it'll mark every page as being deleted...
no where clause there.....