how to existing columns in temporary table - Stored Procedures, Triggers, & Functions

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » Transact-SQL Programming » Stored Procedures, Triggers, & Functions » how to existing columns in temporary table

how to existing columns in temporary table

Options

Previous Topic · Next Topic

musman

Posted: Friday, June 13, 2008 8:14:02 AM

Rank: Newbie

Joined: 6/13/2008
Posts: 1
Points: 3
Location: USA

I am trying
IF OBJECT_ID(''tempdb..#tempTable.Column'') IS NOT NULL

But its returning me a null every time. Is there any other way to check if column exists in temporary table.

Scott Whigham

Posted: Friday, June 13, 2008 12:57:36 PM

Rank: Super Mod

Joined: 3/20/2006
Posts: 329
Points: 700
Location: Dallas, TX

Not that I know of...

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.