USE [Users]

GO

CREATE TABLE [dbo].[Users](

[Username] [nvarchar](50) NULL,

[Password] [varbinary](50) NULL,

[ID] [int] IDENTITY(1,1) NOT NULL,

CONSTRAINT [PK_Users] 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]

USE Users;

GO

CREATE PROCEDURE UserRegistration.usp

@Username nvarchar(50),

@Password nvarchar(50)

AS

SET NOCOUNT ON;

SELECT Username

SELECT Password

FROM Users

WHERE Username = @Username

AND EndDate IS NULL;

GO

USE Users;

GO

IF EXISTS (SELECT * FROM sys.triggers

WHERE parent_class = 0 AND name = '-1')

DROP TRIGGER -1

ON DATABASE;

GO

CREATE TRIGGER -1

ON DATABASE

FOR DROP_SYNONYM

AS

RAISERROR ('Data previously stored'-1)

ROLLBACK

GO

DROP TRIGGER -1

ON DATABASE;

GO

function InsertUser(string sUsername, string sPassword)

{

SELECT ID FROM Users WHERE username=sUsername; // if you get data, there is

if there is return -1

INSERT INTO Users (username,password) VALUES (sUsername,sPassword);

return 0;

}