March 2009 - How Tos - SQL Server Nation

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

Updating values in one table with values from another table

Sometimes, it is necessary to update a field in one table, with information from another table. In this article, I will go over with you a few different methods for doing this. At the bottom there is a link to download the entire SQL script used in this...

Published 19 Mar 2009 5:24 PM by BrandonGalderisi

Filed under: Intermediate SQL, UPDATE, JOIN

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

User Defined Functions

User defined functions have many uses in SQL Server. Functions are useful to help clean up complex string manipulation logic in other areas of code and many other things. But convenience is not free. There is overhead in using functions and we will go...

Published 7 Mar 2009 12:50 PM by BrandonGalderisi

Filed under: Beginner SQL, table valued function, scalar valued function, User Defined Functions

Table Valued Functions

A table valued function is a function that returns a table instead of a single value. In this post, we will go over the Table Valued Functions in more detail than we did in the general topic covering User Defined Functions . There are many uses for table...

Published 7 Mar 2009 12:33 PM by BrandonGalderisi

Filed under: Beginner SQL, table valued function, User Defined Functions

A View of Numbers

The below view will generate a list of numbers ranging from 1 - 4,294,967,296. This view can be used in place of a physical table of numbers for some small operations but since it utilizes several large cross joins it is not very efficient once it starts...

Published 7 Mar 2009 12:35 AM by BrandonGalderisi

Filed under: Beginner SQL, view, function, numbers table, sql 2005, User Defined Functions

Converting a delimited string into a table

In this article, I will show you how you can convert a delimited string of data into a table of data. In order to do this we will use a table valued function. There are many ways to achieve this but this how I like to do it. In order to use the function...

Published 7 Mar 2009 12:25 AM by BrandonGalderisi

Filed under: Intermediate SQL, function, numbers table, table valued function, numbers, User Defined Functions

Stored Procedures

Stored procedures are part of the core functionality of a DBMS. SQL Server is no exception to that. Stored procedures have many uses. They can be used to handle basic CRUD operations as well as complex logic. There are several things that you have to...

Published 6 Mar 2009 6:54 PM by BrandonGalderisi

Filed under: variable, stored procedures, return, parameter, beginner, Beginner SQL

Changing the display format of DATETIME values

Often times, people want to change the format of a datetime value returned from SQL Server. There are some things that you need to consider before doing this. The first thing that you need to be aware of is that SQL Server stores DATETIME values in an...

Published 5 Mar 2009 10:24 PM by BrandonGalderisi

Filed under: datetime, time, date, cast, convert, Intermediate SQL

March 2009 - How Tos

Syndication

Recent Posts

Tags

Archives