Programatorul de la A la ZI -> SQL - Tabel cu judetele Romaniei

Programatorul de la A la ZI V1.2 Beta - In curand se va face lansare.

“ Universitatea dezvoltă toate aptitudinile, inclusiv şi prostia.A. P. Cehov ”

Tabel cu judetele Romaniei - Cod Sursa

May8

Descriere

Script pentru creare taebel Judet si a insera judete in tabel.

Cod

SET NUMERIC_ROUNDABORT OFF
GO
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
IF EXISTS (SELECT * FROM tempdb..sysobjects WHERE id=OBJECT_ID(''tempdb..#tmpErrors'')) DROP TABLE #tmpErrors
GO
CREATE TABLE #tmpErrors (Error int)
GO
SET XACT_ABORT ON
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO
BEGIN TRANSACTION
GO
PRINT N''Creating [dbo].[Judet]''
GO
CREATE TABLE [dbo].[Judet]
(
[JudetID] [int] NOT NULL IDENTITY(1, 1),
[JudetCode] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[JudetNume] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IsDeleted] [bit] NOT NULL CONSTRAINT [DF__Judet__IsDeleted__078C1F06] DEFAULT (1),
[CreatedOn] [smalldatetime] NULL,
[ModifiedOn] [smalldatetime] NULL,
[ModifiedByUserID] [int] NULL,
[Implicit] [int] NULL
)

GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
PRINT N''Creating primary key [PK_Judet_1] on [dbo].[Judet]''
GO
ALTER TABLE [dbo].[Judet] ADD CONSTRAINT [PK_Judet_1] PRIMARY KEY CLUSTERED  ([JudetID])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
IF EXISTS (SELECT * FROM #tmpErrors) ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT>0 BEGIN
PRINT ''The database update succeeded''
COMMIT TRANSACTION
END
ELSE PRINT ''The database update failed''
GO
DROP TABLE #tmpErrors
GO



SET NUMERIC_ROUNDABORT OFF
GO
SET XACT_ABORT, ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS, NOCOUNT ON
GO
-- Pointer used for text / image updates. This might not be needed, but is declared here just in case
DECLARE @pv binary(16)

BEGIN TRANSACTION

-- Add 42 rows to [dbo].[Judet]
SET IDENTITY_INSERT [dbo].[Judet] ON
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (1, ''AB'', ''ALBA'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (2, ''AR'', ''ARAD'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (3, ''AG'', ''ARGES'', 0, NULL, NULL, NULL, 1)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (4, ''BC'', ''BACAU'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (5, ''BH'', ''BIHOR'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (6, ''BN'', ''BISTRITA-NASAUD'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (7, ''BT'', ''BOTOSANI'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (8, ''BV'', ''BRASOV'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (9, ''BR'', ''BRAILA'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (10, ''BU'', ''BUZAU'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (11, ''CS'', ''CARAS-SEVERIN'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (12, ''CL'', ''CALARASI'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (13, ''CL'', ''CLUJ'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (14, ''CT'', ''CONSTANTA'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (15, ''CV'', ''COVASNA'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (16, ''DB'', ''DIMBOVITA'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (17, ''DJ'', ''DOLJ'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (18, ''GL'', ''GALATI'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (19, ''GR'', ''GIURGIU'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (20, ''GJ'', ''GORJ'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (21, ''HG'', ''HARGHITA'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (22, ''HD'', ''HUNEDOARA'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (23, ''IL'', ''IALOMITA'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (24, ''IS'', ''IASI'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (25, ''IF'', ''ILFOV'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (26, ''MM'', ''MARAMURES'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (27, ''MH'', ''MEHEDINTI'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (28, ''MS'', ''MURES'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (29, ''NT'', ''NEAMT'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (30, ''OT'', ''OLT'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (31, ''PH'', ''PRAHOVA'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (32, ''SM'', ''SATU MARE'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (33, ''SJ'', ''SALAJ'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (34, ''SB'', ''SIBIU'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (35, ''SV'', ''SUCEAVA'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (36, ''TR'', ''TELEORMAN'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (37, ''TM'', ''TIMIS'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (38, ''TL'', ''TULCEA'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (39, ''VS'', ''VASLUI'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (40, ''VL'', ''VILCEA'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (41, ''VR'', ''VRANCEA'', 0, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[Judet] ([JudetID], [JudetCode], [JudetNume], [IsDeleted], [CreatedOn], [ModifiedOn], [ModifiedByUserID], [Implicit]) VALUES (42, ''B'', ''BUCURESTI'', 0, NULL, NULL, NULL, NULL)
SET IDENTITY_INSERT [dbo].[Judet] OFF

COMMIT TRANSACTION

V1.2 Beta - In curand se va face lansare.

Copyright 2007 � . Toate drepturile rezervate .