Piping a Query to a Text File
The case where one has to send the results of a query to a text file comes up quite often. This quick tip will show you how to output the results of a query to a text file.
2001-05-21
11,945 reads
Advanced Querying
Case Statement Tricks
The CASE statement is a very flexible tool. Here are just a few of the tricks you can work with it.
2001-05-15
14,839 reads
Removing Duplicate Rows
Ever have duplicate rows of data returned in a query? This article by Neil Boyle examines different techniques for removing duplicate rows.
2001-05-14
11,813 reads
Generate Test Data Quickly With Cross Joins
Need to rough up some bulk test data in a hurry? A carefully thought-out Cross Join could be the answer.
2001-05-10
6,496 reads
Tame Those Strings! Part 3 - Using REPLACE
The third part of Steve Jones's series on programming and manipulating strings in T-SQL dealing with REPLACE.
2026-02-04 (first published: 2001-04-18)
17,209 reads
Tame Those Strings! Part 4 - Numeric Conversions
The fourth part of Steve Jones's series on programming and manipulating strings in T-SQL dealing with numeric conversions.
2026-02-03 (first published: 2001-04-18)
9,666 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers