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 an identity?

1076


Does view occupy space?

989


What are the differences between web role and worker role?

124


sql database suspect We have a sql database that is showing as suspect. How can we recover?

1997


How to execute the cursor queries with "open" statements?

1238


Define cursor locking

1059


Explain difference between control flow and data flow?

1014


Can we delete data from a view?

978


What is the difference function and stored procedure?

1109


List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

187


How to create view in stored procedure sql server?

1055


Explain about nested stored procedure?

1081


What is the latest version of microsoft sql server?

1114


What is sql injection? How to protect against sql injection attack?

1036


Can the “if update (colname)” statement be used in a delete trigger?

1033