Team SQL Circuit – Page 25

T-SQL script to delete the duplicate records in the table

/* Table Schema*/ CREATE TABLE [dbo].[SalesData]( [FiscalYear] [float] NULL, [SalesRegion] [nvarchar](255) NULL, [SalesAmount] [float] NULL ) ON…

1. Background The purpose of this article is to describe how to reset the identity column of a table in…

SELECT name AS Table_Name_WithoutClusteredIndex FROM SYS.TABLES WHERE OBJECTPROPERTY(OBJECT_ID,‘TableHasClustIndex’) = 0 ORDER BY NAME GO

CREATE ASSEMBLY uploads an assembly from .dll file to use inside an instance of SQL Server. Below is the code…

Xp_cmdshell is an extended stored procedure that provides an environment analogous to a Windows command shell and passes in a…

Approach: Sys.objects table contains information about all the objects of a database We are filtering the trigger objects with TYPE…

This script provides an easier way of restoring the analysis DB and it is useful when replica or snapshot of…

This XMLA script that supports SQL Server Analysis Service is used to take the backup of Analysis database. Change the…

1. Background The purpose of this document is to describe a way of showing custom message in the report if…

1. Background The purpose of this document is to describe a way of processing OLAP cube using SQL Server Agent…

1. Background The purpose of this document is to describe how to create connection string for OLE DB provider and…

Below is the tabular function that converts comma or semi colon separated values of a string into rows of a…