Explain the new features of SQL server 2000?

1 Answers  

---

How do you rename a table in sql server?

0 Answers  

---

What are binary string data types in ms sql server?

0 Answers  

---

What is update_statistics command?

0 Answers  

---

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

0 Answers  

---

Explain how to send email from sql database?

0 Answers  

---

What is deploy, process and build? : sql server analysis services, ssas

0 Answers  

---

What is the use of for clause?

0 Answers  

---

What does it mean to manipulate data?

0 Answers  

---

Give the query of getting last two records from the table in SQL SERVER?

0 Answers   Petranics Solutions,

---

What is indexing in sql server with example?

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  

---