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 the recommended total size of your memory optimized tables?
What are trace files?
Do you know what are pages and extents? : SQL Server Architecture
Explain some stored procedure creating best practices or guidelines?
What is the purpose of forms?
What is sql server programming?
Why do you want to join software field as you have done your BE in Electronics?
How to drop an existing table?
What are the types of joins in sql?
What is TDS(Tabular Data Stream) Gateway?
How dts is used to extract, transform and consolidate data?
Describe in brief system database.
What are the advantages of user-defined functions over stored procedures in sql server?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
How do you create an execution plan?