94 results for “topic:tsql-stored-procedures”
Tsql stored procedures and scripts to help the DBAs and Developers to make their job easier
A SQL Server (tSQL) based cron implementation using stored-procedures
No description provided.
This procedure can be used to generate a CREATE TABLE script for a given table in SQL Server
Cargo_Service_Database
full-featured Restaurant Management API built with Node.js, Express, and SQL Server. It provides seamless communication between a desktop system (cashier) and an Android app (captain/waiter), allowing both sides to manage tables, categories, and orders efficiently
An exploratory analysis on covid19 cases and deaths. Other interesting factors which are available in the dataset like, Stringency Index, Human Development Index, Percentage of smokers in population etc., are also explored in this analysis
Example of Entity Framework (Code First) MVVM
Modélisation et développement d’une application E-Commerce, Technologies utilisées : C#, ADO .NET, SQL Server, Razor, CSHTML, CSS, BOOTSTRAP, JS, AJAX
Transact-SQL (T-SQL) is a programming language used to manage and manipulate relational databases. It is a proprietary language developed by Microsoft and is the primary language used for programming Microsoft SQL Server
One-button SQL Server configuration to implement commonly-accepted best practices.
Develop a .NET Core console solution in C# that reads a *.csv file stored in an Azure storage account and inserts its content into a local SQL Server DB.
No description provided.
SQL Workouts
A high school database project for Microsoft SQL Server, written in Transact-SQL. Made for a hypothetical delivery company, so that they can manage their orders, clients, couriers, recipients, addresses and more.
App store database design
LTHFT Data Model - A structured SQL Server data model from the LTH Daily Management System (DMS), including the full schema, database project, and Snowflake-integrated DataHub objects for downstream use.
A useful collection of T-SQL procs, functions and views.
It is intended for database professionals, students, and anyone interested in deepening their understanding of complex SQL queries, performance optimization, and database design.
Web API for todo list developed including login, register, add/upd todo and list todo
SQL Serverのサンプルクエリです。拙著「SQL Server 実践開発ガイド」に掲載されているSQLスクリプトファイルをダウンロードすることができます。
PS Script + TSQL Stored Procedure to make new folders on a PBIRS with Permissions
Creation of BookStore App Backend using ASP.Net core by using Database First Approach with the implementation of Dependency Injections,3-Tier Architecture, Swagger, JWT Token, HTTP Verbs/Methods, MSMQ, RolesAuthorization, Database SQL Stored Procedures.
Projeto usando .Net 6, Blazor, Api Minimal, MudBlazor, RestSharp, SQL
Trust iMessaging is an online messaging website that sends bulk and single messages to its customers using social media platforms like WhatsApp and stores all records in a database.
In this MS SQL Database project I am creating an Automobile Shop Management System database. On this Database project I have tried to apply all the functions of MS SQL.
SQL Server Stored Procedure to get table or view column metadata and statistics
Scripts do curso do Professor André Baltieri (Balta) na plataforma https://balta.io para revisar conceitos do SQL Server.
PET CARE DATABASE
Microsoft T-SQL snippets that I use frequently