Drop all foreign keys
Drops all the foreign keys in a database. This is useful when rebuilding data warehouses.
2004-11-30 (first published: 2004-10-13)
1,384 reads
Blogs
Fixing a giant or running a SQL Server project deployment with Temporal tables
By Rayis Imayev
(2022-Jan-27) When Hogarth, a nine-year-old boy, a character from “The Iron Giant” movie, met a...
Azure Cosmos DB introduction
Azure Cosmos DB is the next-generation database that offers the highest performance, availability, and...
Display dates between two input dates using SQL DATEDIFF function in SQL Server
SQL Server has a very useful function called DATEDIFF. This function is used to...
Forums
Create View in stored procedure
Hello, I'm new here and currently learn SQL Server. For my program I try...
Optimize Query
--####################################### --Given Rawdata --####################################### create table #Base (C1 char(1),C2 char(3)) insert into #Base values...
Static data masking is not showing in 18.0 above
I read this article trying to understand the feature of data masking in SQL...
Ask SSC