What are some examples of schemas?

980

What are the advantages of using stored procedures in sql server?

1011

write an SQL query to list the employees who joined in the month of January?

1677

How to list all stored procedures in the current database using ms sql server?

1132

Explain Reporting Life Cycle?

129

how would you store your query in an SSRS report or a Database server?

162

What is the name of the Database which IBM mainframe uses?

987

What is nonclustered index with included columns ?

965

Tell me in brief how sql server enhances scalability of the database system?

990

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

1047

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

1038

Explain the creation and execution of a user-defined function in the sql server?

1051

How to add more data to the testing table in ms sql server?

1087

Is the order of columns in the set clause important in ms sql server?

968

What are dml (data manipulation language) statements in ms sql server?

983