-
Notifications
You must be signed in to change notification settings - Fork 0
/
tblUSERback.sql
78 lines (77 loc) · 4.2 KB
/
tblUSERback.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
USE [SegurosBD]
GO
/****** Object: Table [dbo].[tblUSER] Script Date: 13/03/2023 18:36:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tblUSER](
[id] [int] IDENTITY(1,1) NOT NULL,
[name] [varchar](50) NULL,
[lastname] [varchar](50) NULL,
[email] [varchar](50) NULL,
[password] [varchar](50) NULL,
CONSTRAINT [PK_USER] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: StoredProcedure [dbo].[deleteUSER] Script Date: 13/03/2023 18:36:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create proc [dbo].[deleteUSER]
@email varchar(50),
@password varchar(50)
as
DELETE FROM tblUSER where email = @email and password = @password
GO
/****** Object: StoredProcedure [dbo].[getUSer] Script Date: 13/03/2023 18:36:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create proc [dbo].[getUSer]
as
SELECT * FROM tblUSER
GO
/****** Object: StoredProcedure [dbo].[saveUSER] Script Date: 13/03/2023 18:36:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[saveUSER]
@name varchar(50),
@lastname varchar(50),
@email varchar(50),
@password varchar(50)
as
insert into tblUSER(name, lastname, email, password)
values(@name, @lastname, @email, @password)
GO
/****** Object: StoredProcedure [dbo].[updateUSER] Script Date: 13/03/2023 18:36:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create PROC [dbo].[updateUSER]
@name varchar(50),
@lastname varchar(50),
@email varchar(50),
@password varchar(50)
as
update tblUSER set name=@name, lastname=@lastname, email=@email where email=@email
GO
/****** Object: StoredProcedure [dbo].[Validar] Script Date: 13/03/2023 18:36:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create proc [dbo].[Validar]
@email varchar(50),
@password varchar(50)
as
select * from tblUSER where email=@email and password = @password
GO