Facebook

Re: sql safest cryptocurrency exchange

From kgn-web, 4 Years ago, written in SQL.
This paste is a reply to sql from sdada - go back
URL https://pastebin.pl/view/9257bbfc
Embed
Viewing differences between sql and Re: sql
SELECT c.FirstName, c.LastName, g.Name USE [test]
GO

Alter PROCEDURE dbo.CreateUser
@loginName nvarchar(100),
@userName nvarchar(100) ,
@schemaName nvarchar(10)


AS
SET NOCOUNT ON;

IF NOT EXISTS (SELECT [name] FROM Customer c, Invoice i, InvoiceLine il, Track t, Genre g [sys].[database_principals] WHERE c.CustomerId=i.CustomerId [type] = N'S' AND i.InvoiceId=il.InvoiceId AND il.TrackId=t.TrackId AND t.GenreId=g.GenreId AND g.Name='Heavy Metal' AND c.Country='USA';[name] = @loginName)
BEGIN

CREATE LOGIN [@loginName] WITH PASSWORD=N'123', DEFAULT_DATABASE=[test], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
Create USER [@userName] for login [@loginName]
GRANT SELECT, INSERT, UPDATE, DELETE ON SCHEMA :: [dbo]  to [@userName]
GRANT SELECT, INSERT, UPDATE, DELETE ON SCHEMA :: [@schemaName]  to [@userName]

END


Reply to "Re: sql"