Tag Archives: #table

Incorrect syntax near the keyword ‘table’ in TSQL

Posted on 04/07/2010 by Eric Fickes

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 , , , , , | 4 Comments

Select random value from a range of values

Posted on 01/02/2010 by Eric Fickes

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 , , , , , , , , | 1 Comment