I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
IBM,
575Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
536
What are system databases into sql server (2005/2008)?
What does it mean to manipulate data?
Explain trigger classes i.e. Instead of and after trigger?
What type of Index will get created after executing the above statement?
What is the recovery model?
Explain candidate key, alternate key, and composite key?
If a stored procedure is taking a table data type, how it looks?
How do you implement session management in SQL Server mode?
Explain about builtinadministrator?
whats the maximum size of view state??
What is table-valued sub query?
How to use group functions in the select clause in ms sql server?
What are commit and rollback in sql?
Describe different Processing Modes offered by SSRS?
Explain about system database?