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.
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
Tell about MOM Tool(Microsoft Operator Manager)?
What does ss stand for sexually?
Explain what is analysis service repository?
In which sql server version report builder introduced?
How much is a sql server license?
What is difference between drop truncate and delete?
How to get a list of columns using the "sys.columns" view in ms sql server?
What is database dimension? : sql server analysis services, ssas
What is normalization? Explain its different types?
What are number line correlation administrators will use while working with a subquery?
What programming language would you use to create embedded functions in ssrs?
What are the types of containers in ssis?
what is the information that can be stored inside a bit column? : Sql server database administration
What is difference between clustered index and non clustered index?
What is row_number function?