Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1071

How can you fetch alternate records from a table?

955

What is the difference between resultset and resultsetmetadata?

949

What is database replication?

1131

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

2474

What do you understand by mirroring?

992

What are views used for?

1011

where the connection string store in the database

2063

What does dml stand for?

943

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1195

What are different types of replication in sql server?

1080

Explain the rules for designing files and file groups in sql server?

981

Scalability, Availability, Integration with internet, etc.)?

2874

What is difference between after and before?

1073

Can a table be moved to different filegroup?

968