Tuesday 10 February 2015

Create temp table in sql

Create temp table in sql :



SQl Temp Table


SELECT  [EmpID]
      ,[FirstName]
      ,[LastName]
      ,[Salary]
      ,[Address]
      ,[id] 
    INTO #TempEmp   --> TableName
  FROM [sample].[dbo].[Employee]


  
  Select * From #TempEmp

No comments:

Post a Comment