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
What is tcl in sql server?
What is difference between views and tables?
What is report snapshot?
How the authentication mode can be changed?
Explain the advantages of merge replication?
What is indexing explain it with an example?
What are the tool windows in sql server management studio? : sql server management studio
What is normalization and what are the advantages of it?
How connect excel to sql server?
Why truncate is ddl command?
Can you explain full-text query in sql server?
How to connect to a sql server using odbc_connect()?
What is the maximum size of column in sql server?
What is subquery? Explain the properties of a subquery?
How do I find query history in sql server?