No announcements
Found 2533949 threads
-
0 VotesFOREIGN KEYS IN DISTINCT PUBLICATIONS
I created the foreign keys manually, the problem is when a snapshot is reinicialized, the foreign key is deleted automatically, even with the option to ...Answered | 5 Replies | 923 Views | Created by carlosadrr - Monday, July 7, 2014 5:20 PM | Last reply by Hilary Cotter - Tuesday, July 8, 2014 3:45 PM
-
0 Votes
LINQ To SQL distinct
If you have a foreign key relationship set up in the tables in SQL then you will find the LINQ to SQL designer automatically creates such an association ...Answered | 4 Replies | 5680 Views | Created by Anthony Jowers - Friday, April 23, 2010 4:43 AM | Last reply by Michael Sun [MSFT] - Thursday, April 29, 2010 9:30 AM -
0 Votes
LINQ JOIN ON PARAMETERIZED DISTINCT KEY CASE INSENSITIVE
Some think that LINQ as a language is superior to SQL.Answered | 7 Replies | 4315 Views | Created by Paul Mortenson - Thursday, October 7, 2010 9:21 PM | Last reply by Paul Mortenson - Friday, November 5, 2010 3:39 PM -
0 Votes
Get List of Distinct by a Particular Property
https://docs.microsoft.com/en-us/dotnet/visual-basic/misc/bc36625 I think that the below Linq statement would work too.Answered | 5 Replies | 436 Views | Created by KenKrugh - Monday, February 17, 2020 2:13 AM | Last reply by DA924x - Monday, February 17, 2020 7:05 PM -
0 Votes
LINQ Distinct Statement
I added another constructor Public Sub New(list As IEnumerable(Of Person)) MyBase.New(list) End Sub And then ...Answered | 5 Replies | 3705 Views | Created by msdner1 - Tuesday, February 12, 2013 7:05 PM | Last reply by msdner1 - Tuesday, February 19, 2013 1:12 PM -
1 Votes
Insert with a Foreign Key Value
If you still want to keep the design, then you can refer to John's suggestion to set the foreign key column of A after the SubmitChanges().Answered | 2 Replies | 4640 Views | Created by dvimal24 - Monday, July 26, 2010 7:25 AM | Last reply by Alex Liang - Wednesday, July 28, 2010 9:56 AM -
0 Votes
Linq: count(distinct) conversion
c.User).Distinct().Count() }Answered | 3 Replies | 1392 Views | Created by ebiz-tutor - Monday, April 21, 2014 11:35 AM | Last reply by ebiz-developer - Monday, April 21, 2014 12:48 PM -
0 Votes
Foreign Keys
Items ....ItemID (PK) ....Item ....Category (FK) ....Aisle ...Answered | 3 Replies | 423 Views | Created by Exceluser367 - Tuesday, October 6, 2015 8:29 PM | Last reply by Ken Sheridan - Wednesday, October 7, 2015 10:19 PM -
0 Votes
Union foreign key
I wrote query like this as my trigger (of course for delete ) then remove foreign keys Then i could solve my problem I hope this query help ...Answered | 6 Replies | 2154 Views | Created by ALireza Hassani - Friday, December 18, 2015 6:13 PM | Last reply by Lydia Zhang - Monday, December 28, 2015 7:19 AM -
2 Votes
Need a Query that Returns Primary Keys, Foreign Keys, Foreign Key References
.'+ TC.TABLE_NAME AS PRIMARYKEYTABLE ,TC.CONSTRAINT_NAME AS PRIMARYKEY ,CU.COLUMN_NAME as [Primary Column Name] ,COALESCE(RC1.CONSTRAINT_NAME,'N/A') AS ...Answered | 4 Replies | 2354 Views | Created by cdun2 - Tuesday, December 11, 2012 11:28 PM | Last reply by cdun2 - Wednesday, December 12, 2012 8:01 PM -
0 Votes
Synching Foreign Keys
As an additional part of this question, I am using LINQ to SQL to access the local cache .sdf file.Answered | 4 Replies | 6077 Views | Created by KimballJohnson - Sunday, April 19, 2009 11:15 PM | Last reply by ErikEJ - Tuesday, April 21, 2009 6:10 AM -
0 Votes
distinct values using LINQ
new {item.Region }) .Select(item => item.First()) .OrderBy(item => item.Region); Please remember ...Answered | 2 Replies | 4336 Views | Created by rebmaamberrebmaamber - Wednesday, June 22, 2016 6:18 AM | Last reply by Kareninstructor - Wednesday, June 22, 2016 1:00 PM -
2 Votes
Is "Foreign Key" Keyword Necessary
The syntax is [CONSTRAINT <constraint name>] FOREIGN KEY (<col list>) REFERENCES <table name>[(<col ...Answered | 11 Replies | 2800 Views | Created by Mike L (SQL Newb) - Thursday, February 7, 2013 8:32 PM | Last reply by Kalman Toth - Wednesday, February 13, 2013 8:51 AM -
0 Votes
Foreign key
CREATE TABLE CreditCard( CreditCardID int IDENTITY(1,1) PRIMARY KEY, -- Surrogate key CustomerID int REFERENCES ...Answered | 6 Replies | 4458 Views | Created by ceewee2000 - Thursday, September 24, 2009 9:35 AM | Last reply by Kundan Sinha - Thursday, September 24, 2009 11:59 AM -
0 Votes
Primary Key and Foreign Key
Each of those tables needs a foreign key constraint since you want to be sure each order detail line has both a valid order and a valid product.Answered | 4 Replies | 974 Views | Created by Ronald Rex - Sunday, September 9, 2018 12:21 AM | Last reply by Ronald Rex - Sunday, September 9, 2018 7:02 PM -
0 Votes
Conditional Foreign Key?
KEY (PurposeID, PurposeType) REFERENCES dbo.Purpose(PurposeID, [Type]), CONSTRAINT FK_Hearing_Outcome FOREIGN KEY (OutcomeID, OutcomeType) REFERENCES ...Answered | 13 Replies | 15952 Views | Created by DesertDude - Wednesday, April 7, 2010 8:52 PM | Last reply by Hunchback - Tuesday, April 13, 2010 6:18 PM -
0 Votes
Foreign key to composite key
Then add foreign key (ManufactureId and ProductId) referencing the product table and a foreign key OrderNo referencing the order table.Answered | 8 Replies | 11102 Views | Created by jinzuya - Monday, November 15, 2010 9:51 PM | Last reply by afrodita_ust - Thursday, November 17, 2011 2:54 PM -
1 Votes
Does a foreign key have to be a primary key
Educated myself with something I did not know at all.But it gets weirder.Answered | 9 Replies | 1887 Views | Created by Divideby - Wednesday, July 30, 2014 10:43 AM | Last reply by Ahsan Kabir - Thursday, August 7, 2014 6:12 AM -
0 Votes
Foreign key question
Yes, there needs to be 2 commands as you listed.Answered | 2 Replies | 2105 Views | Created by aujong - Monday, April 2, 2012 9:17 PM | Last reply by Naomi N - Monday, April 2, 2012 9:26 PM -
1 Votes
How to update foreign key...
Hi Umar, The FOREIGN KEY Constraint is used to ensure the referential integrity of data in one table to match values in another table.Answered | 2 Replies | 2121 Views | Created by Umar Farooq Shafi - Thursday, August 22, 2019 4:46 PM | Last reply by Umar Farooq Shafi - Friday, August 23, 2019 7:00 AM - Items 1 to 20 of 2533949 Next ›
No announcements
