.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

Select query to check existence of foreign key

Posted By: Sajid P K     Posted Date: November 25, 2010    Points:2   Category :Sql Server
Frdnz,

I have table A & B (One to Many). There is a foreign key in Table B. I have to write a quay to select data from A.

Its one Colum should be a Boolean value.. I.e. it should be True if related value (foreign key) exist in the table B. Other wise it false.

Please advice me efficient way of writing this query?




Responses
Author: Sajid P K             
Posted Date: November 25, 2010     Points: 5   
Author: Deco             
Posted Date: November 25, 2010     Points: 5   

Please explain briefly

Regards,
Deco


Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend