 Related Questions Latest Answer : Data objects are basic runtime entities. ... 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 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. ... Suppose you create a students record with 5 marks, total and average.How to filter the top 3 students which are getting high average. Read Answers (3) | Asked by : P.Prabhakaran 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
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
