Asp.Net Ado.Net, C#.Net,Javascript Jquery Entity Framework,Ajax,MVC..! Happy coding..! :)

Every Question..What does it mean? Why is this? How it works?
Microsoft .Net (pronounced dot (.) net) may be a package element that runs on the Windows software package. .Net provides tools and libraries that change developers to form Windows package a lot of quicker and easier. Microsoft describes it as:".Net is that the Microsoft internet Service strategy to attach data, people, system and devices through software".I'm Choulla Naresh..!

Showing posts with label Example to use CROSS JOIN or CARTESIAN JOIN in SQL SERVER. Show all posts

Friday, August 1, 2014

CROSS JOIN or CARTESIAN JOIN in SQL SERVER

CREATE TABLE [dbo].[EmDetails]

(

[EmpId] [int] IDENTITY(1,1) NOT NULL,

[Name] [varchar](50) NULL,

[Address] [varchar](200) NULL,

[City] [varchar](50) NULL

)

INSERT INTO EmDetails (Name,Address,City) VALUES ('Lalit','#1234','Chandigarh')

INSERT INTO EmDetails (Name,Address,City) VALUES ('Raman','#4567','Panchkula')

INSERT INTO EmDetails (Name,Address,City) VALUES ('Arjun','#111','Noida')

INSERT INTO EmDetails (Name,Address,City) VALUES ('Rohan','#321','Delhi')

INSERT INTO EmDetails (Name,Address,City) VALUES ('Raghav','#675','Noida')

CREATE TABLE [dbo].[Tb_Dept]

(

[DEPT_ID] [bigint] IDENTITY(1,1) NOT NULL,

[DEPT_NAME] [varchar](50)NULL

)

INSERT INTO Tb_Dept (DEPT_NAME) VALUES ('HR')

INSERT INTO Tb_Dept (DEPT_NAME) VALUES ('IT')

INSERT INTO Tb_Dept (DEPT_NAME) VALUES ('SALES')

SELECT * FROM EmDetails CROSS JOIN Tb_Dept

SELECT * FROM EmDetails , Tb_Dept