Answer / Reema

No, the user will not be able to select from all tables. Although the user is a member of the public role which has select permission on all tables, their membership in the sales role may overwrite these permissions for certain tables. If the sales role does not have select permission on some tables, the user will not be able to query those tables.

Explain in brief about Microsoft SQL server?

1 Answers  

---

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

1 Answers  

---

What is dknf in normalization form?

1 Answers  

---

What is The Use Of TIMESTAMP DataType in SQL Server 2005?

6 Answers  

---

what is difference between primary key and Unique

8 Answers  

---

hi to all teachers,... Friends who write in the query mode Full text Search in Sql Server have experience Who make(Convert) this Stored Procedure as a normal Full text Search, which contains and .. Is used, into Advance of the tips I have thanked all friends perfection. Email : rezaafandi@yahoo.com Create PROCEDURE Sp_student @fname varchar(50), @lname varchar(50), @tel varchar(50), @code varchar(50), @adr varchar(50), @search_operation varchar(50), @totalRowCount bigint output AS begin if @search_operation = 'and' begin SELECT f3,f4,f5,f6,f7 FROM tb_student WHERE( f5 like '%' + @fname + '%' and f4 like '%' + @lname + '%' and f6 like '%' + @tel + '%' and f7 like '%' + @code + '%' and f3 like '%' + @adr +'%' ) select @totalRowCount = @@rowcount end

0 Answers  

---

Diffrences between sql server 2000 vs 2005

2 Answers   Thomson Reuters,

---

What is the differecne between equi-join and inner-join and natural join..Is there any difference or all are same?

8 Answers   Microsoft,

---

What is the name of the Database which IBM mainframe uses?

1 Answers   Wipro,

---

What is a database table?

1 Answers  

---

Do you know what is rank function?

1 Answers  

---

Can I recover a damaged SQL Server 2008 database with the undamaged .mdb and .ldf files?

3 Answers   Apple,

---