table creation

Kmandapalli
Posted by Kmandapalli under Sql Server category on | Points: 40 | Views : 305
USE tempdb;
GO
IF OBJECT_ID (N'#Bicycles',N'U') IS NOT NULL
DROP TABLE #Bicycles;
GO
SELECT *
INTO #Bicycles
FROM AdventureWorks2012.Production.Product
WHERE ProductNumber LIKE 'BK%';
GO

Comments or Responses

Login to post response