Query by example: the charlist wild card.
When using query by example there are the known wildcard characters “*” or “%” and “?” or “_”; but, recently I stumbled upon a new wildcard known as the charlist. Wildcard Description * or % […]
Category: MS SQL Server
Microsoft SQL Server Databases
How to find rows where a column contains a number
I needed to pull out all rows where a user id was numeric, SQL Server (as of 2005) has a function IsNumeric: SELECT USERID,USERNAME FROM Users Where IsNumeric(UserID) = 1 ISNUMERIC returns 1 when the […]
…it is not contained in either an aggregate function or the GROUP BY clause
I cannot tell you how annoying I find this error, and before you post a comment, I know it’s not the fault of SQL Server. I’ve asked it for something that is not logically solvable. […]
Export to Excel from SQL Server
I often find myself needing to take data from a SQL query and give it to another person. SQL Server Management Studio (SSMS) does have the ability to right click in the results grid and […]
SQLCMD: MS SQL Server’s Command Line Interface
I know what your thinking. Why in the world would I want to manipulate the complex workings of MS SQL Server using the archaic command line? Before today I would have been thinking that right […]
SQL: Get count using a JOIN (Grouping before the Join)
Count of records using a sub-query bypassing the limits of the Group By.