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,027 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,094 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,312 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,545 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,837 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
13,111 reads
Blogs
Simple-Talk Article…Understanding Azure Storage Options
Simple- Talk is technical journal and community hub from Redgate. This week I have the pleasure of...
T-SQL Tuesday #120 – Recap
The wrap up post for T-SQL Tuesday #120. 9 bloggers contributed this month. The post...
Setting Certificate Backup Permissions for an Instance–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
Union with temp table
insert into dbo.details ( DetailId ,DetailName ) select distinct st.stdid ,st.name from dbo.student st...
need help with a query to avoid while loop
i am struggling with a query to avoid while loop, please guide me if...
Ask SSC