An earlier post described that the system catalog views sys.indexes and sys.index_columns make it easy to get a list of all indexes and index columns
Category: SQL Server
SQL Server Administration, Development and Maintenance
Replace NULL value in datetime column to an empty string – SQL Server
We were stuck for a moment today in class when trying to replace the NULL values in a date column with an empty string since
List of indexes – SQL Server
The system catalog views sys.indexes and sys.index_columns make it easy to get a list of all indexes and index columns in a database. You may
Add a CHECK constraint to the existing table
In this article, you’ll know how to add a CHECK constraint to the existing table. CREATE TABLE ActiveCustomersSummary ( SummaryID INT IDENTITY(1,1) PRIMARY KEY, CustomerID
Complex CHECK Constraints in SQL Server
Depending on your needs, SQL Server allows you to use a single CHECK constraint across multiple columns or numerous CHECK Constraints across a single column.
Column CHECK constraint for column ‘col1’ references another column, table ‘table1’.
Despite the fact that SQL Server permits the addition of multiple check constraints on a single column that is referenced by other columns in the
Big Data & SQL 