How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

703

What are the types of lock supported by ?

698

Which are the third-party tools used in sql server and why would you use them?

568

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

690

Explain about nested stored procedure?

671

Explain filestream storage of sql server 2008?

597

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

1189

Define Joins?

685

How to execute stored procedure in select statement sql server?

614

Tell me what are the advantages of using stored procedures?

646

What are the methods used to protect against sql injection attack?

689

What is the default value of an integer data type in sql server 2005?

653

Explain transaction isolation levels in sql server?

636

What is Extended user-defined?

624

What is serializable?

747