Browse: Home / Database / SQL

SQL

Creating SQL Table from another table

By Sumit Gupta on January 2, 2008

Often we need to take quick backup of database with data before we can make changes in table. for this I create the image of table within same database, as it is the fastest method. It is one of the reason why one need to create image a table.. or copy one table from another. [...]

Posted in , | 1 Response

Setting/Resetting Auto increment value in MSSQL 2005

By Sumit Gupta on December 17, 2007

Once you create a table and what to reset autoincrement value of a table to your desire number, you need to set some system table values, which are not available for direct editing. To perform this you need to do following: SELECT OBJECT_ID,OBJECT_NAME(OBJECT_ID) AS TABLENAME, NAME AS COLUMNNAME, SEED_VALUE, INCREMENT_VALUE, LAST_VALUE, IS_NOT_FOR_REPLICATION FROM SYS.IDENTITY_COLUMNS ORDER [...]

Posted in , , | Leave a response

« Previous