What is an index?

8 Answers   Yardi Software,

---

What is mean by "fill factor" ? and what is mean by "Index "in sql?

1 Answers   iGate, Logica CMG,

---

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  

---

Does partitioning improve performance?

0 Answers  

---

What is the difference between count () and rowcount ()?

0 Answers  

---

Can we passed multiple recordset(set of records) using a Stored Procedure

2 Answers  

---

What happens when unicode strings concatenate with non-unicode strings?

0 Answers  

---

What are the different ways you can create databases in sql server?

0 Answers  

---

What is the difference between having clause and where clause in sql server?

0 Answers  

---

What are rows and columns?

0 Answers  

---

Is trigger fired implicitely?

2 Answers  

---

How to Check Whether a Global Temporary Exists in a SQL Database or not?

2 Answers  

---