what command is used to create a table by copying the
structure of another table?
Answer Posted / pradip jain
SELECT * INTO tblNew FROM tblOld WHERE 1=2
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
What is the security model used in sql server 2005?
What is SQL Azure?
Does order by actually change the order of the data in the tables or does it just change the output?
What is the difference between grant and with grant while giving permissions to the user?
How does clustered and non clustered index work?
What are the differences between web role and worker role?
last function used in MS Access to convert sql what function will use in sql
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
How can I change procedure name in sql server?
What is difference between join and natural join?
A trigger can reference objects outside the current database? State true or false.
What will be the maximum number of index per table?
What is encryption key?
What is inline table-value user-defined function?