How to use old values to define new values in update statements in ms sql server?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

Write a SQL command to insert and update only a particular field?

0 Answers   ADITI,


Can a trigger be created on a view?

0 Answers  


What are character string data types in ms sql server?

0 Answers  


What does null mean?

0 Answers  


you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

0 Answers  






I have a table Events Events containing cardno,time,id,name- -each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

0 Answers  


What are the disadvantages of primary key and foreign key in SQL?

0 Answers   Alcatel-Lucent,


What are Spatial data types in SQL Server 2008

0 Answers   Infosys,


Which is faster statement or preparedstatement?

0 Answers  


What is an index?

8 Answers   Yardi Software,


Explain acid?

0 Answers  


1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers  


Categories