CREATE TABLE #Product ( ProductID int IDENTITY(1,1) NOT N...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans

Q&A for music historians, critics, and fans

CREATE TABLE #Product (
 ProductID int IDENTITY(1,1) NOT NULL,
 ProductName varchar(50) NOT NULL,
 Price float NOT NULL,
 Stock int NOT NULL
)
GO
INSERT INTO #Product (ProductName,Price,Stock)VALUES('P001',12.12,100)
INSERT INTO #Product (ProductName,Price,Stock)VALUES('P002',102.12,200)
INSERT INTO #Product (ProductName,Price,Stock)VALUES('P003',104.12,500)
INSERT INTO #Product (ProductName,Price,Stock)VALUES('P004',108.12,100)
INSERT INTO #Product (ProductName,Price,Stock)VALUES('P005',72.12,10)
INSERT INTO #Product (ProductName,Price,Stock)VALUES('P006',72.12,0)
GO
SELECT * FROM #Product

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results