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

I am learning Testing, so i want to learn SQL also because SQL is important for Testing. I want to know which is best Institute in Ameerpet or SR Nagar or any other place in Hyd? Please help me.

7 Answers  

How to a Query to copy data from on table to another table.

6 Answers   Cap Gemini,

Explain subquery and state its properties?

0 Answers  

How to recompile stored procedure at run time?

0 Answers  

Is truncate a dml command?

0 Answers  

What is normalization and denormalization in sql server?

0 Answers  

What is the most common type of join?

0 Answers  

Explain what is dbcc?

0 Answers  

What are the different type of replication in sql server?

0 Answers  

What does ss stand for sexually?

0 Answers  

How to create a dml trigger using create trigger statements?

0 Answers  

What happens if we shrink log file in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories