Various SQL stuff I'm working on...tools, scripts, etc

The stored procedure sp_alter_column is able to alter a column with dependencies in your SQL database

This repository contains sql studies, stored procedures ,triggers, etc and sample databases.

Trabajo de campo: Sistema de gestión para cines en C# en 4 capas con WinForms, patrones y procedimientos almacenados

A database called BookStore is used to work with stored procedure which contains transaction in MSSQL Server

A T-SQL Stored Procedure to generate a Date Table. Just input a year and a week start date, it will show that year's calendar with workdays flag, week information and Ontario's Public Holidays.

Retrieve records from a table using dynamic SQL (no need to write the columns name in the sp)

Creation of a relational database alongside with the ER diagram, the Relational Model and the Database Diagram. Insertion of data and creation of multiple SQL queries for data retrieval

This stored procedure allows you to build basic CRUD procedures for a given table in a SQL Server database.

Everly is an SQL Server Stored Procedure that enables one to perform any CRUD operation on a database, manages audit trail and even helps to reverse an operation done using it. Simply put, with everly, you use only one stored procedure to insert/update/delete/fetch from any table in your database and it will even manage audit trail for you.

Microsoft SQL Server project which utilizes a stored procedure to bulk update and bulk insert records

Microsoft SQL Server project which utilizes a stored procedure to extract data dynamically

Database for given project : https://github.com/aliihsank/SuperPower

Microsoft SQL Server project which utilizes a stored procedure to extract, insert, update, and or delete records

A stored procedure to regenerate IDENTITY column values in SQL Server and Azure SQL, ensuring referential integrity and minimizing data loss!

Ejercicios resueltos de la materia Base de Datos (2009).

A database called Library is used to work with stored procedure in MSSQL Server

SQL Server stored procedure to return hierarchyID data as path.

Generate all the T-SQL statements for drop and create statistics defined on SQL Server external tables in your database!

Microsoft SQL Server project which utilizes a stored procedure to extract and generate serial(s)