tblmonthnames.sql

来自「< SQL Server2005程序设计>」· SQL 代码 · 共 26 行

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblMonthNames]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tblMonthNames]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tblMonthNames](
	[MonthNumber] [int] NULL,
	[EnglishMonthName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[SpanishMonthName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
INSERT INTO [Northwind].[dbo].[tblMonthNames] VALUES (1, 'January', 'enero')
INSERT INTO [Northwind].[dbo].[tblMonthNames] VALUES (2, 'February', 'febrero')
INSERT INTO [Northwind].[dbo].[tblMonthNames] VALUES (3, 'March', 'marzo')
INSERT INTO [Northwind].[dbo].[tblMonthNames] VALUES (4, 'April', 'abril')
INSERT INTO [Northwind].[dbo].[tblMonthNames] VALUES (5, 'May', 'mayo')
INSERT INTO [Northwind].[dbo].[tblMonthNames] VALUES (6, 'June', 'junio')
INSERT INTO [Northwind].[dbo].[tblMonthNames] VALUES (7, 'July', 'julio')
INSERT INTO [Northwind].[dbo].[tblMonthNames] VALUES (8, 'August', 'agosto')
INSERT INTO [Northwind].[dbo].[tblMonthNames] VALUES (9, 'September', 'septiembre')
INSERT INTO [Northwind].[dbo].[tblMonthNames] VALUES (10, 'October', 'octubre')
INSERT INTO [Northwind].[dbo].[tblMonthNames] VALUES (11, 'November', 'noviembre')
INSERT INTO [Northwind].[dbo].[tblMonthNames] VALUES (12, 'December', 'diciembre')