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
- 4652 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
What is store procedure? When do you use?
What is the purpose of grouping data in a report?
What are user-defined functions (udfs) in sql server?
What are the different index configurations a table can have?
What is the difference between dbcc indexdefrag and dbcc reindex?
How do I run a trace in sql server?
List some of the rules that apply to creating and using a ‘view’
How many tables can be joined in SQL Server?
How do I open port 1433?
How to view existing indexes on an given table using sp_help?
What is the difference between DataRow.Delete() and DataRow.Remove()?
What is extent? Types of extents?
What do you mean by an execution plan?
Name three of the features managed by the surface area configuration tool? : sql server security
How do I find the sql server version?
