SQL Server Nation
For all of your SQL Server needs.
Sign in
|
Join
|
Help
Home
Blogs
Downloads
Forums
SQL Wiki
Groups
Announcements
Tip of the Week
How-Tos
Administration
Development
Brandon Galderisi
Tim Chapman
How Tos
»
All Tags
»
Advanced SQL
(
RSS
)
Browse by Tags
How Tos
Home
Syndication
RSS for Posts
Atom
RSS for Comments
Recent Posts
Splitting a string into a table of characters
Hashing large data strings with a User Defined Function
Tags
Advanced SQL
beginner
Beginner SQL
Business Intelligence
cast
convert
date
datetime
DMV
dynamic management view
filter
function
Intermediate SQL
numbers table
parameter
parameters
return
scalar valued function
sql 2005
stored procedures
system stored procedure
table valued function
User Defined Functions
variable
view
View more
Archives
October 2009 (3)
April 2009 (2)
March 2009 (9)
Beginner SQL
Intermediate SQL
sql 2005
table valued function
User Defined Functions
Splitting a string into a table of characters
Sometimes you may not be able to see the characters in your data in SQL Server Mangement Studio (or another application). This simple function will allow you to pass an input string in, and it will return the individual characters as rows from a Table...
Published
24 Mar 2009 11:55 PM
by
BrandonGalderisi
Filed under:
Intermediate SQL
,
Beginner SQL
,
table valued function
,
User Defined Functions
,
Advanced SQL
Hashing large data strings with a User Defined Function
If you have ever tryed to hash data in SQL Server using SQL Server's build in HASHBYTES , you know that that it doesn't accept greater than 8000 bytes of data. While that may work for a lot of scenarios, it doesn't help when you have large...
Published
15 Mar 2009 9:53 PM
by
BrandonGalderisi
Filed under:
sql 2005
,
User Defined Functions
,
Advanced SQL
Copyright SQL Server Nation 2009