hi al....'m jus a studen tryin to learn sql server..
rite now m using sql server 2000..
i'd like to transfer an existing database from my comp to anohthr ...
im sure this portability issue can b taken care of by taking a backup of the db. and then later adding it into the othr machine...
please guide me as to how i can take the bkup and then later how i can add this database on to the other machine...
thx..
hanish
Lookup the following sections in Books Online (or MSDN): BACKUP and RESTORE.hi guys,
just a question regarding database design
i have a table with an auto-generated primary key but the problem is this:
say i have 4 records,so logically they'll be numbered 1 to 4.so the problem is whenever i delete all records and add new ones,the numbering will start from 5 and not 1 again.
how do i remedy this?
thanx
Two ways:
1. Use TRUNCATE instead of delete if you are deleting *all* rows
2. Use "DBCC CHECKIDENT(TABLE_NAME_HERE, RESEED, 0)" to reset the current identiy value back to required position if you want to use "DELETE" instead of "TRUNCATE"
|||Another common practice is to create some sort of an ID column as well as the auto-generated primary key. Sounds like this way work better for you in this case if you plan on frequently deleting, inserting, etc.
Thanks,
Sam Lester (MSFT)
hi,
wanna ask.is TRUNCATE only used if i want to delete all records in a table?
how am i able to do this if i only want to delete a selected row and all rows? say i got 4 records and i only want to delete the 2nd record.
so will the 3rd record be numbered as 2 now or will it remain as 3?
