What is nonclustered index on computed columns?

0 Answers  

---

What is the standby server?

0 Answers  

---

When do you create cluster and noncluster index?

5 Answers   Satyam,

---

What is index in an assignment?

0 Answers  

---

Can you tell me some of the common replication dmv's and their use? : sql server replication

0 Answers  

---

What are subqueries in sql server? Explain its properties.

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  

---

write query for fourth maximum salary from employee table

14 Answers   Mind Tree, SP Software,

---

what is diffrent between store procedure and trigger

2 Answers  

---

What is dirty page?

0 Answers  

---

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

0 Answers  

---

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

0 Answers  

---