Read more...

I have made an update of this script http://www.sqlservercentral.com/scripts/Metadata/64603/. the new version includes can generate 4 stored procedures for every table in a database  Read more...

History table needs individual rows for each column that has been updated, i.e., a column history.  Read more...

Unless you are working on a reporting-only application you will probably need to update tables in your SQL Server database. To update rows in a table you use the UPDATE statement. In this level we will be discussing how to find and update records in your database, and discuss the pitfalls you might run into when using the UPDATE statement.   Read more...

A stored procedure that produces a MERGE statement for a given table containing a VALUES clause for all rows, useful for migrating static data between environments.  Read more...

Read more...

A stored procedure that produces a MERGE statement for a given table containing a VALUES clause for all rows, useful for migrating static data between environments.  Read more...

Learn how you can build triggers that prevent an update or delete statement from being run without a WHERE clause in this article.  Read more...

This article covers using the REPLACE function to selectively replace text inside a string in SQL Server. The REPLACE function is easy to use and very handy with an UPDATE statment.  Read more...

Enable Lock Pages in memory on Standard edition was ONLY an Enterprise feature until now. Read this article to see how you enable this setting in SQL Server.  Read more...

Interchange column values using a single update query  Read more...

use metadata to generate basic create procedure statements for insert update and select  Read more...

This stored procedure saves time by creating a standard procedure to create or update a row.  Read more...