IF EXISTS (SELECT * FROM sysobjects WHERE name = 'Select_Cities' AND user_name(uid) = 'dbo')
    DROP PROCEDURE dbo.[Select_Cities]
GO

CREATE PROCEDURE dbo.[Select_Cities]
AS
    SET NOCOUNT ON;
SELECT ID_City, Name, Country, Region FROM dbo.t_Cities
GO

IF EXISTS (SELECT * FROM sysobjects WHERE name = 'Insert_Cities' AND user_name(uid) = 'dbo')
    DROP PROCEDURE dbo.[Insert_Cities]
GO

CREATE PROCEDURE dbo.Insert_Cities
(
    @Name VARCHAR(50),
    @Country VARCHAR(50),
    @Region VARCHAR(50)
)
AS
    SET NOCOUNT OFF;
INSERT INTO [dbo].[t_Cities] ([Name], [Country], [Region]) VALUES (@Name, @Country, @Region)
GO

IF EXISTS (SELECT * FROM sysobjects WHERE name = 'Update_Cities' AND user_name(uid) = 'dbo')
    DROP PROCEDURE dbo.Update_Cities
GO

CREATE PROCEDURE dbo.Update_Cities
(
    @ID_City_For_Updating INT,
    @Name VARCHAR(50),
    @Country VARCHAR(50),
    @Region VARCHAR(50)
)
AS
    SET NOCOUNT OFF;
UPDATE [dbo].[t_Cities] SET [Name] = @Name, [Country] = @Country, [Region] = @Region WHERE ([ID_City] = @ID_City_For_Updating)
GO

IF EXISTS (SELECT * FROM sysobjects WHERE name = 'Delete_City' AND user_name(uid) = 'dbo')
    DROP PROCEDURE dbo.Delete_City
GO

CREATE PROCEDURE dbo.Delete_City
(
    @ID_City_For_Deleting INT
)
AS
    SET NOCOUNT OFF;
DELETE FROM [dbo].[t_Cities] WHERE (ID_City = @ID_City_For_Deleting)
GO