SoftTree Technologies Technical Support Forums Register • Search • FAQ • Memberlist • Usergroups • Log in Table Variable with Unique or Primary Key are seen as column      SoftTree Technologies Forum Index » SQL Assistant View previous topic View next topic Table Variable with Unique or Primary Key are seen as column Author Message judahr Joined: 09 Mar 2007 Posts: 319 Country: United States Table Variable with Unique or Primary Key are seen as column 3.5.11 - SQL Code: Declare @tbl table (Column1 int, Column2 int, Unique(Column1, Column2)) Select From @tbl t INNER JOIN dbo.Table1 t1 ON t. At this point you will see 3 column choices: Column1, Column2, and Unique. Should only show Column1 and Column2. Primary Key shows similar behavior. Mon May 12, 2008 6:34 am Display posts from previous:  All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year  Oldest FirstNewest First     SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours Page 1 of 1   Jump to:  Select a forum ----------------SQL AssistantDB Audit, DB Mail, DB Tools24x7 Scheduler, Event Server, Automation SuiteTips & Snippets Repository You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum     Powered by phpBB © 2001, 2005 phpBB Group Design by Freestyle XL / Flowers Online.