Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 2 Answers
- 5305 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
In what three ways is the return statement used in a stored procedure?
what data regions are and what are the different data regions?
Does table partitioning improve performance?
Why use sub query in sql server and list out types of sub queries?
What is spatial and temporal data?
What is store procedure? How do they work?
How to maintain a fill factor in existing indexes?
What is the default value of an integer data type in sql server 2005?
How to sort the query output with order by clauses in ms sql server?
What is set nocount on?
How to query multiple tables jointly?
Is truncate autocommit?
What is partitioned view?
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
What are the basic features of a trigger in ms sql server?
