What is create command?

0 Answers  

---

What is db stored procedure?

0 Answers  

---

Why use “in” clause in sql server?

0 Answers  

---

How can we write or define DDL statements in Sql server and DML statements?

3 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  

---

What are built in functions?

0 Answers  

---

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

8 Answers   Microsoft,

---

How to find 6th highest salary from Employee table ?

10 Answers  

---

What are the authentication modes in SQL Server?

4 Answers   IBM, iSmart,

---

Can you pass expressions to stored procedure parameters?

0 Answers  

---

What is dynamic cursor in SQL SERVER?

0 Answers  

---

What are scheduled tasks in sql server?

0 Answers  

---