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 Cross Join SQL. Show all posts

Sunday, August 3, 2014

Cross Join SQL

CREATETABLE [dbo].[EmDetails]

(

[EmpId] [int] IDENTITY(1,1)NOTNULL,

[Name] [varchar](50)NULL,

[Address] [varchar](200)NULL,

[City] [varchar](50)NULL

)

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

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

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

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

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

CREATETABLE [dbo].[Tb_Dept]

(

[DEPT_ID] [bigint] IDENTITY(1,1)NOTNULL,

[DEPT_NAME] [varchar](50)NULL

)

INSERTINTO Tb_Dept(DEPT_NAME)VALUES ('HR')

INSERTINTO Tb_Dept(DEPT_NAME)VALUES ('IT')

INSERTINTO Tb_Dept(DEPT_NAME)VALUES ('SALES')

SELECT*FROM EmDetails CROSSJOIN Tb_Dept

SELECT*FROM EmDetails , Tb_Dept