Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How do you find value of first column before inserting value
into the second column in the same table for checking that second column must have different value than first column.

Question Posted / satish

Answers were Sorted based on User's Feedback



How do you find value of first column before inserting value into the second column in the same tab..

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

Is This Answer Correct ?    2 Yes 0 No

How do you find value of first column before inserting value into the second column in the same tab..

Answer / satish

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

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More SQL Server Interview Questions

Is port 1433 secure?

0 Answers  

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

0 Answers  

When cursors are useful?

0 Answers  

Define the term DML, DDL and DTL?

1 Answers  

When would you use it?

0 Answers  

why would you call update statistics? : Sql server database administration

0 Answers  

What is a partition key?

0 Answers  

Define model database?

0 Answers  

Tell me about Triggers?

3 Answers   Cap Gemini,

What the difference between UNION and UNIONALL?

0 Answers   HCL,

Explain what is it unwise to create wide clustered index keys?

0 Answers  

what is macro?

5 Answers   Excel, Global Innovation, Wipro,

For more SQL Server Interview Questions Click Here
Categories