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?

957

What is the use of RDBMS?

994

How to enforce security in sql server? : sql server security

1098

What is an entity-relationship diagram (erd)?

1202

Define inner join in sql server joins?

1048

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1799

can you instantiate a com object by using t-sql? : Sql server database administration

991

Explain primary key?

951

What's the information that can be stored inside a bit column?

994

what method you can use to reduce the overhead of Reporting Services data sources?

253

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

1114

What is triggers and its types?

1005

Explain encryption of entire databases without the need for application changes in sql server 2008?

1036

What are four major operators that can be used to combine conditions on a where clause?

1036

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

993