PASS Data Community Summit logo

PASS Data Community Summit 2023

Get all the latest announcements direct to your inbox

Articles tagged Transact SQL

18 January 2018
18 January 2018

Inline Index Definition

There are a lot of features of SQL Server that I (and I know some of you), never really get around to using, usually because you have your ways, you have done things the same way for 100 years, and it all works fine enough. You may have heard of a feature, but said I … Read more
10 April 2007
10 April 2007

Reading and Writing Files in SQL Server using T-SQL

SQL Server provides several "standard" techniques by which to read and write to files but, just occasionally, they aren't quite up to the task at hand - especially when dealing with large strings or relatively unstructured data. Phil Factor provides some T-SQL stored procedures, based on use of the FileSystem Object (FSO), that may just get you out of a tight corner...… Read more