What do you understand by recursive stored procedure?

989

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

1021

What is optimistic concurrency?

1094

What languages bi uses to achieve the goal?

1054

How to use order by with union operators in ms sql server?

1067

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

1074

what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

1047

What is the use of keyword with encryption.

1086

What is GUID in sql server?

1227

What is the use of nvl work?

1049

How can I check that whether automatic statistic update is enabled or not?

1098

What is difference between foreign key and unique key?

1052

What are transactions and its controls?

1109

How do I create a stored procedure in sql server?

1101

How do I setup a sql server database?

1129