Answer / ankita upadhyay

by using lookup function
syntax-
LOOKUP(lookup_value,lookup_vector);

lookup_value-contain the name of field(like id) about which you have to find info

lookup_vector-contain a range of row or column which contain value of respective ids

Answer / satish

Please help me.
Does we write trigger.
Or procedure or
anything else.

What is the purpose of sql profiler in sql server? : sql server database administration

0 Answers  

---

How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at Particular Ordinal Position in SQL Server 2005

2 Answers  

---

How to recreate an existing index in ms sql server?

0 Answers  

---

What is the STUFF function and how does it differ from the REPLACE function?

2 Answers  

---

How column data types are determined in a view?

0 Answers  

---

---

You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

0 Answers  

---

Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz

3 Answers  

---

when you create a database how is it stored? : Sql server database administration

0 Answers  

---

Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.

1 Answers  

---

Where can you find the error log information? : sql server database administration

0 Answers  

---

Explain for xml explicit mode?

0 Answers  

---

How many .ndf files can we create in Sql server 2005?

2 Answers   Wipro,

---