Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is the recommended total size of your memory optimized tables?

955


What are trace files?

936


Do you know what are pages and extents? : SQL Server Architecture

980


Explain some stored procedure creating best practices or guidelines?

909


What is the purpose of forms?

936


What is sql server programming?

1021


Why do you want to join software field as you have done your BE in Electronics?

2131


How to drop an existing table?

988


What are the types of joins in sql?

1101


What is TDS(Tabular Data Stream) Gateway?

121


How dts is used to extract, transform and consolidate data?

1061


Describe in brief system database.

999


What are the advantages of user-defined functions over stored procedures in sql server?

1017


Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

968


How do you create an execution plan?

926