Is sql server difficult to learn?

0 Answers  

---

What is difference between views and tables?

0 Answers  

---

how to count datewise data in sqlserver

4 Answers   CarrizalSoft Technologies, IndusInd Bank,

---

What is the difference between executequery () and executeupdate ()?

0 Answers  

---

Describe about first three Normal forms.

1 Answers   HP,

---

Explain about Joins?

0 Answers   Infosys,

---

What is subquery? Explain the properties of a subquery?

0 Answers  

---

What is nolock?

0 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  

---

Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 Answers  

---

What is self contained multi valued query?

0 Answers  

---

What is a derived table?

0 Answers  

---