Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
How can you fetch alternate records from a table?
What is the difference between resultset and resultsetmetadata?
What is database replication?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
What do you understand by mirroring?
What are views used for?
where the connection string store in the database
What does dml stand for?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
What are different types of replication in sql server?
Explain the rules for designing files and file groups in sql server?
Scalability, Availability, Integration with internet, etc.)?
What is difference between after and before?
Can a table be moved to different filegroup?