http://www.sqlmag.com/authors/author/author/5777595/rsscomment/5777595en-USFri, 25 May 2012 08:51:09 GMTFri, 25 May 2012 08:51:09 GMThttp://www.sqlmag.com/article/tsql3/using-fake-temporary-tables#commentsAnchorTue, 01 Mar 2005 05:59:26 GMT
for sql server 2000 use Table Data Type. Doesnt work in triggers though.]]>Anonymous User Tue, 01 Mar 2005 05:59:26 GMThttp://www.sqlmag.com/article/tsql3/using-fake-temporary-tables#commentsAnchorhttp://www.sqlmag.com/article/tsql3/using-fake-temporary-tables#commentsAnchorWed, 26 Jan 2005 03:14:08 GMT
"...and you can’t create a temporary table inside the trigger..." FALSE]]>Anonymous User Wed, 26 Jan 2005 03:14:08 GMThttp://www.sqlmag.com/article/tsql3/using-fake-temporary-tables#commentsAnchorhttp://www.sqlmag.com/article/tsql3/using-fake-temporary-tables#commentsAnchorSun, 23 Jan 2005 18:49:55 GMT
If I use this table as a storage for temporary data I have to drop it after last user logoff. But how? MSSQL doesn’t have BEFORE LOGON trigger :((]]>Anonymous User Sun, 23 Jan 2005 18:49:55 GMThttp://www.sqlmag.com/article/tsql3/using-fake-temporary-tables#commentsAnchorhttp://www.sqlmag.com/article/tsql3/using-fake-temporary-tables#commentsAnchorMon, 28 Jan 2002 09:16:38 GMT
This method is a way to imitate the Standard SQL-92 model of temprorary tables. In Standard SQL, a temporary table has to be part of the schema because only Admin can create schema objects and users cannot. The temporary tables are LOCAL or GLOBAL, and clear out their contents either when a COMMIT is issued or the session is over. It would be nice to have this functionality built into the SQL Server engine, instead of haivng to fake it.]]>Joe Celko Mon, 28 Jan 2002 09:16:38 GMThttp://www.sqlmag.com/article/tsql3/using-fake-temporary-tables#commentsAnchorhttp://www.sqlmag.com/article/user-defined-function-udf/fake-temporary-tables-and-sql-server-2000#commentsAnchorMon, 20 Aug 2001 08:24:16 GMT
I got some serious performance drawbacks when using UDF’s. The number of IO’s increased drastically when the result of a UDF of the table data type exceeded 10 items. I use this result to join with other tables. Is this normal?]]>Geert Vanhove Mon, 20 Aug 2001 08:24:16 GMThttp://www.sqlmag.com/article/user-defined-function-udf/fake-temporary-tables-and-sql-server-2000#commentsAnchor