 Related Questions I have a table in sql server with two fields named 'start_time' and 'stop_time'. both fields have datatype set as 'datetime'. now I want to subtract the 'start_time' from 'stop_time'? I have tried datediff() fuction,but no use. I want the correct outpput of date as well as time . Need help as early as possible. Latest Answer : use TableLocks or RowLocks to prevent the other user from modifying the data when the previous user is using the same data. ... Assume that I have created a employees table which has 10 records. How to create a stored procedure to export all the records into the log file. Read Answers (3) | Asked by : vani Error While creating BACKUP:I am Creating FullBackup for one database Named Postings.I executed below Query and i am getting The Below error message.USE mastergoEXEC SP_ADDUMPDEVICE 'disk','PostingsBac','E:BACKUPPostingsBac.BAK'BACKUP Latest Answer : This is basically a problem with the physical path of the Backup device, I suppose. Be sure the physical path that you are giving has full access from your Windows user Account or not. ... Read Answers (1) | Asked by : Ramesh.M Tags : Backup Latest Answer : Yes, there is table partitioning in SQL Server. Unfortunately I don't know how to do that, If anyone knows that, let me know. ... How do I lock a column, once records are entered into the table they can not be edited. Also how can I lock the field where only certain values are accepted? Latest Answer : May be you can use Constraints. ... Latest Answer : We can copy the Table structure also from one table to another tableExample: CREATE table emp1 as ... Read Answers (3) | Asked by : penchal Latest Answer : select * into new table name from old table name where 1=0 ... Read Answers (2) | Asked by : mvkrishna Latest Answer : Take a full backup and restore or dettach 2000 db copy .mdf and ldf to 2005 server. Attach then switch compatiblity mode to 90 then update statistics. Once you go to 2005 you can go back. ... Read Answers (1) | Asked by : santanu What is the Difference between Attach and Restore of a Database? Latest Answer : Database attach is faster as compaired to Database Restore. SO if you have both options then may be you can choose Database attach than Database Restore. ... Tags : Restore
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
