Various SQL stuff I'm working on...tools, scripts, etc
-
Updated
Aug 8, 2024 - TSQL
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.
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.
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
A database called BookStore is used to work with stored procedure which contains transaction in MSSQL Server
Retrieve records from a table using dynamic SQL (no need to write the columns name in the sp)
Microsoft SQL Server project which utilizes a stored procedure to bulk update and bulk insert records
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.
This stored procedure allows you to build basic CRUD procedures for a given table in a SQL Server database.
Trabajo de campo: Sistema de gestión para cines en C# en 4 capas con WinForms, patrones y procedimientos almacenados
Microsoft SQL Server project which utilizes a stored procedure to extract data dynamically
Database for given project : https://github.com/aliihsank/SuperPower
A stored procedure to regenerate IDENTITY column values in SQL Server and Azure SQL, ensuring referential integrity and minimizing data loss!
Microsoft SQL Server project which utilizes a stored procedure to extract, insert, update, and or delete records
TSQL training results and materials.
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!
Add a description, image, and links to the stored-procedure topic page so that developers can more easily learn about it.
To associate your repository with the stored-procedure topic, visit your repo's landing page and select "manage topics."