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,706 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,012 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,736 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,824 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,862 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,347 reads
Blogs
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
When growing companies outgrow Excel
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Forums
BCA KCP M. Duryat Telpon/WA:083179431313
WhatsApp:083179431313 Jl. Kombes Pol. Moh. Duryat No.5-6 Blok A, Tegalsari, Kec. Tegalsari, Surabaya, Jawa...
BCA KCU HR MUHAMMAD Telpon/WA:083179431313
WhatsApp:083179431313 Jl. Mayjen HR. Muhammad No.17, Putat Gede, Kec. Sukomanunggal, Surabaya, Jawa Timur 60189
BCA KCU BUKIT DARMO BOULEVARD Telpon/WA:083179431313
WhatsApp:083179431313 Jl. Mayjend. Jonosewojo No.14, Pradahkalikendal, Kec. Dukuhpakis, Surabaya, Jawa Timur 60225
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers