My Work
My Blogs
Hotlinks
Tag Archives: tsql
Incorrect syntax near the keyword ‘table’ in TSQL
Ran into something little that I know I’m going to forget if I don’t write down. It appears that when using a TABLE variable in tsql ( SQL Server 2005 ), you must DECLARE that variable on it’s own line, … Continue reading
Posted in database, microsoft, SQL, tsql
Tagged #table, DECLARE, SQLSERVER, SQLSERVER 2005, table variable, tsql
4 Comments
What happens in EXEC, stays in EXEC. Lifespan of a MSSQL table variable
One of my all time favorite features of MSSQL 2005+ is being able to create table variables on the fly from SELECT statements. This isn’t a lesson in what table variables are, but here is an easy sample in case … Continue reading
Posted in database, development, tsql
Tagged exec, mssql, mssql2000, mssql2005, scope, SELECT INTO, table variable, temp table, tsql
1 Comment
Select random value from a range of values
Earlier I blogged about creating random numbers using tsql functions. Here are two techniques for selecting a random value from a pre-defined range of values in a tsql script. The first technique uses a table variable ( MSSQL 2000 + … Continue reading
Posted in database, development, microsoft, tips and tricks, tsql
Tagged #table, cte, howto, mssql, mssql2000, mssql2005, random, table variable, tsql
1 Comment
Generate random integers using tsql UDFs
Ever need to generate random numbers from the integer family? I had this need on a project so I whipped up these four tsql User Defined Functions to help with this task. There are four functions in all, one for … Continue reading
Posted in database, development, microsoft, SQL, tsql
Tagged integer, random, random integer generation, random number, SQL, sql2005, tsql, udf, user defined functions, view
4 Comments
