This query shows how to write a T-SQL statement that lists all numbers between 1 and 100 ordered, without use of any DATABASE table with only ONE select statement.
2012-02-20 (first published: 2011-12-31)
2,294 reads
Create a c:\servers.txt list of servers. No spaces or it wont work. Then copy the code into a ps1 file and edit the directroyfilename to show where you want the files to end up.
2012-02-17 (first published: 2012-01-23)
1,882 reads
Find drive, freespace, usedspace and percent free for all drives and mounted volumes.
2012-02-16 (first published: 2011-12-15)
830 reads
3 functions that implement the left (<<), right (>>) and unsigned right (>>>) shift operators, commonly found in C-style languages.
2012-02-15 (first published: 2011-12-30)
8,142 reads
2012-02-13 (first published: 2011-12-30)
1,720 reads
A simple example of using T-SQL and the Boomerang framework to create a data driven subscription.
2012-02-08 (first published: 2012-01-04)
1,950 reads
2012-02-07 (first published: 2011-12-15)
1,064 reads
2012-02-06 (first published: 2011-12-23)
1,570 reads
2012-02-02 (first published: 2012-01-20)
3,920 reads
2012-02-01 (first published: 2012-01-20)
2,220 reads
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
Comments posted to this topic are about the item The Costs of Multiple Platforms
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers