Script para crear y poblar tabla 'General'

USE [Demos] GO /****** Object: Table [dbo].[General] Script Date: 03/10/2015 10:17:21 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[General]( [Id] [int] IDENTITY(1,1) NOT NULL, [Posicion] [int] NOT NULL, [Equipo] [varchar](50) NOT NULL, [JG] [int] NOT NULL, [PTS] [int] NOT NULL, [Logo] [varchar](50) NOT NULL, CONSTRAINT [PK_General] PRIMARY KEY CLUSTERED ( [Id] 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 General VALUES (1, N'Club Tijuana', 9, 20, N'logocClubTijuana') INSERT INTO General VALUES (2, N'Veracruz', 9, 19, N'logocVeracruz') INSERT INTO General VALUES (3, N'América', 9, 15, N'logocAmerica') INSERT INTO General VALUES (4, N'Puebla', 9, 15, N'logocPuebla') INSERT INTO General VALUES (5, N'Cruz Azul', 9, 15, N'logocCruzAzul') INSERT INTO General VALUES (6, N'Chivas', 9, 14, N'logocChivas') INSERT INTO General VALUES (7, N'Atlas', 9, 14, N'logocAtlas') INSERT INTO General VALUES (8, N'Toluca', 9, 12, N'logocToluca') INSERT INTO General VALUES (9, N'Tigres', 9, 12, N'logocTigres') INSERT INTO General VALUES (10, N'Chiapas FC', 9, 12, N'logocChiapasFC') INSERT INTO General VALUES (11, N'Santos', 9, 11, N'logocSantos') INSERT INTO General VALUES (12, N'León', 9, 11, N'logocLeon') INSERT INTO General VALUES (13, N'Pachuca', 9, 11, N'logocPachuca') INSERT INTO General VALUES (14, N'Leones Negros', 9, 10, N'logocLeonesNegros') INSERT INTO General VALUES (15, N'Monterrey', 9, 10, N'logocMonterrey') INSERT INTO General VALUES (16, N'Club Querétaro', 9, 8, N'logocClubQueretaro') INSERT INTO General VALUES (17, N'Pumas', 9, 8, N'logocPumas') INSERT INTO General VALUES (18, N'Morelia', 9, 6, N'logocMorelia')

1 Response

Script de la tabla general, que se usará en la demo de DataTables en ASP.NET

Write a comment

You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.