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
- 5425 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
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
What are the main sources of data?
Explain primary key in sql server?
Can I work with several databases simultaneously? : sql server management studio
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
What is the use of toad or sqldbx.?
Explain how many types of relationship?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
How to provide values to stored procedure parameters in ms sql server?
What is the difference between seek predicate and predicate?
Do you know what are the differences between lost updates and uncommitted dependencies?
How to create a view with data from multiple tables?
Tell me what is the difference between locking and multi-versioning?
What is the difference between clustered index and primary key?
What do you mean by an execution plan? Why is it used? How would you view it?
