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


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

Post New Answer

More SQL Server Interview Questions

What is the order by used for?

0 Answers  


Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

0 Answers  


How to configure odbc dsn with different port numbers?

0 Answers  


Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

0 Answers  


What is the maximum size of a dimension? : sql server analysis services, ssas

0 Answers  






Explain what are partitioned views and distributed partitioned views?

0 Answers  


What is msdb database? : SQL Server Architecture

0 Answers  


What are the different types of joins and what does each do?

2 Answers  


Explain how to maintain a fill factor in existing indexes?

0 Answers  


How will you optimize a stored procedure optimization?

0 Answers  


How can windows applications connect to sql servers via odbc?

0 Answers  


We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

0 Answers   Amdocs, Apps Associates,


Categories