1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
CREATE PROCEDURE [dbo].[NEWTABLE]
AS
CREATE TABLE TEST445
(
Id int PRIMARY KEY IDENTITY(1,1),
ReferenceEmape nvarchar(255) NULL,
Designation nvarchar(255) NULL,
Type nvarchar(255) NULL,
MarqueComp nvarchar(255) NULL,
ModeleComp nvarchar(255) NULL,
PrixHT money,
Favoris Bit
)
SELECT ReferenceEmape, Designation, Type, MarqueComp, ModeleComp, PrixHT, Favoris FROM Articles
INSERT INTO TEST445 (ReferenceEmape, Designation, Type, MarqueComp, ModeleComp, PrixHT, Favoris)
VALUES ('@RefEMAPE', '@Designation', '@Type','@Marque','@Modele','@PrixHT', 0)
GO |
Partager