Aug 28, 2008 · What is the simplest SQL query to find the second largest integer value in a specific column? There are maybe duplicate values in the column.

The @CustID means it's a parameter that you will supply a value for later in your code. This is the best way of protecting against SQL injection. Create your query using parameters, rather than …

How do I write an SQL query to check if TableA and TableB (which have identical primary keys) contain exactly the same values in every column? It means that these two tables have exactly …

Keep in mind that when renaming a table, you almost certainly want to also rename any references to that table that may exist in stored procedures, views, functions, etc. A quick …

Feb 26, 2011 · I have a start_date and end_date. I want to get the list of dates in between these two dates. Can anyone help me pointing the mistake in my query. select Date,TotalAllowance …

May 6, 2009 · I am trying to see from an SQL console what is inside an Oracle BLOB. I know it contains a somewhat large body of text and I want to just see the text, but the following query …

I am wondering how to write this query. I know this actual syntax is bogus, but it will help you understand what I want. I need it in this format, because it is part of a much bigger query. …

For what I'm trying to do, the SQL query SELECT lastname, firstname, phonenumber WHERE phonenumber IS NOT NULL ORDER BY lastname would do the trick. It seems too simple for …

Feb 23, 2013 · How to recover the unsaved scripts if the SSMS crashes / unsaved tab gets accidentally closed?

Sep 18, 2008 · 112 I am working on a SQL query that reads from a SQLServer database to produce an extract file. One of the requirements to remove the leading zeroes from a particular …