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,086 reads
Stephen Lasham
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)
11,256 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
13,488 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,546 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,842 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
14,961 reads
Blogs
Join SQLSat Memphis Virtually This Saturday
By Will Assaf
Looking forward to presenting at SQLSaturday Memphis virtually this weekend! Both my wife and I...
Failing SQL Agent Jobs – Part 4
By gbargsley
Here we are, another Tuesday!! It is time for our Fourth and final installment...
I Want PASS to Survive
By Steve Jones
I want PASS to survive. I can say that unequivocally, because this organization has...
Forums
issue with adding another column in a table
Hi, i have a table named as Book_master_tbl having only 10 records and as...
When one of your DBA colleagues leaves the company, what is your checklist?
Comments posted to this topic are about the item When one of your DBA...
Using Intel Optane/DAX/PMEM with FCI
I'm working to plan a new upgrade to our existing data warehouse infrastructure. We're...
Ask SSC