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

Which stored procedure will you be running to add a linked server?

1 Answers  

what is a check constraint?

0 Answers  

how to get 25th row in any table in sqlserver can u tell me syntax

8 Answers  

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

0 Answers  

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

0 Answers   TCS,

Define views.

0 Answers  

Is it possible to delete duplicate rows in a table without using a temporary table ?

12 Answers   TCS,

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

0 Answers   TCS,

How many types of functions are there in sql server?

0 Answers  

What is the downside of using udf?

0 Answers  

What is the maximum size of a row in sql server?

0 Answers  

What is the difference between a clustered index and a non-clustered index?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories