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
- 5283 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
Define Joins?
What is rs.exe utility?
What do you mean by normalisation?
What is the use of “join” in sql server?
Explain temporary table vs table variable by using cursor alternative?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What are the default system databases in sql server 2000?
What are the built in functions in sql server?
Explain Reporting Life Cycle?
What is the difference between seek predicate and predicate?
what is hash nonclustered index
Explain cursor as data base object?
How to enter unicode character string literals in ms sql server?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
Why does sql studio use a single registered database repository? : sql server management studio
