· 9 years ago · Nov 04, 2016, 04:10 AM
1USE [master]
2GO
3/****** Object: Database [CrediSeguro] Script Date: 3/11/2016 9:33:52 a. m. ******/
4IF NOT EXISTS (SELECT name FROM sys.databases WHERE name = N'CrediSeguro')
5BEGIN
6CREATE DATABASE [CrediSeguro]
7 CONTAINMENT = NONE
8 ON PRIMARY
9( NAME = N'CrediSeguro', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLVESPERTINA\MSSQL\DATA\CrediSeguro.mdf' , SIZE = 16384KB , MAXSIZE = 262144KB , FILEGROWTH = 16384KB )
10 LOG ON
11( NAME = N'CrediSeguro_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLVESPERTINA\MSSQL\DATA\CrediSeguro_log.ldf' , SIZE = 8192KB , MAXSIZE = 131072KB , FILEGROWTH = 8192KB )
12END
13
14GO
15ALTER DATABASE [CrediSeguro] SET COMPATIBILITY_LEVEL = 110
16GO
17IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
18begin
19EXEC [CrediSeguro].[dbo].[sp_fulltext_database] @action = 'enable'
20end
21GO
22ALTER DATABASE [CrediSeguro] SET ANSI_NULL_DEFAULT OFF
23GO
24ALTER DATABASE [CrediSeguro] SET ANSI_NULLS OFF
25GO
26ALTER DATABASE [CrediSeguro] SET ANSI_PADDING OFF
27GO
28ALTER DATABASE [CrediSeguro] SET ANSI_WARNINGS OFF
29GO
30ALTER DATABASE [CrediSeguro] SET ARITHABORT OFF
31GO
32ALTER DATABASE [CrediSeguro] SET AUTO_CLOSE OFF
33GO
34ALTER DATABASE [CrediSeguro] SET AUTO_SHRINK OFF
35GO
36ALTER DATABASE [CrediSeguro] SET AUTO_UPDATE_STATISTICS ON
37GO
38ALTER DATABASE [CrediSeguro] SET CURSOR_CLOSE_ON_COMMIT OFF
39GO
40ALTER DATABASE [CrediSeguro] SET CURSOR_DEFAULT GLOBAL
41GO
42ALTER DATABASE [CrediSeguro] SET CONCAT_NULL_YIELDS_NULL OFF
43GO
44ALTER DATABASE [CrediSeguro] SET NUMERIC_ROUNDABORT OFF
45GO
46ALTER DATABASE [CrediSeguro] SET QUOTED_IDENTIFIER OFF
47GO
48ALTER DATABASE [CrediSeguro] SET RECURSIVE_TRIGGERS OFF
49GO
50ALTER DATABASE [CrediSeguro] SET DISABLE_BROKER
51GO
52ALTER DATABASE [CrediSeguro] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
53GO
54ALTER DATABASE [CrediSeguro] SET DATE_CORRELATION_OPTIMIZATION OFF
55GO
56ALTER DATABASE [CrediSeguro] SET TRUSTWORTHY OFF
57GO
58ALTER DATABASE [CrediSeguro] SET ALLOW_SNAPSHOT_ISOLATION OFF
59GO
60ALTER DATABASE [CrediSeguro] SET PARAMETERIZATION SIMPLE
61GO
62ALTER DATABASE [CrediSeguro] SET READ_COMMITTED_SNAPSHOT OFF
63GO
64ALTER DATABASE [CrediSeguro] SET HONOR_BROKER_PRIORITY OFF
65GO
66ALTER DATABASE [CrediSeguro] SET RECOVERY SIMPLE
67GO
68ALTER DATABASE [CrediSeguro] SET MULTI_USER
69GO
70ALTER DATABASE [CrediSeguro] SET PAGE_VERIFY CHECKSUM
71GO
72ALTER DATABASE [CrediSeguro] SET DB_CHAINING OFF
73GO
74ALTER DATABASE [CrediSeguro] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )
75GO
76ALTER DATABASE [CrediSeguro] SET TARGET_RECOVERY_TIME = 0 SECONDS
77GO
78ALTER DATABASE [CrediSeguro] SET DELAYED_DURABILITY = DISABLED
79GO
80USE [CrediSeguro]
81GO
82/****** Object: User [WSUser] Script Date: 3/11/2016 9:33:53 a. m. ******/
83IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'WSUser')
84CREATE USER [WSUser] FOR LOGIN [WSUser] WITH DEFAULT_SCHEMA=[dbo]
85GO
86ALTER ROLE [db_datareader] ADD MEMBER [WSUser]
87GO
88/****** Object: Table [dbo].[Cliente] Script Date: 3/11/2016 9:33:53 a. m. ******/
89SET ANSI_NULLS ON
90GO
91SET QUOTED_IDENTIFIER ON
92GO
93SET ANSI_PADDING ON
94GO
95IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Cliente]') AND type in (N'U'))
96BEGIN
97CREATE TABLE [dbo].[Cliente](
98 [CodCliente] [int] IDENTITY(1,1) NOT NULL,
99 [DPI] [int] NOT NULL,
100 [NombrePrimero] [varchar](50) NOT NULL,
101 [NombreSegundo] [varchar](50) NOT NULL CONSTRAINT [DF_Empleados_NombreSegundo] DEFAULT (''),
102 [ApellidoPrimero] [varchar](50) NOT NULL,
103 [ApellidoSegundo] [varchar](50) NOT NULL CONSTRAINT [DF_Empleados_ApellidoSegundo] DEFAULT (''),
104 [FecNacimiento] [datetime] NOT NULL,
105 [NIT] [varchar](9) NOT NULL CONSTRAINT [DF_Empleado_NIT] DEFAULT (''),
106 [Estado] [char](1) NOT NULL DEFAULT ('A'),
107 CONSTRAINT [PK_Empleado] PRIMARY KEY CLUSTERED
108(
109 [CodCliente] ASC
110)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
111) ON [PRIMARY]
112END
113GO
114SET ANSI_PADDING OFF
115GO
116/****** Object: Table [dbo].[Movimiento] Script Date: 3/11/2016 9:33:53 a. m. ******/
117SET ANSI_NULLS ON
118GO
119SET QUOTED_IDENTIFIER ON
120GO
121IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Movimiento]') AND type in (N'U'))
122BEGIN
123CREATE TABLE [dbo].[Movimiento](
124 [CodMovimiento] [int] IDENTITY(1,1) NOT NULL,
125 [CodTarjeta] [int] NOT NULL,
126 [Cargo] [decimal](18, 2) NOT NULL CONSTRAINT [DF_Movimiento_Cargo] DEFAULT ((0)),
127 [Abono] [decimal](18, 2) NOT NULL CONSTRAINT [DF_Movimiento_Abono] DEFAULT ((0)),
128 [Fecha] [datetime] NOT NULL,
129 CONSTRAINT [PK_Movimiento] PRIMARY KEY CLUSTERED
130(
131 [CodMovimiento] ASC
132)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
133) ON [PRIMARY]
134END
135GO
136/****** Object: Table [dbo].[Tarjeta] Script Date: 3/11/2016 9:33:53 a. m. ******/
137SET ANSI_NULLS ON
138GO
139SET QUOTED_IDENTIFIER ON
140GO
141SET ANSI_PADDING ON
142GO
143IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Tarjeta]') AND type in (N'U'))
144BEGIN
145CREATE TABLE [dbo].[Tarjeta](
146 [CodTarjeta] [int] IDENTITY(1,1) NOT NULL,
147 [CodCliente] [int] NOT NULL,
148 [NumeroTarjeta] [varchar](16) NOT NULL,
149 [FecVencimiento] [datetime] NOT NULL,
150 [LimiteCredito] [decimal](18, 2) NOT NULL CONSTRAINT [DF_Tarjeta_LimiteCredito] DEFAULT ((0)),
151 [SaldoActual] [decimal](18, 2) NOT NULL CONSTRAINT [DF_Tarjeta_SaldoActual] DEFAULT ((0)),
152 [FecSaldo] [datetime] NOT NULL CONSTRAINT [DF_Tarjeta_FecSaldo] DEFAULT (getdate()),
153 CONSTRAINT [PK_Tarjeta] PRIMARY KEY CLUSTERED
154(
155 [CodTarjeta] ASC
156)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
157) ON [PRIMARY]
158END
159GO
160SET ANSI_PADDING OFF
161GO
162/****** Object: View [dbo].[vClienteAltaTarjeta] Script Date: 3/11/2016 9:33:53 a. m. ******/
163SET ANSI_NULLS ON
164GO
165SET QUOTED_IDENTIFIER ON
166GO
167IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vClienteAltaTarjeta]'))
168EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[vClienteAltaTarjeta]
169AS
170SELECT dbo.Cliente.NombrePrimero, dbo.Cliente.CodCliente, dbo.Cliente.DPI, dbo.Cliente.ApellidoPrimero, dbo.Cliente.FecNacimiento, dbo.Cliente.NIT, dbo.Cliente.Estado
171FROM dbo.Cliente INNER JOIN
172 dbo.Tarjeta ON dbo.Cliente.CodCliente = dbo.Tarjeta.CodCliente
173WHERE (dbo.Cliente.Estado = ''A'') AND (dbo.Tarjeta.FecVencimiento >= GETDATE())
174'
175GO
176/****** Object: View [dbo].[vClienteBajaTarjetaSaldo] Script Date: 3/11/2016 9:33:53 a. m. ******/
177SET ANSI_NULLS ON
178GO
179SET QUOTED_IDENTIFIER ON
180GO
181IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vClienteBajaTarjetaSaldo]'))
182EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[vClienteBajaTarjetaSaldo]
183AS
184SELECT dbo.Cliente.CodCliente, dbo.Cliente.DPI, dbo.Cliente.NombrePrimero, dbo.Cliente.ApellidoPrimero, dbo.Cliente.FecNacimiento, dbo.Cliente.NIT, dbo.Cliente.Estado, dbo.Tarjeta.CodTarjeta,
185 dbo.Tarjeta.NumeroTarjeta, dbo.Tarjeta.SaldoActual
186FROM dbo.Cliente INNER JOIN
187 dbo.Tarjeta ON dbo.Cliente.CodCliente = dbo.Tarjeta.CodCliente
188WHERE (dbo.Tarjeta.SaldoActual > 0) AND (dbo.Cliente.Estado = ''B'')
189'
190GO
191/****** Object: View [dbo].[vClienteTarjeta] Script Date: 3/11/2016 9:33:53 a. m. ******/
192SET ANSI_NULLS ON
193GO
194SET QUOTED_IDENTIFIER ON
195GO
196IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vClienteTarjeta]'))
197EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[vClienteTarjeta]
198AS
199SELECT dbo.Cliente.CodCliente, dbo.Cliente.DPI, dbo.Cliente.NombrePrimero, dbo.Cliente.NombreSegundo, dbo.Cliente.ApellidoPrimero, dbo.Cliente.ApellidoSegundo, dbo.Cliente.FecNacimiento, dbo.Cliente.NIT,
200 dbo.Cliente.Estado, dbo.Tarjeta.CodTarjeta, dbo.Tarjeta.NumeroTarjeta, dbo.Tarjeta.FecVencimiento, dbo.Tarjeta.LimiteCredito, dbo.Tarjeta.SaldoActual, dbo.Tarjeta.FecSaldo
201FROM dbo.Cliente INNER JOIN
202 dbo.Tarjeta ON dbo.Cliente.CodCliente = dbo.Tarjeta.CodCliente
203'
204GO
205/****** Object: View [dbo].[vTarjetaMovimiento] Script Date: 3/11/2016 9:33:53 a. m. ******/
206SET ANSI_NULLS ON
207GO
208SET QUOTED_IDENTIFIER ON
209GO
210IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vTarjetaMovimiento]'))
211EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[vTarjetaMovimiento]
212AS
213SELECT TOP (100) PERCENT dbo.Tarjeta.CodTarjeta, dbo.Tarjeta.NumeroTarjeta, dbo.Tarjeta.FecVencimiento, dbo.Movimiento.CodMovimiento, dbo.Movimiento.Cargo, dbo.Movimiento.Abono, dbo.Movimiento.Fecha,
214 dbo.Tarjeta.CodCliente
215FROM dbo.Movimiento INNER JOIN
216 dbo.Tarjeta ON dbo.Movimiento.CodTarjeta = dbo.Tarjeta.CodTarjeta
217'
218GO
219/****** Object: View [dbo].[vTarjetasxCliente] Script Date: 3/11/2016 9:33:53 a. m. ******/
220SET ANSI_NULLS ON
221GO
222SET QUOTED_IDENTIFIER ON
223GO
224IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vTarjetasxCliente]'))
225EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[vTarjetasxCliente]
226AS
227SELECT dbo.Cliente.CodCliente, dbo.Cliente.NombrePrimero, dbo.Cliente.DPI, dbo.Cliente.ApellidoPrimero, dbo.Cliente.FecNacimiento, dbo.Cliente.NIT, dbo.Cliente.Estado, dbo.Tarjeta.NumeroTarjeta,
228 dbo.Tarjeta.CodTarjeta, dbo.Tarjeta.FecVencimiento, dbo.Tarjeta.LimiteCredito, dbo.Tarjeta.SaldoActual, dbo.Tarjeta.FecSaldo
229FROM dbo.Cliente INNER JOIN
230 dbo.Tarjeta ON dbo.Cliente.CodCliente = dbo.Tarjeta.CodCliente
231'
232GO
233IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Movimiento_Tarjeta]') AND parent_object_id = OBJECT_ID(N'[dbo].[Movimiento]'))
234ALTER TABLE [dbo].[Movimiento] WITH CHECK ADD CONSTRAINT [FK_Movimiento_Tarjeta] FOREIGN KEY([CodTarjeta])
235REFERENCES [dbo].[Tarjeta] ([CodTarjeta])
236GO
237IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Movimiento_Tarjeta]') AND parent_object_id = OBJECT_ID(N'[dbo].[Movimiento]'))
238ALTER TABLE [dbo].[Movimiento] CHECK CONSTRAINT [FK_Movimiento_Tarjeta]
239GO
240IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Tarjeta_Cliente]') AND parent_object_id = OBJECT_ID(N'[dbo].[Tarjeta]'))
241ALTER TABLE [dbo].[Tarjeta] WITH CHECK ADD CONSTRAINT [FK_Tarjeta_Cliente] FOREIGN KEY([CodCliente])
242REFERENCES [dbo].[Cliente] ([CodCliente])
243GO
244IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Tarjeta_Cliente]') AND parent_object_id = OBJECT_ID(N'[dbo].[Tarjeta]'))
245ALTER TABLE [dbo].[Tarjeta] CHECK CONSTRAINT [FK_Tarjeta_Cliente]
246GO
247/****** Object: StoredProcedure [dbo].[paClienteDelete] Script Date: 3/11/2016 9:33:53 a. m. ******/
248SET ANSI_NULLS ON
249GO
250SET QUOTED_IDENTIFIER ON
251GO
252IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[paClienteDelete]') AND type in (N'P', N'PC'))
253BEGIN
254EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[paClienteDelete] AS'
255END
256GO
257-- =============================================
258-- Author: <Author,Paola Cabrera>
259-- Create date: <Create Date,2016-08-22>
260-- Description: <Description,Dar un cliente de baja>
261-- =============================================
262ALTER PROCEDURE [dbo].[paClienteDelete]
263 -- Add the parameters for the stored procedure here
264 @CodCliente INT = 0
265AS
266BEGIN
267 -- SET NOCOUNT ON added to prevent extra result sets from
268 -- interfering with SELECT statements.
269 SET NOCOUNT ON;
270
271 -- Insert statements for procedure here
272 UPDATE Cliente
273 SET Estado = 'B'
274 WHERE CodCliente = @CodCliente;
275END
276
277GO
278/****** Object: StoredProcedure [dbo].[paClienteInsert] Script Date: 3/11/2016 9:33:53 a. m. ******/
279SET ANSI_NULLS ON
280GO
281SET QUOTED_IDENTIFIER ON
282GO
283IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[paClienteInsert]') AND type in (N'P', N'PC'))
284BEGIN
285EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[paClienteInsert] AS'
286END
287GO
288-- =============================================
289-- Author: <Author,Daniel Santizo Saldaña>
290-- Create date: <Create Date,2016-07-15,>
291-- Description: <Description,Insert de un cliente y valores por omisión>
292-- =============================================
293ALTER PROCEDURE [dbo].[paClienteInsert]
294 -- Add the parameters for the stored procedure here
295 @NomPrim VARCHAR(50) = '',
296 @NomSeg VARCHAR(50) = '',
297 @ApePrim VARCHAR(50) = '',
298 @ApeSeg VARCHAR(50) = '',
299 @DPI INT = 0,
300 @FNac DATETIME = GETDATE,
301 @NIT VARCHAR(9) = ''
302AS
303BEGIN
304 -- SET NOCOUNT ON added to prevent extra result sets from
305 -- interfering with SELECT statements.
306 SET NOCOUNT ON;
307
308 -- Declaración de Variables
309 DECLARE @Estado CHAR(1) = 'A'
310
311 -- Todos los clientes nuevos inician con el estado A, Activo
312 INSERT INTO dbo.Cliente
313 (DPI, NombrePrimero, NombreSegundo, ApellidoPrimero,
314 ApellidoSegundo, FecNacimiento, NIT, Estado)
315
316 VALUES (
317 @DPI, @NomPrim, @NomSeg, @ApePrim,
318 @ApeSeg, @FNac, @NIT, @Estado)
319
320END
321
322
323GO
324/****** Object: StoredProcedure [dbo].[paClienteSaldo] Script Date: 3/11/2016 9:33:53 a. m. ******/
325SET ANSI_NULLS ON
326GO
327SET QUOTED_IDENTIFIER ON
328GO
329IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[paClienteSaldo]') AND type in (N'P', N'PC'))
330BEGIN
331EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[paClienteSaldo] AS'
332END
333GO
334ALTER PROCEDURE [dbo].[paClienteSaldo]
335 -- Add the parameters for the stored procedure here
336 @CodCliente INT = 0
337
338AS
339BEGIN
340 -- SET NOCOUNT ON added to prevent extra result sets from
341 -- interfering with SELECT statements.
342 SET NOCOUNT ON;
343
344 -- Insert statements for procedure here
345
346 UPDATE Tarjeta
347 SET FecSaldo = GETDATE(),
348 SaldoActual = (select ISNULL(sum(cargo),0)-isnull(sum(abono),0)
349 from Movimiento
350 WHERE CodTarjeta=Tarjeta.CodTarjeta)
351 WHERE CodCliente = @CodCliente
352END
353
354GO
355/****** Object: StoredProcedure [dbo].[paTarjetaAbono] Script Date: 3/11/2016 9:33:53 a. m. ******/
356SET ANSI_NULLS ON
357GO
358SET QUOTED_IDENTIFIER ON
359GO
360IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[paTarjetaAbono]') AND type in (N'P', N'PC'))
361BEGIN
362EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[paTarjetaAbono] AS'
363END
364GO
365-- =============================================
366-- Author: <Author,Daniel Santizo Saldaña,>
367-- Create date: <Create Date,2016-07-15,>
368-- Description: <Description,Abono a una tarjeta,>
369-- =============================================
370ALTER PROCEDURE [dbo].[paTarjetaAbono]
371 -- Add the parameters for the stored procedure here
372 @CodTarjeta INT = 0,
373 @Fecha DATETIME = GETDATE,
374 @Abono DECIMAL(18,2) = 0.00
375AS
376BEGIN
377 -- SET NOCOUNT ON added to prevent extra result sets from
378 -- interfering with SELECT statements.
379 SET NOCOUNT ON;
380
381 -- INSERT en la Tabla Movimientos un ABONO con la Fecha Recibida
382 INSERT INTO Movimiento
383 (CodTarjeta, Abono, Fecha)
384 VALUES
385 (@CodTarjeta, @Abono, @Fecha)
386
387END
388
389
390GO
391/****** Object: StoredProcedure [dbo].[paTarjetaCargo] Script Date: 3/11/2016 9:33:53 a. m. ******/
392SET ANSI_NULLS ON
393GO
394SET QUOTED_IDENTIFIER ON
395GO
396IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[paTarjetaCargo]') AND type in (N'P', N'PC'))
397BEGIN
398EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[paTarjetaCargo] AS'
399END
400GO
401-- =============================================
402-- Author: <Author,Daniel Santizo Saldaña,>
403-- Create date: <Create Date,2016-07-15,>
404-- Description: <Description,Cargo a una tarjeta,>
405-- =============================================
406ALTER PROCEDURE [dbo].[paTarjetaCargo]
407 -- Add the parameters for the stored procedure here
408 @CodTarjeta INT = 0,
409 @Fecha DATETIME = GETDATE,
410 @Cargo DECIMAL(18,2) = 0.00
411AS
412BEGIN
413 -- SET NOCOUNT ON added to prevent extra result sets from
414 -- interfering with SELECT statements.
415 SET NOCOUNT ON;
416 -- VARIABLES
417 DECLARE @Saldo DECIMAL(18,2) = 0.00;
418 DECLARE @Limite DECIMAL(18,2) = 0.00;
419
420 -- ACTUALIZA SALDO de la TARJETA
421 EXECUTE dbo.paTarjetaSaldo @CodTarjeta;
422
423 -- ENCUENTRA EL LÃmite de Crédito y el Saldo de la Tarjeta + Nuevo Cargo
424 SELECT @Saldo = SaldoActual + @Cargo,
425 @Limite = LimiteCredito
426 FROM Tarjeta
427 WHERE CodTarjeta = @CodTarjeta;
428
429 IF @Saldo > @Limite
430 BEGIN
431 RAISERROR (N'Excede LÃmite de Crédito', 16, 1)
432 END;
433 ELSE BEGIN
434
435 -- INSERT en la Tabla Movimientos un Cargo con la Fecha Recibida
436 INSERT INTO Movimiento
437 (CodTarjeta, Cargo, Fecha)
438 VALUES
439 (@CodTarjeta, @Cargo, @Fecha);
440
441 END;
442
443END
444
445GO
446/****** Object: StoredProcedure [dbo].[paTarjetaSaldo] Script Date: 3/11/2016 9:33:53 a. m. ******/
447SET ANSI_NULLS ON
448GO
449SET QUOTED_IDENTIFIER ON
450GO
451IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[paTarjetaSaldo]') AND type in (N'P', N'PC'))
452BEGIN
453EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[paTarjetaSaldo] AS'
454END
455GO
456-- =============================================
457-- Author: <Author,Daniel Santizo Saldaña,>
458-- Create date: <Create Date,2016-07-15,>
459-- Description: <Description,Actualiza el Saldo de una Tarjeta de acuerdo a los Movimientos,>
460-- =============================================
461ALTER PROCEDURE [dbo].[paTarjetaSaldo]
462 -- Add the parameters for the stored procedure here
463 @CTarjeta int = 0
464AS
465BEGIN
466 -- SET NOCOUNT ON added to prevent extra result sets from
467 -- interfering with SELECT statements.
468 SET NOCOUNT ON;
469
470 -- ACTUALIZA LA FECHA DEL SALDO y EL VALOR DE LA COLUMNA SALDOACTUAL
471 UPDATE Tarjeta
472 SET FecSaldo = GETDATE(),
473 SaldoActual = (SELECT ISNULL(SUM(Cargo),0) - ISNULL(SUM(Abono),0)
474 FROM Movimiento
475 WHERE CodTarjeta = @CTarjeta )
476 WHERE CodTarjeta = @CTarjeta
477END
478
479
480GO
481/****** Object: StoredProcedure [dbo].[paTarjetaSaldoCliente] Script Date: 3/11/2016 9:33:53 a. m. ******/
482SET ANSI_NULLS ON
483GO
484SET QUOTED_IDENTIFIER ON
485GO
486IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[paTarjetaSaldoCliente]') AND type in (N'P', N'PC'))
487BEGIN
488EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[paTarjetaSaldoCliente] AS'
489END
490GO
491-- =============================================
492-- Author: <Author,Daniel Santizo Saldaña,>
493-- Create date: <Create Date,2016-07-18,>
494-- Description: <Description,Actualiza el Saldo de una Tarjeta de acuerdo a los
495-- Movimientos para todas las tarjetas del Cliente,>
496-- =============================================
497ALTER PROCEDURE [dbo].[paTarjetaSaldoCliente]
498 -- Add the parameters for the stored procedure here
499 @CCliente int = 0
500AS
501BEGIN
502 -- SET NOCOUNT ON added to prevent extra result sets from
503 -- interfering with SELECT statements.
504 SET NOCOUNT ON;
505
506 -- ACTUALIZA LA FECHA DEL SALDO y EL VALOR DE LA COLUMNA SALDOACTUAL
507 UPDATE Tarjeta
508 SET FecSaldo = GETDATE(),
509 SaldoActual = (
510 SELECT ISNULL(SUM(Cargo),0) - ISNULL(SUM(Abono),0)
511 FROM Movimiento M
512 WHERE M.CodTarjeta = T.CodTarjeta )
513 FROM Tarjeta T
514 WHERE CodCliente = @CCliente;
515
516END
517GO
518IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'vClienteAltaTarjeta', NULL,NULL))
519EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
520Begin DesignProperties =
521 Begin PaneConfigurations =
522 Begin PaneConfiguration = 0
523 NumPanes = 4
524 Configuration = "(H (1[40] 4[20] 2[20] 3) )"
525 End
526 Begin PaneConfiguration = 1
527 NumPanes = 3
528 Configuration = "(H (1 [50] 4 [25] 3))"
529 End
530 Begin PaneConfiguration = 2
531 NumPanes = 3
532 Configuration = "(H (1 [50] 2 [25] 3))"
533 End
534 Begin PaneConfiguration = 3
535 NumPanes = 3
536 Configuration = "(H (4 [30] 2 [40] 3))"
537 End
538 Begin PaneConfiguration = 4
539 NumPanes = 2
540 Configuration = "(H (1 [56] 3))"
541 End
542 Begin PaneConfiguration = 5
543 NumPanes = 2
544 Configuration = "(H (2 [66] 3))"
545 End
546 Begin PaneConfiguration = 6
547 NumPanes = 2
548 Configuration = "(H (4 [50] 3))"
549 End
550 Begin PaneConfiguration = 7
551 NumPanes = 1
552 Configuration = "(V (3))"
553 End
554 Begin PaneConfiguration = 8
555 NumPanes = 3
556 Configuration = "(H (1[56] 4[18] 2) )"
557 End
558 Begin PaneConfiguration = 9
559 NumPanes = 2
560 Configuration = "(H (1 [75] 4))"
561 End
562 Begin PaneConfiguration = 10
563 NumPanes = 2
564 Configuration = "(H (1[66] 2) )"
565 End
566 Begin PaneConfiguration = 11
567 NumPanes = 2
568 Configuration = "(H (4 [60] 2))"
569 End
570 Begin PaneConfiguration = 12
571 NumPanes = 1
572 Configuration = "(H (1) )"
573 End
574 Begin PaneConfiguration = 13
575 NumPanes = 1
576 Configuration = "(V (4))"
577 End
578 Begin PaneConfiguration = 14
579 NumPanes = 1
580 Configuration = "(V (2))"
581 End
582 ActivePaneConfig = 0
583 End
584 Begin DiagramPane =
585 Begin Origin =
586 Top = 0
587 Left = 0
588 End
589 Begin Tables =
590 Begin Table = "Cliente"
591 Begin Extent =
592 Top = 6
593 Left = 38
594 Bottom = 136
595 Right = 218
596 End
597 DisplayFlags = 280
598 TopColumn = 0
599 End
600 Begin Table = "Tarjeta"
601 Begin Extent =
602 Top = 6
603 Left = 256
604 Bottom = 136
605 Right = 430
606 End
607 DisplayFlags = 280
608 TopColumn = 0
609 End
610 End
611 End
612 Begin SQLPane =
613 End
614 Begin DataPane =
615 Begin ParameterDefaults = ""
616 End
617 End
618 Begin CriteriaPane =
619 Begin ColumnWidths = 11
620 Column = 1440
621 Alias = 900
622 Table = 1170
623 Output = 720
624 Append = 1400
625 NewValue = 1170
626 SortType = 1350
627 SortOrder = 1410
628 GroupBy = 1350
629 Filter = 1350
630 Or = 1350
631 Or = 1350
632 Or = 1350
633 End
634 End
635End
636' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vClienteAltaTarjeta'
637GO
638IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'vClienteAltaTarjeta', NULL,NULL))
639EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vClienteAltaTarjeta'
640GO
641IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'vClienteBajaTarjetaSaldo', NULL,NULL))
642EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
643Begin DesignProperties =
644 Begin PaneConfigurations =
645 Begin PaneConfiguration = 0
646 NumPanes = 4
647 Configuration = "(H (1[40] 4[20] 2[20] 3) )"
648 End
649 Begin PaneConfiguration = 1
650 NumPanes = 3
651 Configuration = "(H (1 [50] 4 [25] 3))"
652 End
653 Begin PaneConfiguration = 2
654 NumPanes = 3
655 Configuration = "(H (1 [50] 2 [25] 3))"
656 End
657 Begin PaneConfiguration = 3
658 NumPanes = 3
659 Configuration = "(H (4 [30] 2 [40] 3))"
660 End
661 Begin PaneConfiguration = 4
662 NumPanes = 2
663 Configuration = "(H (1 [56] 3))"
664 End
665 Begin PaneConfiguration = 5
666 NumPanes = 2
667 Configuration = "(H (2 [66] 3))"
668 End
669 Begin PaneConfiguration = 6
670 NumPanes = 2
671 Configuration = "(H (4 [50] 3))"
672 End
673 Begin PaneConfiguration = 7
674 NumPanes = 1
675 Configuration = "(V (3))"
676 End
677 Begin PaneConfiguration = 8
678 NumPanes = 3
679 Configuration = "(H (1[56] 4[18] 2) )"
680 End
681 Begin PaneConfiguration = 9
682 NumPanes = 2
683 Configuration = "(H (1 [75] 4))"
684 End
685 Begin PaneConfiguration = 10
686 NumPanes = 2
687 Configuration = "(H (1[66] 2) )"
688 End
689 Begin PaneConfiguration = 11
690 NumPanes = 2
691 Configuration = "(H (4 [60] 2))"
692 End
693 Begin PaneConfiguration = 12
694 NumPanes = 1
695 Configuration = "(H (1) )"
696 End
697 Begin PaneConfiguration = 13
698 NumPanes = 1
699 Configuration = "(V (4))"
700 End
701 Begin PaneConfiguration = 14
702 NumPanes = 1
703 Configuration = "(V (2))"
704 End
705 ActivePaneConfig = 0
706 End
707 Begin DiagramPane =
708 Begin Origin =
709 Top = 0
710 Left = 0
711 End
712 Begin Tables =
713 Begin Table = "Cliente"
714 Begin Extent =
715 Top = 6
716 Left = 38
717 Bottom = 136
718 Right = 218
719 End
720 DisplayFlags = 280
721 TopColumn = 5
722 End
723 Begin Table = "Tarjeta"
724 Begin Extent =
725 Top = 10
726 Left = 303
727 Bottom = 140
728 Right = 477
729 End
730 DisplayFlags = 280
731 TopColumn = 2
732 End
733 End
734 End
735 Begin SQLPane =
736 End
737 Begin DataPane =
738 Begin ParameterDefaults = ""
739 End
740 End
741 Begin CriteriaPane =
742 Begin ColumnWidths = 11
743 Column = 1440
744 Alias = 900
745 Table = 1170
746 Output = 720
747 Append = 1400
748 NewValue = 1170
749 SortType = 1350
750 SortOrder = 1410
751 GroupBy = 1350
752 Filter = 1350
753 Or = 1350
754 Or = 1350
755 Or = 1350
756 End
757 End
758End
759' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vClienteBajaTarjetaSaldo'
760GO
761IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'vClienteBajaTarjetaSaldo', NULL,NULL))
762EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vClienteBajaTarjetaSaldo'
763GO
764IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'vClienteTarjeta', NULL,NULL))
765EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
766Begin DesignProperties =
767 Begin PaneConfigurations =
768 Begin PaneConfiguration = 0
769 NumPanes = 4
770 Configuration = "(H (1[40] 4[20] 2[20] 3) )"
771 End
772 Begin PaneConfiguration = 1
773 NumPanes = 3
774 Configuration = "(H (1 [50] 4 [25] 3))"
775 End
776 Begin PaneConfiguration = 2
777 NumPanes = 3
778 Configuration = "(H (1 [50] 2 [25] 3))"
779 End
780 Begin PaneConfiguration = 3
781 NumPanes = 3
782 Configuration = "(H (4 [30] 2 [40] 3))"
783 End
784 Begin PaneConfiguration = 4
785 NumPanes = 2
786 Configuration = "(H (1 [56] 3))"
787 End
788 Begin PaneConfiguration = 5
789 NumPanes = 2
790 Configuration = "(H (2 [66] 3))"
791 End
792 Begin PaneConfiguration = 6
793 NumPanes = 2
794 Configuration = "(H (4 [50] 3))"
795 End
796 Begin PaneConfiguration = 7
797 NumPanes = 1
798 Configuration = "(V (3))"
799 End
800 Begin PaneConfiguration = 8
801 NumPanes = 3
802 Configuration = "(H (1[56] 4[18] 2) )"
803 End
804 Begin PaneConfiguration = 9
805 NumPanes = 2
806 Configuration = "(H (1 [75] 4))"
807 End
808 Begin PaneConfiguration = 10
809 NumPanes = 2
810 Configuration = "(H (1[66] 2) )"
811 End
812 Begin PaneConfiguration = 11
813 NumPanes = 2
814 Configuration = "(H (4 [60] 2))"
815 End
816 Begin PaneConfiguration = 12
817 NumPanes = 1
818 Configuration = "(H (1) )"
819 End
820 Begin PaneConfiguration = 13
821 NumPanes = 1
822 Configuration = "(V (4))"
823 End
824 Begin PaneConfiguration = 14
825 NumPanes = 1
826 Configuration = "(V (2))"
827 End
828 ActivePaneConfig = 0
829 End
830 Begin DiagramPane =
831 Begin Origin =
832 Top = 0
833 Left = 0
834 End
835 Begin Tables =
836 Begin Table = "Cliente"
837 Begin Extent =
838 Top = 6
839 Left = 38
840 Bottom = 224
841 Right = 218
842 End
843 DisplayFlags = 280
844 TopColumn = 0
845 End
846 Begin Table = "Tarjeta"
847 Begin Extent =
848 Top = 12
849 Left = 332
850 Bottom = 199
851 Right = 506
852 End
853 DisplayFlags = 280
854 TopColumn = 0
855 End
856 End
857 End
858 Begin SQLPane =
859 End
860 Begin DataPane =
861 Begin ParameterDefaults = ""
862 End
863 Begin ColumnWidths = 9
864 Width = 284
865 Width = 1500
866 Width = 1500
867 Width = 1500
868 Width = 1500
869 Width = 1500
870 Width = 1500
871 Width = 1500
872 Width = 1500
873 End
874 End
875 Begin CriteriaPane =
876 Begin ColumnWidths = 11
877 Column = 1440
878 Alias = 1755
879 Table = 1170
880 Output = 720
881 Append = 1400
882 NewValue = 1170
883 SortType = 1350
884 SortOrder = 1410
885 GroupBy = 1350
886 Filter = 1350
887 Or = 1350
888 Or = 1350
889 Or = 1350
890 End
891 End
892End
893' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vClienteTarjeta'
894GO
895IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'vClienteTarjeta', NULL,NULL))
896EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vClienteTarjeta'
897GO
898IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'vTarjetaMovimiento', NULL,NULL))
899EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
900Begin DesignProperties =
901 Begin PaneConfigurations =
902 Begin PaneConfiguration = 0
903 NumPanes = 4
904 Configuration = "(H (1[40] 4[20] 2[20] 3) )"
905 End
906 Begin PaneConfiguration = 1
907 NumPanes = 3
908 Configuration = "(H (1 [50] 4 [25] 3))"
909 End
910 Begin PaneConfiguration = 2
911 NumPanes = 3
912 Configuration = "(H (1 [50] 2 [25] 3))"
913 End
914 Begin PaneConfiguration = 3
915 NumPanes = 3
916 Configuration = "(H (4 [30] 2 [40] 3))"
917 End
918 Begin PaneConfiguration = 4
919 NumPanes = 2
920 Configuration = "(H (1 [56] 3))"
921 End
922 Begin PaneConfiguration = 5
923 NumPanes = 2
924 Configuration = "(H (2 [66] 3))"
925 End
926 Begin PaneConfiguration = 6
927 NumPanes = 2
928 Configuration = "(H (4 [50] 3))"
929 End
930 Begin PaneConfiguration = 7
931 NumPanes = 1
932 Configuration = "(V (3))"
933 End
934 Begin PaneConfiguration = 8
935 NumPanes = 3
936 Configuration = "(H (1[56] 4[18] 2) )"
937 End
938 Begin PaneConfiguration = 9
939 NumPanes = 2
940 Configuration = "(H (1 [75] 4))"
941 End
942 Begin PaneConfiguration = 10
943 NumPanes = 2
944 Configuration = "(H (1[66] 2) )"
945 End
946 Begin PaneConfiguration = 11
947 NumPanes = 2
948 Configuration = "(H (4 [60] 2))"
949 End
950 Begin PaneConfiguration = 12
951 NumPanes = 1
952 Configuration = "(H (1) )"
953 End
954 Begin PaneConfiguration = 13
955 NumPanes = 1
956 Configuration = "(V (4))"
957 End
958 Begin PaneConfiguration = 14
959 NumPanes = 1
960 Configuration = "(V (2))"
961 End
962 ActivePaneConfig = 0
963 End
964 Begin DiagramPane =
965 Begin Origin =
966 Top = 0
967 Left = 0
968 End
969 Begin Tables =
970 Begin Table = "Movimiento"
971 Begin Extent =
972 Top = 15
973 Left = 351
974 Bottom = 209
975 Right = 567
976 End
977 DisplayFlags = 280
978 TopColumn = 0
979 End
980 Begin Table = "Tarjeta"
981 Begin Extent =
982 Top = 20
983 Left = 69
984 Bottom = 211
985 Right = 246
986 End
987 DisplayFlags = 280
988 TopColumn = 0
989 End
990 End
991 End
992 Begin SQLPane =
993 End
994 Begin DataPane =
995 Begin ParameterDefaults = ""
996 End
997 End
998 Begin CriteriaPane =
999 Begin ColumnWidths = 11
1000 Column = 1440
1001 Alias = 900
1002 Table = 1170
1003 Output = 720
1004 Append = 1400
1005 NewValue = 1170
1006 SortType = 1350
1007 SortOrder = 1410
1008 GroupBy = 1350
1009 Filter = 1350
1010 Or = 1350
1011 Or = 1350
1012 Or = 1350
1013 End
1014 End
1015End
1016' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vTarjetaMovimiento'
1017GO
1018IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'vTarjetaMovimiento', NULL,NULL))
1019EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vTarjetaMovimiento'
1020GO
1021IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'vTarjetasxCliente', NULL,NULL))
1022EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
1023Begin DesignProperties =
1024 Begin PaneConfigurations =
1025 Begin PaneConfiguration = 0
1026 NumPanes = 4
1027 Configuration = "(H (1[40] 4[20] 2[20] 3) )"
1028 End
1029 Begin PaneConfiguration = 1
1030 NumPanes = 3
1031 Configuration = "(H (1 [50] 4 [25] 3))"
1032 End
1033 Begin PaneConfiguration = 2
1034 NumPanes = 3
1035 Configuration = "(H (1 [50] 2 [25] 3))"
1036 End
1037 Begin PaneConfiguration = 3
1038 NumPanes = 3
1039 Configuration = "(H (4 [30] 2 [40] 3))"
1040 End
1041 Begin PaneConfiguration = 4
1042 NumPanes = 2
1043 Configuration = "(H (1 [56] 3))"
1044 End
1045 Begin PaneConfiguration = 5
1046 NumPanes = 2
1047 Configuration = "(H (2 [66] 3))"
1048 End
1049 Begin PaneConfiguration = 6
1050 NumPanes = 2
1051 Configuration = "(H (4 [50] 3))"
1052 End
1053 Begin PaneConfiguration = 7
1054 NumPanes = 1
1055 Configuration = "(V (3))"
1056 End
1057 Begin PaneConfiguration = 8
1058 NumPanes = 3
1059 Configuration = "(H (1[56] 4[18] 2) )"
1060 End
1061 Begin PaneConfiguration = 9
1062 NumPanes = 2
1063 Configuration = "(H (1 [75] 4))"
1064 End
1065 Begin PaneConfiguration = 10
1066 NumPanes = 2
1067 Configuration = "(H (1[66] 2) )"
1068 End
1069 Begin PaneConfiguration = 11
1070 NumPanes = 2
1071 Configuration = "(H (4 [60] 2))"
1072 End
1073 Begin PaneConfiguration = 12
1074 NumPanes = 1
1075 Configuration = "(H (1) )"
1076 End
1077 Begin PaneConfiguration = 13
1078 NumPanes = 1
1079 Configuration = "(V (4))"
1080 End
1081 Begin PaneConfiguration = 14
1082 NumPanes = 1
1083 Configuration = "(V (2))"
1084 End
1085 ActivePaneConfig = 0
1086 End
1087 Begin DiagramPane =
1088 Begin Origin =
1089 Top = 0
1090 Left = 0
1091 End
1092 Begin Tables =
1093 Begin Table = "Cliente"
1094 Begin Extent =
1095 Top = 6
1096 Left = 38
1097 Bottom = 200
1098 Right = 218
1099 End
1100 DisplayFlags = 280
1101 TopColumn = 2
1102 End
1103 Begin Table = "Tarjeta"
1104 Begin Extent =
1105 Top = 6
1106 Left = 256
1107 Bottom = 198
1108 Right = 430
1109 End
1110 DisplayFlags = 280
1111 TopColumn = 0
1112 End
1113 End
1114 End
1115 Begin SQLPane =
1116 End
1117 Begin DataPane =
1118 Begin ParameterDefaults = ""
1119 End
1120 End
1121 Begin CriteriaPane =
1122 Begin ColumnWidths = 11
1123 Column = 1440
1124 Alias = 900
1125 Table = 1170
1126 Output = 720
1127 Append = 1400
1128 NewValue = 1170
1129 SortType = 1350
1130 SortOrder = 1410
1131 GroupBy = 1350
1132 Filter = 1350
1133 Or = 1350
1134 Or = 1350
1135 Or = 1350
1136 End
1137 End
1138End
1139' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vTarjetasxCliente'
1140GO
1141IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'vTarjetasxCliente', NULL,NULL))
1142EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vTarjetasxCliente'
1143GO
1144USE [master]
1145GO
1146ALTER DATABASE [CrediSeguro] SET READ_WRITE
1147GO