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.

Explain the steps to create and execute a user-defined function in the sql server?

0 Answers  

---

How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)

2 Answers  

---

What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue

2 Answers   IBM,

---

What is the size of transaction log file?

0 Answers  

---

What is a non equi join?

0 Answers  

---

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

0 Answers  

---

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

---

How to create a Master database in SQL server ?

0 Answers   MCN Solutions,

---

Do you know what are acid properties of transaction?

0 Answers  

---

What are number line correlation administrators will use while working with a subquery?

0 Answers  

---

Can you type more than one query in the query editor screen at the same time?

0 Answers  

---

In which tcp/ip port does sql server run? Can it be changed?

0 Answers  

---