What is primary key, unique key, and foreign key?

1015

How does a profiler work?

994

How many types of triggers in sql server?

1089

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1180

How to modify an existing stored procedure in ms sql server?

1137

What do you mean by acid?

1058

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

942

Why is the need for data conversion transformations?

1111

How to set database to be single_user in ms sql server?

1081

What are various limitations of the views?

1090

Are semicolons required at the end of sql statements in sql server 2005?

1038

What is blocking and how would you troubleshoot it? : sql server database administration

1096

How to delete an existing row with delete statements in ms sql server?

1151

What is molap and its advantage? : sql server analysis services, ssas

1036

Can we add our custom code in ssis?

1040