TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
C# Corner
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
About T-SQL
Share
facebook
twitter
linkedIn
Reddit
Topics
No topic found
Content Filter
Articles
Videos
Blogs
News
Complexity Level
Beginner
Intermediate
Advanced
Refine by Author
[Clear]
Microsoft Press (5)
John Charles Olamendy (4)
Rajeesh Menoth (3)
Raj Kumar (3)
Shivom Agarwal (3)
Jignesh Trivedi (3)
Michael Livshitz (3)
Cenk Civici (3)
Mohamed Elqassas Mvp (2)
Gagan Sharma (2)
Sivaraman Dhamodaran (2)
Emiliano Musso (2)
Karthikeyan Anbarasan (2)
John Hudai Godel (2)
Deepak Tewatia (1)
Sagar Shinde (1)
Ahmad Anas (1)
Priyaranjan K S (1)
Akshay Phadke (1)
Nitin Pandit (1)
Kailash Chandra Behera (1)
Mukesh Kumar (1)
Anil Kumar (1)
Priti Kumari (1)
Pankaj Kumar Choudhary (1)
Harpreet Singh (1)
Vidya Vrat Agarwal (1)
Prashant Shinde (1)
Sumit Gaud (1)
Amit Tiwari (1)
Abhijit Patil (1)
Munesh Sharma (1)
Pradip Pandey (1)
Anubhav Chaudhary (1)
Sateesh Arveti (1)
Om Agarwal (1)
Veena Sarda (1)
Sharad Gupta (1)
Surjeet Yadav (1)
Shankar M (1)
Shyju (1)
Sandeep Singh Shekhawat (1)
Erika Ehrli (1)
Prabhu Raja (1)
Srinivas (1)
Mohammad Elsheimy (1)
Amit Choudhary (1)
Shirsendu Nandi (1)
Asif Sayed (1)
Ratnesh Singh (1)
Zoran Horvat (1)
Vishal Gilbile (1)
Mukesh Kumar (1)
Destin joy (1)
Ibrahim Ersoy (1)
Dhananjay Kumar (1)
Bryian Tan (1)
Manikavelu Velayutham (1)
Steve (1)
Bruce Carson (1)
Related resources for T-SQL
No resource found
Convert SQL Server Data to JSON
9/11/2022 7:12:47 AM.
Learn how to Convert SQL Server Data to JSON using JSON PATH clause.
Export SQL Result To A Text File
12/18/2017 12:30:57 PM.
This article gives an overview of how to export SQL query results to a text file.
T-SQL - Display Decimal Numbers As Money
10/17/2017 12:48:46 PM.
In this article, we will show how to display decimal numbers as money with and without cents
T-SQL - Retrieve Task Hierarchy In Project Server
10/12/2017 11:10:01 AM.
In this article, we will show how to get the Task Hierarchy for a Specific Project in Project Server Database using SQL
Subscribing and Connect Microsoft Azure With SQL Server
2/5/2017 11:24:54 PM.
This brief article will show you how to connect with SQL Server Database in Microsoft Azure.
Ranking Function In Microsoft SQL Server
12/21/2016 11:05:41 AM.
This article will explain the Ranking function in Microsoft SQL Server.
Resolving 'Cannot Connect To DataBase Master At SQL Server' Error During SharePoint 2016 Installation
9/10/2016 2:56:35 PM.
In this article, you will learn how to resolve ‘Cannot Connect to DataBase Master at SQL Server’ error during SharePoint 2016 Installation.
SQL Server 2014 Database Backup - Encryption
5/24/2016 10:31:46 AM.
In this article you will learn about SQL Server Database Backup. Microsoft SQL Server has developed a key feature introduced in SQL Server 2014, backup encryption.
How To Import Excel Data Into Microsoft SQL Server
5/3/2016 12:20:57 AM.
In this article you will learn how to import excel data into Microsoft SQL Server.
Get SQL Server Table Records in XML
1/26/2016 12:43:20 PM.
In this article I just want to show you that how to get the SQL Server table records in format of XML.
Connect SQL Server After Changing Computer Password
1/6/2016 4:51:03 AM.
In this article you will learn how to connect SQL Server after changing computer password.
How To Export SQL Server Database As .MDF File
12/31/2015 1:59:45 AM.
This article will help you to understand the procedure of exporting an existing database on your system to other system and the procedure to access it.
Displaying Line Numbers In SQL Query Editor
12/4/2015 11:34:11 AM.
In this article we will discuss about the option of displaying Line Numbers in the SQL Server Query editor.
Using the Multi-Line Table-Valued Function
12/1/2015 10:54:08 AM.
The video shows using the Multi-line function created in the Previous video
Creating Simple Table-Valued Function
11/30/2015 5:25:37 AM.
This video shows creating a simple table-valued function in SQL Server 2005
SQL Transaction Overview
11/3/2015 2:51:40 PM.
This article describes about Sql transaction with example in SQL language as well as ADO.NET.
Create And Connect SQL Server And Database On Windows Azure
11/3/2015 2:20:10 PM.
In this article you will learn how to create and connect SQL Server and database on Windows Azure.
Execute Long Running SQL Query Or Stored Procedure From .NET
10/21/2015 8:19:13 AM.
This article describes the asynchronous call to MS SQL statements from .NET environment using C# to avoid UI or main thread freezing.
User Manual For Export Tool
9/30/2015 2:49:22 PM.
In this article you will learn about User Manual for Export Tool.
Replace Function In Microsoft SQL Server
9/6/2015 1:07:40 AM.
This article will explain you how to use a replace function in Microsoft SQL Server.
Transaction Management in SQL
5/28/2015 2:45:36 PM.
This article explains Transaction Management in SQL.
Search For Missing Values Within a Numerical Sequence
5/18/2015 3:54:21 PM.
The purpose of this short article is to show a method for identifying, within a SQL Server table, gaps in a numerical sequence, to quickly locate absences of consequence within given data.
Examples Of DATE/DATETIME Conversion
5/15/2015 4:54:09 PM.
Basic considerations and examples of DATETIME, DATE and TIME data types.
Replace Nulls With Specified Values in SQL Server
2/25/2015 8:51:54 PM.
In this article we will see the various ways to replace null values in a table.
Using CLR With SQL Server 2012
2/7/2015 12:47:53 PM.
In this article, I’ll cover the SQL CLR in SQL Server 2012.
Error And Exception Handling in T-SQL
1/22/2015 2:52:13 AM.
In this article you will learn about exception handling in T-SQL.
Coding Instructions To Prevent SQL-Injection
12/12/2014 1:23:15 PM.
In this article, I am describing a few techniques to make SQL-Injection difficult.
Transact SQL Query Performance Tuning Tips
9/26/2014 9:15:49 AM.
In this article, I will discuss some T-SQL query performance tips and tricks for SQL server programmers. The tips mentioned in this article may sound obvious to most of you, but I have seen professional developers who don't think before using them.
Restore a SQL Server BACKUP Using Transact-SQL
7/24/2014 2:43:54 PM.
This article describes how to restore a SQL Server backup using one of multiple methods using Transact-SQL.
SQL Server DATABASE Transaction LOG BACKUP Using Transact-SQL
7/22/2014 12:15:33 AM.
This article describes SQL Server database transaction LOG backups and how to take a SQL Server database transaction LOG backup with multiple methods using Transact-SQL.
SQL Server DATABASE BACKUP With Multiple Methods Using Transact-SQL
7/18/2014 2:14:16 PM.
This article describes SQL Server database backups and how to take a SQL Server database backup with multiple methods using Transact-SQL.
SQL Server Transact-SQL Programming
7/4/2014 7:55:52 PM.
This article explains Transact-SQL Programming in SQL Server.
How to Use and Connect To Sqlite in a Windows Application
5/21/2014 9:43:29 PM.
Here, I will explain how to use and connect to Sqlite in a Windows application.
Useful T-SQL For Date Calculations
5/1/2014 12:05:18 PM.
In this article, we will see some useful T-SQL for date calculation.
Broadcast Real-Time SQL Data Using SignalR
3/30/2014 11:50:37 AM.
In this article you will learn how to broadcast SQL data using SignalR.
Natively Compiled Stored Procedures in SQL Server 2014
3/6/2014 12:51:36 PM.
This article describes Natively compiled stored procedures (T-SQL procedures compiled to native code and access memory optimized tables) and their use.
Broadcast SQL Data Using SignalR in ASP.Net
1/17/2014 12:02:13 PM.
In this article you will learn how to get data from SQL Server and broadcast it using SignalR in ASP.NET.
Export SQL Data to Excel Using ASP.Net
11/2/2013 7:35:37 PM.
This article explains how to export SQL Data to Excel using ASP.NET.
Look at SQL Server Object Explorer in VS 2012
10/18/2013 3:48:30 PM.
In this article, we will look into a new feature of VS 2012 to connect SQL databases hosted locally or on SQL Azure using SQL Server Object Explorer.
Backup and Restore Using Command Prompt - SQLCMD and T-SQL
9/9/2013 12:36:53 PM.
In this article I am explaining how to do backup and restore using a SQLCMD and T-SQL command prompt.
SharePoint SQL Query to Get Details on Disk Utilization and IO
7/24/2013 2:34:55 PM.
In this article I will demonstrate SharePoint SQL Query to get details of Disk Utilization and IO.
Installing SQL Server 2014
7/16/2013 6:12:26 PM.
This article explains how to install and use SQL Server 2014 step-by-step.
Create a Report in SSRS 2008
5/20/2013 4:42:14 PM.
In this article you will learn how to create a report in SSRS 2008.
SQL Server Functions and Oracle Equivalent
5/4/2013 5:31:41 PM.
This article looks at SQL Server string, numeric and date functions and their Oracle equivalents.
Installing SharePoint 2013: Part 1
2/7/2013 12:02:53 PM.
Installing SharePoint 2013 is an interesting experience if you didn’t mess it up. As a first step we need to understand the hardware and software requirement for SharePoint 2013.
CASE Statement In Transact-SQL
1/5/2013 1:57:34 PM.
In this article I am going to explain the case statement in Transact-SQL and how to sort table data using the case statement
Insert Master-Detail Data using Transact-SQL
10/20/2012 2:17:59 AM.
Microsoft SQL Server 2000 SQLXML allows among other things to manage batch operations in a database, which reduces significantly the need of more than one round-trip to a database. OpenXML is a Transact-SQL statement that allows to represent data in XML format and can be used to insert, update, and delete more than one row (represented by an element) in a table or group of tables.
Database Server-side Applications.Extensions to SQL
10/4/2012 10:07:53 AM.
Developers have struggled with the power and limitations of SQL. SQL is language oriented to manipulate data set, but enterprise applications always need to implement business logic that goes beyond the reach of SQL. This article is intended to illustrate the main constructs in these database management systems.
Using OUTPUT Clause for Getting Deleting Information from Several Tables.
10/4/2012 9:19:49 AM.
In this article I will explain how you can use such a T-SQL (SQL Server 2005) feature as OUTPUT clause in order to get information about rows, which were affected, when deleting process is executed for several tables, “connected” by foreign keys. The examples are written using T-SQL and C#.
Triggers and Active Databases
10/3/2012 9:27:59 AM.
This article is intended to illustrate how to use triggers in databases systems to enforce business rules and react to events in database applications thus supporting the Active databases principles.
Table Valued CLR Function in SQL Server 2005
8/28/2012 6:44:03 PM.
In SQL Server 2005 and later versions of it, database objects such as functions, Stored Procedures, etc. can be created which are already created in CLR.
CLR Function in SQL Server 2005
8/27/2012 5:39:47 PM.
In SQL Server 2005 and later version of it, database objects like function, store Procedure, etc can be created which are already created in CLR.
Put SQL Server’s Query Execution Engine on Hold
8/27/2012 4:26:00 PM.
Here you will see how to put your SQL Server’s Query Execution Engine on hold for a while.
SQL Azure - Resetting SQL Azure Database Administrator Credentials
5/20/2012 7:39:30 AM.
In this article we are going to see how to do a reset of the SQL Azure database administrator credentials
Using the System Function fn_listextendedproperty of SQL Server 2005 for .NET Applications: Part II
5/20/2012 5:57:16 AM.
In this article, divided into two parts, I will compare the system function fn_listextendedproperty of SQL Server 2005 with the similar function of SQL Server 2000 ( Part 1 ), describe using the function for .NET applications ( Part 2 ). The examples are written using Transact-SQL and C#.
Import Data from SQL Server 2005 to Excel Sheet and Viceversa
5/20/2012 3:04:39 AM.
This Article Shows How to Use SQL Server to Export Data from SQL Server to Excel Sheets and Viceversa.
Working with SQL Server Logins
5/20/2012 2:52:23 AM.
Learn how to work with logins in SQL Server programmatically and via SQL Server Management Studio.
SQL Optimization Tips
5/20/2012 2:45:07 AM.
This article lists some of the optimization tips for SQL Server development.
Chapter 9: Reporting Services Enhancements
5/20/2012 1:52:39 AM.
If you thought Microsoft SQL Server 2008 Reporting Services introduced a lot of great new features to the reporting platform, just wait until you discover what’s new in Reporting Services in SQL Server 2008 R2.
SQL Server Integration Services (SSIS)- Export Data using Wizard
5/20/2012 1:06:24 AM.
In this article we will see how to export data from SQL Server using the wizard which is provided with SSMS (SQL server Management Studio).
Generate Database Script with Table Data From SQL Server 2008
5/19/2012 6:18:28 AM.
In this article I will describe how to generate a database script for a table with all it's data, views, stored procedures, constraints and login credentials.
Self-Service Analysis with PowerPivot
5/19/2012 5:28:36 AM.
Microsoft SQL Server 2008 R2 comes to the rescue for these users with two new features to meet these needs-SQL Server PowerPivot for Excel 2010 and SQL Server PowerPivot for SharePoint 2010. PowerPivot for Excel gives analysts a way to integrate large volumes of data outside of a corporate data warehouse, whether they are creating reports to support decision making or prototyping solutions that will eventually be part of a larger BI implementation.
Dynamic Document ID's without Maintaining Counters!
5/19/2012 4:08:27 AM.
An article to demonstrate the creation of business document ids without using stored counters.
Simulating Autonomous Transactions in Microsoft SQL Server
5/15/2012 1:14:24 PM.
In the article, I will cover how to use table variable techniques in order to simulate the autonomous transaction behavior of Oracle databases in Microsoft SQL Server.
XML Data Type in Microsoft SQL Server 2005
5/15/2012 1:07:41 PM.
In this article we will see about XML data type in Microsoft SQL Server 2005.
Implementing and Using Fishhook Relation in Transact SQL
8/17/2011 7:56:17 AM.
Here the use of fishhook relation to represent tree structures is explained through a detailed example in T-SQL.
Managed Code in SQL Server 2005
8/9/2011 12:17:40 AM.
As a database developer you create database objects such as procedure, functions and triggers to implement programming logic by using T-Sql.
Chapter 8: Complex Event Processing with StreamInsight
7/20/2011 12:30:59 AM.
Microsoft SQL Server StreamInsight is a complex event processing (CEP) engine. This technology is a new offering in the SQL Server family, making its first appearance in SQL Server 2008 R2. It ships with the Standard, Enterprise, and Datacenter editions of SQL Server 2008 R2.
Creating an OLAP Cube (SSAS)
6/14/2011 3:45:31 PM.
Here you will see how to create an OLAP Cube (SSAS).
Configuring Claims-Based Web Applications by Using ASP.NET SQL Membership and Role Providers in SharePoint 2010
4/27/2011 4:00:31 PM.
In this article I am demonstrating how to create a claims-based web application using a Microsoft ASP.NET membership and a role provider as the authentication provider.
Computed Columns in SQL Server
3/8/2011 12:46:29 AM.
In this article, i'll be talking about how you can create Computed Columns and understand it.
Microsoft Sql Server Error : 10061
2/21/2011 2:57:27 PM.
Here you will see how to solve the Microsoft Sql Server error: 10061.
Chapter 7: Master Data Services
1/13/2011 3:30:00 AM.
Microsoft SQL Server 2008 R2 Master Data Services (MDS) is another new technology in the SQL Server family and is based on software from Microsoft’s acquisition of Stratature in 2007.
SQL Injection and Cross-Site Scripting
12/21/2010 8:24:53 AM.
An article on SQL Injection and Cross-Site Scripting with sample code.
SQLCLR vs. T-SQL - Performance Comparison
12/9/2010 11:41:06 AM.
Before comparing the performance of SQLCLR and TSQL, just have a quick at the definition of SQLCLR.
Chapter 4: High Availability and Virtualization Enhancements
12/2/2010 2:22:57 AM.
This chapter discusses the enhancements to high availability that significantly contribute to the capabilities of SQL Server 2008 R2 in both physical and virtual environments.
Oracle database 11g and Microsoft SQL Server 2008
8/22/2009 8:32:09 AM.
In this article, I want to cover the new features in Oracle 11g and SQL Server 2008 database systems which are two important players always fighting for the top spot in this important market segment of the IT industry. By analyzing these two giants, we can see the trends in the database systems. It’s remarkable to say that I will analyze these database systems from the developer perspective.
Using SQL Server 2005 system SP to change extended property values of database objects
8/1/2007 1:53:40 AM.
In this article, that is the logical continuation of the earlier published articles, I will show how you can update the value of an existing extended property or add a new extended property to a database object with the help of the system stored procedures of SQL 2005. The examples are written using T-SQL.
System Views and Functions in SQL Server 2005 by Steve on Jul 06, 2006
3/15/2007 7:07:06 AM.
I tried to explore some basic TSQL functions and VIEWS in SQL Server 2005. I believe this would be useful when we write DDL-DML Statements.
Building Data Access Helper Component for Microsoft SQL Server
2/3/2006 12:58:58 AM.
In this article I will be going through the development of a class library similar to Microsoft Data Application Blocks.
Building Data Access Helper Component for Microsoft SQL Server
2/3/2006 12:58:58 AM.
In this article I will be going through the development of a class library similar to Microsoft Data Application Blocks.
Building Data Access Helper Component for Microsoft SQL Server
2/3/2006 12:58:58 AM.
In this article I will be going through the development of a class library similar to Microsoft Data Application Blocks.
Real Life SQL and .NET: Part I
1/4/2006 3:55:32 AM.
Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management. Alas, for the reason that it is first necessary to provide a background of SQL and cover some preliminary concepts that we need to know, the majority of this article is text in paragraph format.
Real Life SQL and .NET: Part I
1/4/2006 3:55:32 AM.
Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management. Alas, for the reason that it is first necessary to provide a background of SQL and cover some preliminary concepts that we need to know, the majority of this article is text in paragraph format.
SQL Demo Login in C#
12/14/2005 7:24:51 AM.
This sample code contains a reusable control that allows you to build a dialog box that queries for SQL-Server connection parameters.
- Ebook
Regular Expression Recipes for Windows Developers: A Problem-Solution Approach
Regular expressions are an essential part of programming, but they can be difficult t...
Download