Build #47, 12/14/2007

NOTES

TEMP Table Support - 2 types of temp tables

• CREATE #temptable - lives through lifetime of connection
• DECLARE @temptable TABLE - lives in scope of the query, syntax is used for stored procs and UDFs.

Change in stored proc variables

Variable scope within BEGIN/END block.  Variables declared in a BEGIN/END block will be destructed after the END.

ISSUES AND FIXES

#334: Data Reader memoryleak using IDataReader - Fixed
#332: wrong result ith "[xy] is null" in where clause - Fixed
#262: SQL Parser not accepting negative starting identities - Fixed
#339: DataBuilder GUI subfolders display problem - Fixed
#270: SQL Statement leads to a null object - Fixed
#336: Designer exception - Fixed
#322: Trial compilation issue - Fixed
#323: Screen shot Databuilder screesn for help - Completed

OTHER NON TICKETED ITEMS

Some enhancements to query optimizer.