Skip to content

Instantly share code, notes, and snippets.

@dsibinski
Created November 15, 2017 21:21
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Embed
What would you like to do?
SET xact_abort ON
GO
BEGIN TRANSACTION
GO
CREATE TABLE [dbo].[People]
(
[id] [INT] IDENTITY(1, 1) NOT NULL,
[name] [NVARCHAR](max) NOT NULL,
[timestamp] [TIMESTAMP] NOT NULL,
CONSTRAINT [PK_People] 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]
textimage_on [PRIMARY]
GO
if @@error != 0 raiserror('Error in script execution', 20, -1) with log
GO
CREATE PROCEDURE [dbo].[InsertPerson] @name NVARCHAR(max)
AS
BEGIN
INSERT INTO dbo.People
(NAME)
VALUES (@name);
END
GO
if @@error != 0 raiserror('Error in script execution', 20, -1) with log
GO
INSsssERT INTO dbo.Persons -- syntax error - 'INssSERT' instead of 'INSERT'
(NAME)
VALUES ('Dawid')
GO
if @@error != 0 raiserror('Error in script execution', 20, -1) with log
GO
COMMIT
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment