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 the purpose of grouping data in a report?
How to start sql server browser service?
Which table keeps the locking information?
What is logon trigger?
Can group by and orderby be used together?
What is 'Join' and explain its various types.
What are unicode character string data types in ms sql server?
Explain the usage of floor function in sql server.
How do I shrink an ldf file?
What is the difference between sdf and mdf?
Explain about Views?
Explain transaction server isolation?
What is #temp and @table variable in SQL server?
Explain about nested stored procedure?
Which is the latest version of sql server and when it is released?