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

Why is sql server log file full?

0 Answers  

if no size is defined while creating the database, what size will the database have? : Sql server administration

0 Answers  

How to count the number of duplicate items in a table?

3 Answers  

What is a non-clustered index?

0 Answers  

Define magic tables in sql server?

0 Answers  

What is buffer cash in sql server?

0 Answers  

How to delete existing rows in a table?

0 Answers  

Explain collation?

0 Answers  

Explain log shipping and mention its advantages.

0 Answers  

how we can use a database with php.

2 Answers   HCL, IT Solution,

in how many ways we can use count()

2 Answers  

What is a trace frag?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories