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

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

0 Answers  

How do you clear a log file?

0 Answers  

What are the steps need to be take improve the speed of a SQLDATA Server?

2 Answers   IBM,

What are the different types of sql server replication? : sql server replication

0 Answers  

What are the two types of concurrency?

4 Answers  

What is b tree index?

0 Answers  

What are the common performance issues in sql server?

0 Answers  

How do I install sql server?

0 Answers  

What is change tracking in sql server?

0 Answers  

How do you simulate a deadlock for testing purposes

1 Answers  

What is the default value of CHAR type?

10 Answers   Bosch,

Do you know what is blocking?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories