Click here to Skip to main content
14,145,240 members

TSQL

Great Reads

by Ed Wiebe
Can't we obtain the benefit of using bitwise operators for SQL many-to-many relationships AND maintain referential integrity?
by Michael Lockwood
This article illustrates how to call a web service using SQL Server Integration Services (SSIS), store the XML results in a SQL Server database table then query the XML using XQuery.
by O.Nasri
A good tutorial in how you can publish your ASP.NETCore MVC web application to IIS.
by mahmood kabi
extract overlapped polygons and calculate the overlapped area and write an API for it

Latest Articles

by Jovan Popovic(MSFT)
Learn about various use cases how you can leverage JSON support in SQL Server and Azure SQL Database
by mahmood kabi
extract overlapped polygons and calculate the overlapped area and write an API for it
by Ed Wiebe
Can't we obtain the benefit of using bitwise operators for SQL many-to-many relationships AND maintain referential integrity?
by outcoldman
TSQL: Passing array/list/set to stored procedure (Microsoft SQL Server)

All Articles

Sort by Score

TSQL 

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?
7 May 2017
Michael Lockwood
This article illustrates how to call a web service using SQL Server Integration Services (SSIS), store the XML results in a SQL Server database table then query the XML using XQuery.
21 Oct 2017
mahmood kabi
extract overlapped polygons and calculate the overlapped area and write an API for it
11 Mar 2014
Moises Barba
Implementing the Repository and Unit of Work Patterns dynamically using Kerosene ORM
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.
23 Jan 2014
Christian Graus
The first in a series of articles seeking to explain the intermediate to advanced features of T-SQL
13 Jul 2018
Jovan Popovic(MSFT)
Learn about various use cases how you can leverage JSON support in SQL Server and Azure SQL Database
5 May 2014
Shuqian Ying
Client side data provider for data importing to a relational data service build for StackExchange data dump.
8 Jul 2011
Dr Bob
SQL Server ISS can simplify database mirrors across multiple vendors
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.
15 Dec 2010
hector [.j.] rivas
Helping the combo box autocomplete function with a frequency count.
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.
5 Sep 2013
Mr. xieguigang 谢桂纲
Easy way to map the table in the mysql database.
16 Jun 2016
Jovan Popovic(MSFT)
In this article is shown how to easily compare two rows in SQL Server using new JSON functionalities.


Advertise | Privacy | Cookies | Terms of Service
Web04 | 2.8.190518.1 | Last Updated 23 May 2019
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid