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

What is catalog views?

0 Answers  

What is serializable?

0 Answers  

How get current date in SQL server 2000

4 Answers   Cap Gemini, Polaris,

Can you explain different types of locks in sql server?

0 Answers  

How to filter records of table in SQL SERVER?

0 Answers   Petranics Solutions,

Do you know what is replace and stuff function in sql server?

0 Answers  

Do you know what are the reporting services components?

0 Answers  

What is the meaning of sql server?

0 Answers  

What is trigger ?

7 Answers   Cap Gemini, SQL,

How to swap the data of two columns in a table. both the columns containing varchar values.

9 Answers  

Explain alternate key, candidate key and composite key in sql server?

0 Answers  

What is the default fill factor value?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories