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
- 5174 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 spatial nonclustered index
How each E-R model constructs can be mapped to the relational model?
Describe in brief authentication modes in sql server.
Which table keeps information about stored procedures?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
what is normalization? : Sql server database administration
what's the difference between a primary key and a unique key? : Sql server database administration
Explain about temporary stored procedure?
What is a full text index?
What is outer join in sql server joins?
What are parameterized reports? What are cascading parameters in ssrs reports?
What is linked report?
Mention a few common trace flags used with sql server?
What is the data tier application?
How to filter records of table in SQL SERVER?
