sql-server-2005 – IT Nursery

What good are SQL Server schemas?

June 1, 2022 by IT Nursery

I’m no beginner to using SQL databases, and in particular SQL Server. However, I’ve been primarily a SQL 2000 guy and I’ve always been confused by schemas in 2005+. Yes, I know the basic definition of a schema, but what are they really used for in a typical SQL Server deployment? I’ve always just used … Read more

How do I check if a Sql server string is null or empty

May 21, 2022 by IT Nursery

I want to check for data, but ignore it if it’s null or empty. Currently the query is as follows… Select Coalesce(listing.OfferText, company.OfferText, ”) As Offer_Text, from tbl_directorylisting listing Inner Join tbl_companymaster company On listing.company_id= company.company_id But I want to get company.OfferText if listing.Offertext is an empty string, as well as if it’s null. What’s … Read more