sql stored procedure

Creating Stored Procedure for Dropping Local Temporary Tables in SQL Server

Evgeniy Gribkov

Evgeniy is an MS SQL Server database analyst, developer, and administrator. He is involved in the development and testing of the SQL Server database management tools. Evgeniy also writes SQL Server-related articles.
Evgeniy Gribkov

In this final part of the three-part article series, we will review creating a script, wrap it in a stored procedure, and will use it for deleting all local temp tables and one particular local temporary table.

(more…)

Implementing a Scheduled Automatic SQL Server Backup Process

Evgeniy Gribkov

Evgeniy is an MS SQL Server database analyst, developer, and administrator. He is involved in the development and testing of the SQL Server database management tools. Evgeniy also writes SQL Server-related articles.
Evgeniy Gribkov

Now that we have reviewed the backup basics in the first article of our series dedicated to SQL Server backup, let’s proceed to the implementation and automation of the SQL Server backup process.

(more…)

Support for EF Core 5.0, .NET 5.0, and More Features in Entity Developer 6.8

Devart is glad to announce the release of Entity Developer 6.8 – a visual ORM designer for a wide variety of ORMs. The new version introduces support for preview versions of Entity Framework Core 5.0 and .NET 5.0, adds ability to generate C# 8 nullable reference types and configure collection navigation properties, improves support for stored procedures, for NuGet and third-party providers, and many more.

(more…)

Export SQL Stored Procedure to a File and Generate Its Script

Evgeniy Gribkov

Evgeniy is an MS SQL Server database analyst, developer, and administrator. He is involved in the development and testing of the SQL Server database management tools. Evgeniy also writes SQL Server-related articles.
Evgeniy Gribkov

In previous articles, we have reviewed a general algorithm of finding and deleting incomplete open transactions in SQL Server databases, created a table for fixing incomplete transactions and a CRUD-stored procedure, and implemented numerous settings that will make our document workflow productive and handy.

(more…)