CREATE DATABASE [TESTDB]
GO

USE [TESTDB]
GO

CREATE TABLE Item
(
    Id INT IDENTITY(1,1) NOT NULL,
    Name NVARCHAR(120) NOT NULL,
    LastName NVARCHAR(120) NOT NULL,
    [Address] NVARCHAR(250)
)
GO
ALTER TABLE Item ADD CONSTRAINT PK_Item_Id PRIMARY KEY(Id)
GO

CREATE PROCEDURE sp_GetItemById
(
    @ItemId INT
)
AS
BEGIN
    SELECT Id, Name, LastName, [Address] FROM Item WHERE Id = @ItemId
END
GO