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
What is an identity?
Does view occupy space?
What are the differences between web role and worker role?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
How to execute the cursor queries with "open" statements?
Define cursor locking
Explain difference between control flow and data flow?
Can we delete data from a view?
What is the difference function and stored procedure?
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
How to create view in stored procedure sql server?
Explain about nested stored procedure?
What is the latest version of microsoft sql server?
What is sql injection? How to protect against sql injection attack?
Can the “if update (colname)” statement be used in a delete trigger?