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?
What are indexes? When do you need to create Indexes?
4 Answers CarrizalSoft Technologies, HP,
What is the difference between the application object and session object?
What is an example of a foreign key?
How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?
4 Answers Credit Suisse, GCU, Symphony, TCS,
What is cdc in sql server?
if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..
17 Answers 3i Infotech, Rolta, TCS,
How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?
What are the types of stored procedures in an sql server?
What is a recursive stored procedure in sql server?
to explain sql server 2000 architecture & authentication
What is the difference between rank and dense_rank?
Explain the microsoft sql server delete command? : SQL Server Architecture