My Work
My Blogs
Hotlinks
Tag Archives: mssql2000
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
