SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Table Variable with Unique or Primary Key are seen as column

 
Reply to topic    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: 314
Country: United States

Post Table Variable with Unique or Primary Key are seen as column Reply with quote
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 View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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.