Tuesday, 12 April 2016

Using Checksums to test for Unexpected Database Schema Changes

USE [DATABASE-NAME]
GO

SELECT CHECKSUM_AGG (CHECKSUM (
                TABLE_NAME,
                COLUMN_NAME,
                CHARACTER_MAXIMUM_LENGTH ))
FROM INFORMATION_SCHEMA.COLUMNS


No comments:

Create modal using HTML and CSS

<body>   <dialog id = "modal">      <div>        <h1>Title</h1>        <p>Sample Text</p...