What is public role in sql server?

1206

What is dynamic cursor in SQL SERVER?

1128

What are character string data types in ms sql server?

1341

What is right outer join in sql server joins?

1211

You want to implement the many-to-many relationship while designing tables. How would you do it?

1043

Explain Normalization and DE normalization

1156

What are pessimistic lock and optimistic lock?

1134

When would you use the stored procedures or functions?

1050

Who is the owner of a schema in ms sql server?

1114

How do I install only the client tools of sql server 2000?

1119

Can a cursor be updated? If yes, how you can protect which columns are updated?

1173

What are the different types of columns types constraints in the sql server?

1123

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

1059

What is an execution plan? How would you view the execution plan?

1123

How to list all triggers in the database with sys.triggers in ms sql server?

1121