I have a very basic LEFT OUTER JOIN to return all results from the left table and some additional information from a much bigger table. The left table contains 4935 records yet when I LEFT OUTER JOIN it to an additional table the record count is significantly larger. As far as I’m aware it is … Read more
I have months stored in SQL Server as 1,2,3,4,…12. I would like to display them as January,February etc. Is there a function in SQL Server like MonthName(1) = January? I am trying to avoid a CASE statement, if possible. 33 Answers 33 I think this is the best way to get the month name when … Read more
I’m looking for a way to temporarily turn off all DB’s constraints (eg table relationships). I need to copy (using INSERTs) one DB’s tables to another DB. I know I can achieve that by executing commands in proper order (to not break relationships). But it would be easier if I could turn off checking constraints … Read more
This question already has answers here: Dynamic SELECT TOP @var In SQL Server (6 answers) Closed 6 years ago. declare @top int set @top = 5 select top @top * from tablename Is it possible? Or any idea for such a logic (i don’t want to use dynamic query)? 3 Answers 3
I am trying to compare two tables, SQL Server, to verify some data. I want to return all the rows from both tables where data is either in one or the other. In essence, I want to show all the discrepancies. I need to check three pieces of data in doing so, FirstName, LastName and … Read more
I’m working on a database for a small web app at my school using SQL Server 2005. I see a couple of schools of thought on the issue of varchar vs nvarchar: Use varchar unless you deal with a lot of internationalized data, then use nvarchar. Just use nvarchar for everything. I’m beginning to see … Read more
I would like to write a query on a sql 2008 that will report all the users that have access to a specific database, or objects within the database such as tables, views, and stored procedures, either directly or due to roles, etc. This report would be used for security auditing purposes. Not sure if … Read more
I want to return top 10 records from each section in one query. Can anyone help with how to do it? Section is one of the columns in the table. Database is SQL Server 2005. I want to return the top 10 by date entered. Sections are business, local, and feature. For one particular date … Read more
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
The last few days we see this error message in our website too much: “Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.” We have not changed anything in our code in a … Read more
