1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

Question Posted / sandeeep kumar


You have a table ‘test’ which is a copy of northwind employee table you have written a t..

Answer / Namita Singh

To ensure that the 'hiredate' field in the 'test' table is always up-to-date with the current date, you can create an AFTER INSERT and UPDATE trigger on the table. The trigger would contain a SET statement to update the 'hiredate' with GETDATE() function.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

CTE(common table expression)

1 Answers   Thomson Reuters,

If there is failure during updation of certain rows, what will be the state?

2 Answers  

What are the aggregate and scalar functions?

1 Answers  

What is the command to change the recovery model?

1 Answers  

What is read committed?

1 Answers  

What are trace files?

1 Answers  

what is the importence of the trigger in sqlserver2000?

1 Answers   ATI,

What is unpivot?

1 Answers  

Tell me what is difference between clustered and non clustered index?

1 Answers  

What is cursor in ms sql server?

1 Answers  

PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs.

6 Answers   APX,

What is index fragmentation in ms sql server?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories