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
Differentiate between mongodb vs. Sql server?
How to convert a unicode strings to non-unicode strings?
Explain user defined views?
What is the usage of sign function?
How to check if stored procedure is running in sql server?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
what is difference between view and Dip.
How to Update from select query in sql server?
Can we use custom code in ssrs?
How to count rows with the count(*) function in ms sql server?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What are the restraints imposed on the table design by a merge replication?
What are the differences between clustered and non-clustered index?
What is use of dbcc commands?
What is the difference between stored procedure and user defined functions?