Skip to content

Instantly share code, notes, and snippets.

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
CREATE PROCEDURE [dbo].[InsertPerson] @name NVARCHAR(max)
AS
BEGIN
INSERT INTO dbo.People
(NAME)
VALUES (@name);
END
GO
INssSERT INTO dbo.Persons -- syntax error - 'INssSERT' instead of 'INSERT'
(NAME)
VALUES ('Dawid')
GO
COMMIT
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment