Click here to Skip to main content
15,071,262 members
Everything / Programming Languages / T-SQL

T-SQL

T-SQL

Great Reads

by dale.newman
Google your SQL.
by DaveDavidson
In this article, I show LINQ to Entities syntax that will produce queries with CROSS APPLY and LEFT OUTER JOIN clauses.
by Ed Wiebe
Can't we obtain the benefit of using bitwise operators for SQL many-to-many relationships AND maintain referential integrity?
by tranthanhtu.vn
In this article, We will learn why do we need to manage the stages of our application.

Latest Articles

by Member 14691410
Providing admin with an alert mechanism via an SP
by DaveNoderer
In this article, we explore how to set up one component, an SQL pool.
by Igor Krupitsky
Fast function that excludes weekends and holidays
by Mubin M. Shaikh
Walkthrough of the process for one of the industry best practices to export all SQL tables in Flat file format

All Articles

Sort by Score

T-SQL 

Please Sign up or sign in to vote.
16 May 2013
dale.newman
Google your SQL.
Please Sign up or sign in to vote.
12 May 2017
DaveDavidson
In this article, I show LINQ to Entities syntax that will produce queries with CROSS APPLY and LEFT OUTER JOIN clauses.
Please Sign up or sign in to vote.
26 Jul 2017
Ed Wiebe
Can't we obtain the benefit of using bitwise operators for SQL many-to-many relationships AND maintain referential integrity?
Please Sign up or sign in to vote.
29 May 2017
tranthanhtu.vn
In this article, We will learn why do we need to manage the stages of our application.
Please Sign up or sign in to vote.
19 Aug 2017
Afzaal Ahmad Zeeshan
.NET Core 2.0 brings a lot of improvements to the system, and it brings a lot of pain to the developers as well. I had a lot of problems upgrading .NET Core 1.x apps to .NET Core 2.0; I yet have to feel the promise it makes about performance and so, but let us see how to upgrade our existing applica
Please Sign up or sign in to vote.
2 Jun 2017
AhsanAhmed
A brief introduction on how to use FOR XML clause in AUTO mode in Microsoft SQL Server to return data in XML format
Please Sign up or sign in to vote.
18 Feb 2016
Kuv Patel
Debug stored procedures in Visual Studio and SQL Server Management Studio.
Please Sign up or sign in to vote.
21 Oct 2017
mahmood kabi
extract overlapped polygons and calculate the overlapped area and write an API for it
Please Sign up or sign in to vote.
30 Dec 2019
Dathuraj Pasarge
Database mirroring setup without any DBA effort - on every new database creation
Please Sign up or sign in to vote.
29 Nov 2012
RovenetBill
ASP.NET c# component for editing SQL tables with plug-in column format adapter architecture.
Please Sign up or sign in to vote.
4 Oct 2016
Martin Lachman
How to create a system on MS SQL Server for detection of actual changed records in a database table.
Please Sign up or sign in to vote.
1 Jun 2017
AhsanAhmed
A brief introduction on how to use FOR XML clause in EXPLICIT mode in Microsoft SQL Server to return data in XML format
Please Sign up or sign in to vote.
11 Jul 2016
Jesus Carroll
Despite the references of several sources of unattended installation of Microsoft SQL Server Database Engine, in this article describes a script tested in real production environments and it can be used with minimal or - perhaps - no modifications.
Please Sign up or sign in to vote.
7 Dec 2016
Kuv Patel
Decrypt Stored Procedures, Views, Functions, and Triggers in SQL Server
Please Sign up or sign in to vote.
30 Apr 2018
Ryan G Conrad
Using Powershell and Windows Task Scheduler API to detect malicious login attempts on a remotely accessible SQL Server database
Please Sign up or sign in to vote.
21 Apr 2016
Emmanouil Gimissis MSc ICSD
Calculating progressive sums in T-SQL
Please Sign up or sign in to vote.
6 Jun 2018
Gunnar S
Third article in a series of three regarding NServiceBus, WebAPI and Azure Service Fabric
Please Sign up or sign in to vote.
20 Jun 2019
IChechin
How to implement free OLAP cube in your project
Please Sign up or sign in to vote.
6 Jul 2021
DaveNoderer
In this article, we explore how to set up one component, an SQL pool.
Please Sign up or sign in to vote.
5 Sep 2013
Mr. xieguigang 谢桂纲
Easy way to map the table in the mysql database.
Please Sign up or sign in to vote.
17 Apr 2016
Alex_2979
A lot of modern Business Intelligence solutions offer to transfer work of analysts to developers or rise technical level of business analysts, make them closer to developers. Instead of it, I advise to consider a solution, which takes information from Database and gives it to business analysts.
Please Sign up or sign in to vote.
16 Jun 2016
Jovan Popovic(MSFT)
How to easily compare two rows in SQL Server using new JSON functionalities
Please Sign up or sign in to vote.
11 Sep 2018
Steven L. Wentworth (12896862)
Using combination arithmetic to improve quality of SQL table design and execution
Please Sign up or sign in to vote.
12 May 2019
Manjuke Fernando
Observations made for a strange behavior on JSON_VALUE when table contains blank and non-blank values
19 Nov 2012
Code Effects
This article discusses the use of one such new feature, namely, rule-based filtering of LINQ queries using Web Rule, the XML-based super-fast rules engine, implementable as an ASP.NET or MVC component.
14 Mar 2011
Redgate Software
Continuous integration makes development more efficient – allowing bugs to be caught earlier, and providing rapid validation. But for too long, it hasn’t been standard practice for databases. This is an overview of implementing CI so you can bring database code in line with application development.
1 Aug 2014
Chris_Yates
When managing a large amount of servers and databases, having an efficient way to search for objects in a particular database, SQL Server instance or the object metadata is crucial. DBA Chris Yates tells us why SQL Search from Red Gate helps him achieve this with ease, and at no cost.
10 Mar 2017
Redgate Software
SQL Clone exploits the existing virtualization technology within Windows to take much of the sting out of the traditional problems surrounding database provisioning.
22 Sep 2017
Redgate Software
If you could gain an extra hour in your working day, what would you spend it on? One way to save time and work efficiently, is to use tools available at your fingertips. Learn how SQL Prompt Core, included free in Visual Studio Enterprise, helps you speed up working with SQL and be more productive.
Please Sign up or sign in to vote.
21 Mar 2016
Sergii Syrovatchenko
Starting from SQL Server 2005, the default trace is enabled by default on every SQL server. Default trace is a lightweight system trace, which stores a lot of useful information about the changes in the system...
Please Sign up or sign in to vote.
25 Mar 2018
Ryan G Conrad
Prevent brute-force login attacks on a remotely accessible SQL Server database using T-SQL
Please Sign up or sign in to vote.
3 Oct 2016
Mark W Solomon
In this article, I developed a way to determine all the SQL Servers in our environment at will and filter this information into Microsoft's Sunset report for Microsoft SQL Server and present all this information in an SSRS report.
Please Sign up or sign in to vote.
11 Mar 2014
mbarbac
Implementing the Repository and Unit of Work Patterns dynamically using Kerosene ORM
Please Sign up or sign in to vote.
2 Jun 2017
AhsanAhmed
A brief introduction on how to use FOR XML clause in RAW mode in MS SQL Server to return data in XML format
Please Sign up or sign in to vote.
25 Jun 2018
Dirk Bahle
A quick guide to managing 100000'ish records efficiently with SQLite and C#/.Net.
Please Sign up or sign in to vote.
3 Apr 2019
Mahsa Hassankashi
This article illustrates how to use Node.js by WCF which is written in C# and using node.js as real time communication technology with the aid of C# code to connect MS SQL Server.
Please Sign up or sign in to vote.
2 Dec 2011
Huisheng Chen
Monitor SQL Server processes and jobs, view executing SQL query, kill process / job, object explorer, database shrink/log truncate/backup/detach/attach, object version control & compare
Please Sign up or sign in to vote.
11 Jan 2011
Tim Corey
The developer’s guide to writing powerful SQL commands while avoiding the pitfalls that come from an incomplete knowledge of what is going on under the hood.
Please Sign up or sign in to vote.
19 Dec 2018
Herman<T>.Instance
In this article, the creation of dynamic pivots are explained. This works on SQL Server from version 2005 and above!
Please Sign up or sign in to vote.
8 Nov 2018
Srinivasa Dinesh Parupalli
Importing Documents from SQL Server to Azure Cosmos DB
Please Sign up or sign in to vote.
24 Mar 2014
jurhas
Supervisory Control and Data Acquisition for ARDUINO
Please Sign up or sign in to vote.
7 Aug 2016
Rahul S Chavhan
Validate an XML document in SQL Server using XSD by Rahul Chavhan
Please Sign up or sign in to vote.
23 May 2016
Miljan Radovic
Simple, open-source, fully customizable, lightweight SQL Server scheduler
Please Sign up or sign in to vote.
3 Mar 2016
Gene R. Browning
Get a quick look at your data characteristics using this tool.
Please Sign up or sign in to vote.
1 Nov 2016
Bob Crowley
In this article, I will explain the sometimes surprising behavior of  the ADO.NET SqlParameter and particularly the effects of ParameterDirection, null value and DBNull.Value on how the parameter is sent to the database.
Please Sign up or sign in to vote.
6 Feb 2017
Anuja Pawar Indore
Multi-Tenancy means same instance shared amongst all customers.
Please Sign up or sign in to vote.
23 Jan 2014
Christian Graus
The first in a series of articles seeking to explain the intermediate to advanced features of T-SQL
Please Sign up or sign in to vote.
30 Dec 2015
Daniel Miller
This article describes standard naming conventions for tables and columns, and it provides code that leverages the conventions to visualize dependencies and automatically validate and generate foreign key constraints.
Please Sign up or sign in to vote.
17 Sep 2016
Snorri Kristjansson
A SQL server CLR Stored Procedure that can query the Active Directory directly in T-SQL code
Please Sign up or sign in to vote.
13 Jul 2018
Jovan Popovic(MSFT)
Learn about various use cases how you can leverage JSON support in SQL Server and Azure SQL Database
Please Sign up or sign in to vote.
10 Dec 2017
Steven L. Wentworth (12896862)
Straightforward generation of and ensuring accuracy for DimDate values
Please Sign up or sign in to vote.
11 Jun 2013
Tom Glick Philadelphia, US
Using WCF REST Service to call Stored Procedures and run queries on SQL Server.
Please Sign up or sign in to vote.
20 Nov 2018
tranthanhtu.vn
How to build the SPA for enterprise application using Angular2 and WebApi (RESTful)
Please Sign up or sign in to vote.
22 Sep 2016
Alexandros Pappas
This project provides utilities for SQL server, such as executing a list of SQL scripts, exporting data to an SQL script, and displaying relationships between records.
Please Sign up or sign in to vote.
5 May 2014
Shuqian Ying
Client side data provider for data importing to a relational data service build for StackExchange data dump.
Please Sign up or sign in to vote.
8 Jul 2011
Dr Bob
SQL Server ISS can simplify database mirrors across multiple vendors
Please Sign up or sign in to vote.
24 May 2017
Zahid Nawaz Ch.
SqlDependency ,can be used to pick changes without executing query to see there is any update from database , WHERE CLAUSE can also be applied for narrowing scope, Its way to push changes from SQL Server to SQLDependency , .NET library , SQL Server Broker service sends updates to SQLDependency.
Please Sign up or sign in to vote.
9 Oct 2016
Md._Mehedi_Hasan
CRUD operation in .net MVC using Stored Procedure for Single and List Object Data along with SQL Transaction.
Please Sign up or sign in to vote.
24 Jan 2011
Tim Corey
The developer's guide to getting the right information out of mountains of data. Learn how to boil down the data into useful information while being confident that you haven't left any data behind.
Please Sign up or sign in to vote.
3 Jan 2018
Member 11127135
The ETL Process and Range Lookups
Please Sign up or sign in to vote.
1 Jul 2015
Frank J. Yang
This article provides code for decoding strings that have been encoded for URL transmission in pure T-SQL that works properly for all URL encoded strings.
Please Sign up or sign in to vote.
16 Aug 2016
Alexandros Pappas
An SQL script to see the table hierarchy in a database.
Please Sign up or sign in to vote.
15 Dec 2010
hector [.j.] rivas
Helping the combo box autocomplete function with a frequency count.
Please Sign up or sign in to vote.
12 Dec 2015
Miljan Radovic
Script to generate DimDate for specified date range
Please Sign up or sign in to vote.
21 Nov 2016
sunettew
In this article we will show how you can use SSIS with geometry and intersect.
Please Sign up or sign in to vote.
22 Mar 2018
Robert Vandenberg Huang
An Entity Framework log printer that converts SQL commands to executable T-SQL statement
Please Sign up or sign in to vote.
26 May 2012
meduff
Avoid Entity Framework lazy-loading relationship navigation when iterating large record sets.
Please Sign up or sign in to vote.
24 Aug 2016
Roman Ivantsov
The article provides a comparative analysis and gives patterns of using explicit locks to manage concurrent access to database documents (data split over multiple tables) in MS SQL Server, MySql, PostgreSql and Oracle. As it turned out, the solution is not always obvious or simple.
Please Sign up or sign in to vote.
29 May 2017
Tomáš Bauer
Capture of a Typical SQL Server Database Workload
Please Sign up or sign in to vote.
25 Mar 2018
Ryan G Conrad
Additional logging and data collection
Please Sign up or sign in to vote.
14 Jul 2020
Mubin M. Shaikh
Walkthrough of the process for one of the industry best practices to export all SQL tables in Flat file format
Please Sign up or sign in to vote.
14 Feb 2017
saddam_msp
Download files using T-SQL server which is very much faster then any other option.
Please Sign up or sign in to vote.
25 Mar 2018
Ryan G Conrad
More configurations and auditing tools
Please Sign up or sign in to vote.
25 Jul 2016
Dahal Mahesh
Migrate cold data from your table to Microsoft Azure for cost effective and efficient storage of data, without any code level changes.
Please Sign up or sign in to vote.
29 May 2017
tranthanhtu.vn
In this article, we will learn how to build and deploy the code
Please Sign up or sign in to vote.
17 Mar 2016
Daniel JXHV
No more ORM, EF, A Stored Procedure direct Access framework for JavaScript.
Please Sign up or sign in to vote.
25 Oct 2016
Rahul_Biswas
A simple explanation of the recursive CTE concept of T-SQL
Please Sign up or sign in to vote.
12 Apr 2016
Aqeeel
Having not ONE but TWO Identities in a single SQL Server Table