Joins in SQL Server

Sign in to leave a comment.

• 

  Manav Pandya10y agoPosted Oct 2, 2016, 5:58 AM

  Great
• 

  deva nathan13y agoPosted Nov 22, 2012, 4:15 AM

  super qurey
• NP

  naren prasath15y agoPosted May 10, 2011, 7:33 AM

  hi raj!! this is naren from coimbatore working in s/w concern.i got big problem in joints.this lets to terminate me from office..but ur tutorial helps me lot to understand the concepts.thank very much...
• SG

  Shrikant Gupta15y agoPosted Mar 3, 2011, 6:26 AM

  very easly define thanks..
• JT

  jyothsna tadikonda15y agoPosted Jan 21, 2011, 12:39 AM

  Hi it's good but we need more examples individually.........
• AG

  avinash gupta15y agoPosted Jan 19, 2011, 8:07 AM

  ur explanation is good....
• NB

  narkees banu15y agoPosted Dec 25, 2010, 5:45 AM

  how can i add new field at the middle of the table via query
• DA

  Donald Atsaam16y agoPosted Jul 26, 2010, 8:14 AM

  Many thanks to the Author. This article gave me all I was looking for. Once again thanks. Donald Atsa'am
• DT

  DZone Tech16y agoPosted Jun 7, 2010, 12:16 AM

  Is that possible to add primary key to a column after the table is created. In a procedure is that possible i can send only one value in that i have four values as parameters say for create procedure samp @name,@no,@subject as here is that i want the code can any one help me with this query
  • 

    Raj Kumar16y agoPosted Jun 7, 2010, 6:13 AM

    yes u can create primary key after table created. where is your query can u post ur query.
  • RS

    rohit sethi16y agoPosted Jun 17, 2010, 5:08 AM

    how can a user can do atler the table when he has done transaction or using in the procedures
• AV

  abhi vs16y agoeditedPosted Jan 14, 2010, 8:29 PMEdited Jan 14, 2010, 8:30 PM

  hi i have 2 tables on which i have done inner join on a copmanyseqno. ok in the result set i am getting values like this for companyseqno= 0 i have the values for adresscode and shippinginfo. and for companyseqno<>0 i dont have any values for the fields shipping info and addresscode. now i want the same values for shipping and addresscode for companyseqno<>0 same as companyseqno=0 for that i need to do some joins i think. i am not able to figure out how to append the values ..please help me
• SP

  Saisrinivas polamuri17y agoPosted Sep 23, 2009, 10:13 AM

  Hi Raj, This is very usefull and clear article, people who don't have technical background also easily understand. Thank you very much, keep posting.
• 

  Vijaya Kadiyala17y agoPosted Sep 7, 2009, 11:31 AM

  Which version of SQL Server Supports Natural Join?????
• GP

  G P17y agoPosted Jul 27, 2009, 11:40 AM

  This is exactly what I was looking for. You give a simple explanation which is good for beginners. Books Online has great information, but it is too detailed for a beginner.
• PS

  pandu sweety17y agoPosted Jul 23, 2009, 10:40 PM

  Hi, I have the problem with ,One database tables data transfering to other database tables.where the tables and procedures all structures are same. I have DB1 and DB2 Databases. In DB1->Table 1 table 2 tabl3 means upto 15 tables have . In DB2 - the above same Tables and same datatypes and structures. I need to transfer the DB1 Tables data to DB2 Tables. " I used the following command for shift table be table but ..it is failing. -SELECT * INTO DB2.dbo.RFmaster FROM ILS.db1.RFmaster INSERT INTO [DB2].[dbo].[Table1] (ItemID,Barcode, TagUID , ItemTitle , MediaTypeCode , BranchCode , BibliographicCode , BibliographicRef , SortingCode , LocationCode , Tagstatus, Volume ) SELECT * FROM DB1.dbo.Table1 Like that I have to do...... :My problem is to resolve this.....using by StoreProcedure concept only. Advance thanks for the best reply.
• EE

  evenderz elson17y agoPosted Jul 12, 2009, 1:56 PM

  hey man thanks ya ... this stuff is a real good one..
• 

  Kalyan Bandarupalli17y agoPosted May 12, 2009, 5:08 PM

  More about sql server joins can be read here Joins in SQL server
• AG

  Arun Gopal17y agoPosted Mar 31, 2009, 9:58 AM

  Hi Rajkumar, This is Arunagiri, It is one of the best site for Joins. and it have very good examples. It is very useful one. Thanks G Arunagiri
  • 

    Raj Kumar17y agoPosted Apr 1, 2009, 7:48 AM

    Thanks man
• 

  Rahul Kumar Saxena18y agoPosted Nov 6, 2008, 4:07 AM

  Good Job buddy Keep it up knowledgable post ....
  • 

    Raj Kumar18y agoPosted Nov 6, 2008, 5:11 AM

    Thanks
  • DV

    dheeraj varshney15y agoPosted Jan 20, 2011, 3:29 AM

    this concepts is right>>>>>>>>>>>>>>>>>>>>