A Function Gotcha with the Use of an Asterisk
This article describes and demonstrates the problem of using asterisk to select all fields from a table within a table function. (from Apr 2008)
2009-09-11 (first published: 2008-04-30)
18,767 reads
Stephen Lasham
- Interests: Photography
Converting Hexadecimal String Values to Alpha (ASCII) Strings
In an interesting exercise in data conversion, Stephen Lasham brings us a nice article on basic manipulations.
2008-04-25 (first published: 2007-05-17)
13,093 reads
Finding Gaps in a Sequential Number Sequence
Do you use identity values? Do missing values ever cause problems? Maybe you need to look for missing invoices? Stephen Lasham brings us a technique for finding those missing values in a sequence.
2006-04-03
14,773 reads
Reporting a menu structure using a recursive UDF
Selecting a menu structure from a series of tables is pretty easy. If you bound the number of levels in the menu. However if you have potentially variable numbers of levels. Stephen Lasham brings us a new piece on using recursion to select the data.
2005-10-11
8,842 reads
Extracting a String Within Delimeters - Part 2
T-SQL can be a complex language to work within and code solutions with. Author Stephen Lasham brings us a twist on his last solution of extracting a string from within another string. Read about his method of working with strings in T-SQL.
2004-09-13
7,873 reads
Extracting a String From Between Two Delimiting Characters
String manipulation in SQL Server or T-SQL can be a challenage. There are multiple ways to accomplish every task and often learning a new one may spark some creativity in yourself or teach you a better way to accomplish an old task. New Author Stephen Lasham brings us his technique for extracting a string that is delimited from within a larger string. Something I'm sure we'll all have use for in the future.
2004-06-14
23,494 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
does anyone used https://github.com/ktaranov/sqlserver-kit
Could you please let me know if anyone is used https://github.com/ktaranov/sqlserver-kit github for deployment...
How Can Database Performance Improve the Overall Website Experience?
I’ve been looking into ways to improve the connection between a website and its...
When And How to Automate?
Comments posted to this topic are about the item When And How to Automate?
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers