tengo esto:
Código SQL:
Ver original
SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[almacenes]( [clave] [VARCHAR](5) NOT NULL, [nombre] [VARCHAR](60) NOT NULL, [ultimoFolio] [INT] NOT NULL CONSTRAINT [DF__almacenes__ultim__00551192] DEFAULT ((0)), CONSTRAINT [almacenes_PRIMARY] PRIMARY KEY NONCLUSTERED ( [clave] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO
Y quiero ingresar estos datos
Código SQL:
Ver original
INSERT INTO `almacenes` VALUES ('001','ALMACEN GENERAL',0); INSERT INTO `almacenes` VALUES ('002','COCINA',0); INSERT INTO `almacenes` VALUES ('003','ALMACEN 1',0); INSERT INTO `almacenes` VALUES ('004','ALMACEN 2',0); INSERT INTO `almacenes` VALUES ('005','101',0); INSERT INTO `almacenes` VALUES ('006','102',0); INSERT INTO `almacenes` VALUES ('007','103',0); INSERT INTO `almacenes` VALUES ('008','104',0);
Mi pregunta es, despues del primer codigo que puse va el segundo? osea que quedaria de esta forma:
Código SQL:
Ver original
USE [DB prueba] SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[almacenes]( [clave] [VARCHAR](5) NOT NULL, [nombre] [VARCHAR](60) NOT NULL, [ultimoFolio] [INT] NOT NULL CONSTRAINT [DF__almacenes__ultim__00551192] DEFAULT ((0)), CONSTRAINT [almacenes_PRIMARY] PRIMARY KEY NONCLUSTERED ( [clave] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO ---- INSERT INTO `almacenes` VALUES ('001','ALMACEN GENERAL',0); INSERT INTO `almacenes` VALUES ('002','COCINA',0); INSERT INTO `almacenes` VALUES ('003','ALMACEN 1',0); INSERT INTO `almacenes` VALUES ('004','ALMACEN 2',0); INSERT INTO `almacenes` VALUES ('005','101',0); INSERT INTO `almacenes` VALUES ('006','102',0); INSERT INTO `almacenes` VALUES ('007','103',0); INSERT INTO `almacenes` VALUES ('008','104',0);
Que debo quitar que debo poner? o Esta bien asi?
Gracias de antemano