I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
IBM,
1093Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
888
How to maintain a fill factor in existing indexes?
Do you know what is a with(nolock)?
How to display a past time in days, hours and minutes?
Explain intellisense for query editing
Explain syntax for viewing trigger?
Can sql servers link to other servers?
Explain in details security in SQL azure?
Explain different types of lock modes in sql server 2000?
What is the data tier application?
Explain system functions or built-in functions? What are different types of system functions?
How to use “drop” keyword in sql server and give an example?
What is mean by candidate key?
How can a database be repaired?
What are the types of dml?
What is the difference between rank and dense_rank?