Wednesday, April 29, 2009

MSSQL material

MSSQL material:

A simple Query to display date and time in MSSQL database is :

select getdate()


Creation of new table from existing table in MSSQL:
The easiest way to create a table from an existing table or make a copy of table is often required while working with MSSQL db and method to create it is as follows:

select *
into test1copy --- new table
from test1 --- source table

Started working on this, hopefully i will post my learning here...........

No comments:

Post a Comment