Sponsor of the Day:
Jerkmate
https://weblogs.asp.net/dixin/Tags/SQL-Stored-Procedure/
Dixin's Blog - Contents tagged with SQL Stored Procedure - Tags
blog contents taggedsql storeddixinproceduretags
https://www.mssqltips.com/sqlservertip/11658/sql-server-table-valued-parameter-join-issues-in-stored-procedures/
Table Valued Parameter Join Issues in SQL Stored Procedures
Learn how table valued parameter joins in SQL Server stored procedures can negatively impact query performance.
table valuedsql storedparameterjoinissues
https://www.w3schools.com:443/sql/sql_stored_procedures.asp
SQL Stored Procedures
Well organized and easy to understand Web building tutorials with lots of examples of how to use HTML, CSS, JavaScript, SQL, Python, PHP, Bootstrap, Java, XML...
sql storedprocedures
https://www.red-gate.com/hub/product-learning/sql-data-compare/testing-sql-server-stored-procedures-and-functions-with-sql-data-compare?topic=database-builds&product=sql-data-compare
Testing SQL Server Stored Procedures and Functions with SQL Data Compare | Redgate
May 29, 2020 - Phil Factor demonstrates a cunning way to test stored procedures or functions, such as after refactoring, by storing the 'before' and 'after' results in views...
sql serverstored proceduresdata comparetestingfunctions
https://www.calhoun.io/updating-and-deleting-records-using-sql/
Updating and Deleting records stored in a PostgreSQL table using SQL - Calhoun.io
A short tutorial that teaches how to update and delete records stored in an SQL database table using raw SQL statements.
postgresql tablecalhoun ioupdatingdeletingrecords
https://www.convert-in.com/m2scode
Migrate stored procedures and functions from SQL Server to MySQL
SQL Server to MySQL Code Converter is a program to migrate stored procedures and functions from SQL Server or Azure SQL databases to MySQL
stored proceduressql servermigratefunctionsmysql