Advertisement
Guest User

Untitled

a guest
Apr 22nd, 2019
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 1.07 KB | None | 0 0
  1. USE [Database]
  2. GO
  3. /****** Object:  Table [dbo].[Tabla01]    Script Date: 22/4/2019 9:05:26 a. m. ******/
  4. SET ANSI_NULLS ON
  5. GO
  6. SET QUOTED_IDENTIFIER ON
  7. GO
  8. CREATE TABLE [dbo].[Tabla01](
  9.     [Id] [int] NULL,
  10.     [IdCliente] [varchar](50) NULL,
  11.     [TipoFactura] [varchar](50) NULL,
  12.     [Monto] [int] NULL,
  13.     [Fecha] [date] NULL
  14. ) ON [PRIMARY]
  15. GO
  16. INSERT [dbo].[Tabla01] ([Id], [IdCliente], [TipoFactura], [Monto], [Fecha]) VALUES (1, N'jperez', N'credito', 100, CAST(N'2012-10-22' AS Date))
  17. GO
  18. INSERT [dbo].[Tabla01] ([Id], [IdCliente], [TipoFactura], [Monto], [Fecha]) VALUES (2, N'mcastro', N'contado', 200, CAST(N'2012-10-23' AS Date))
  19. GO
  20. INSERT [dbo].[Tabla01] ([Id], [IdCliente], [TipoFactura], [Monto], [Fecha]) VALUES (3, N'mcastro', N'contado', 300, CAST(N'2012-11-09' AS Date))
  21. GO
  22. INSERT [dbo].[Tabla01] ([Id], [IdCliente], [TipoFactura], [Monto], [Fecha]) VALUES (4, N'jperez', N'credito', 400, CAST(N'2012-11-09' AS Date))
  23. GO
  24. INSERT [dbo].[Tabla01] ([Id], [IdCliente], [TipoFactura], [Monto], [Fecha]) VALUES (5, N'jperez', N'contado', 600, CAST(N'2012-11-09' AS Date))
  25. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement