I have Two table First have UserName and second is address,
in address table more than value relegated to UserName
table, i want to fetch 2nd address if exist other wise 1st
address access
Answer Posted / arun
use Coalesec(addrress1,address2)
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
Do you know data definition language, data control language and data manipulation language?
How to use the inserted and deleted pseudo tables?
What happens if time-only values are provided as date and time literals?
What are scheduled tasks in sql server?
What are clustered and non-clustered index?
What is difference between view and materialized view?
What is the difference between rank and dense_rank?
What are the ways available in sql server to execute sql statements?
Does group by sort data?
Explain the cursor lock types?
What is the distinction amongst delete and truncate?
When to use Inner join & when to use subquery?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
Tell me what is normalization? Explain different forms of normalization?
What stored by the master?