What is de-normalization and what are some of the examples of it?

0 Answers  

---

Where are magic tables stored ? Is it in the same database where it is created ?

4 Answers  

---

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

0 Answers  

---

Describe how to use linked server?

0 Answers  

---

what is maximum size of temp db?

4 Answers   iSoft,

---

How many types of Cursor in SQL SERVER?

1 Answers  

---

How to retrieve error messages using odbc_errormsg()?

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  

---

What should be the fill factor for indexes created on tables? : sql server database administration

0 Answers  

---

What is BCNF? How is it better than 2NF & 3NF?

0 Answers   Essar,

---

What is a trigger? Why we need it?

0 Answers   Accenture,

---

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

2 Answers  

---