Skip to content

Instantly share code, notes, and snippets.

@bertwagner
Last active September 8, 2017 00:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save bertwagner/c22bd5c068f30bef21bf3738c5a52029 to your computer and use it in GitHub Desktop.
Save bertwagner/c22bd5c068f30bef21bf3738c5a52029 to your computer and use it in GitHub Desktop.
USE Sandbox;
GO
DROP TABLE IF EXISTS dbo.RegisteredUser
CREATE TABLE dbo.RegisteredUser
(
Id INT IDENTITY(1,1),
FullName varchar(100),
UserName varchar(40),
HashedPassword varchar(66),
JoinDate datetime2
)
--SELECT HASHBYTES('SHA2_256','asdf')
INSERT INTO dbo.RegisteredUser (FullName,UserName,HashedPassword,JoinDate) VALUES ('Toucan Sam','TFly37','0x3FC9B689459D738F8C88A3A48AA9E33542016B7A4052E001AAA536FCA74813CB','2014-02-11')
INSERT INTO dbo.RegisteredUser (FullName,UserName,HashedPassword,JoinDate) VALUES ('Crackle','StockingCap123','0x263B5FC234296526BB5765989FEE5935C66CCC7F3E9BF1670586AA002A222B7B','2016-09-09')
INSERT INTO dbo.RegisteredUser (FullName,UserName,HashedPassword,JoinDate) VALUES ('Tony','OrangeNBlack11','0xF857D5372D2BE839D5AD05357D46A93C2C9DE1220AB0B4FFF2A0B0B8EBAB8369','2015-01-30')
INSERT INTO dbo.RegisteredUser (FullName,UserName,HashedPassword,JoinDate) VALUES ('Smacks Frog','RibbetRibbet','0x3A6A65C685EB9153885A67490A0C77FC474D2665E274121CC445F5C8EEF29E6A','2017-08-09')
INSERT INTO dbo.RegisteredUser (FullName,UserName,HashedPassword,JoinDate) VALUES ('Count Chocula','OneAhHaHa','0x301ACDDD58EB7F053B013BD0129AB1343984904040729457E9B1F3EAF5A2F14D','2016-11-24')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment