How to throw custom exception in Stored Procedure?
Tell me what is the significance of null value and why should we avoid permitting null values?
How to display a past time in days, hours and minutes?
Differentiate between delete and truncate.
What are approximate numeric data types in ms sql server?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
Explain what are partitioned views and distributed partitioned views?
What is the process of indexing?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
Explain system scalar functions?
Mention the different types of replication in sql server.
What are key constraints?
What is the purpose of object explorer and its features? : sql server management studio