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?

0 Answers  

---

What is implicit mode in sql server?

0 Answers  

---

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

0 Answers  

---

How to specify the collation for a character data type in ms sql server?

0 Answers  

---

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

0 Answers  

---

---

Define full outer join?

0 Answers  

---

What is entity data services?

0 Answers  

---

What is a field name?

0 Answers  

---

What is the use of for clause?

0 Answers  

---

What is the default schema of your login session in ms sql server?

0 Answers  

---

What are cursors? Name four types of cursors and when each one would be applied?

3 Answers   Adea Solutions,

---

how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100

6 Answers   ABC, HCL,

---