Find The First Row
Ever needed to find the first occurrance of some data. This article looks at T-SQL querying for data in natural order.
2001-06-29
12,618 reads
Ever needed to find the first occurrance of some data. This article looks at T-SQL querying for data in natural order.
2001-06-29
12,618 reads
2001-06-25
7,053 reads
Answers to the SQL quiz that Steve Jones used to give to prospective employees.
2001-06-22
11,601 reads
This article examines the hiring practices of Steve Jones and provides some ideas for how to choose between candidates.
2001-06-22
13,433 reads
The fifth part of Steve Jones's series on programming and manipulating strings in T-SQL dealing with STUFF.
2001-06-21
10,855 reads
2001-06-20
3,636 reads
2001-06-18
1,958 reads
Steve Jones provides some notes from the field after installing SP1 on a personal edition of SQL Server
2001-06-18
2,858 reads
A new security alert affecting SQL Server was released on June 12, 2001
2001-06-14
3,609 reads
2001-06-13
3,499 reads
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
Comments posted to this topic are about the item One more reason to use...
I'm tracing activity on one database and would like to include the client_app_name in...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers