Sql Server Articles (246) - Page 15

Triggers in SQL 

This article describes you how to use triggers in SQL.

Load Test SSRS Report 

SQL Server Reports are one of the key components in many of the applications and when we do Load test on an application we also make sure that the SQL Server is also capable of delivering the report in time on Load Conditions during concurrent scenarios. This Article will help to create a Web Test using Visual Studio Test Edition and and run the load test with.

Programming and Performance Tips for ADO .NET applications using Sql Server 

This articles shares the better programming standards and practices in database application programming using C# and Sql Server.

Querying and Modifying XML Data in SQL Server 2005 

Querying XML instances stored in an XML column requires parsing binary XML data in the column. Parsing binary XML is much faster than parsing the text form of the XML data.

SET NOCOUNT (Transact-SQL) 

This article explains the SET NOCOUNT keyword's importance.

TOP WITH TIES clause in SELECT queries 

This article explains the TOP with TIES clause.

How to use XML Data Type in SQL Server 2005 

This post describes how to use XML DataType and shows varrious methods to query it.

How to calculate total at the BackEnd using Trigger? 

In General we take input values what we had entered in textboxes and calculating displaying the result through front end coding.But this may not be secure to your data.so calculation have to be done at the Back end in Sqlserver using Triggers.Trigger will take input of inserted values from a table,after calculating them it insert the result at the particular result column.

Read Data From XML File in SQL Server 

Read Data From XML File in SQL Server using OPENXML

Difference Between SCOPE_IDENTITY() and @@IDENTITY 

Both SCOPE_IDENTITY() and @@IDENTITY will return the last identity value generated in the table.

Checking Integrity Constraint - SQL Server 

While loading data into a table I am disabling all the integrity constraints and after once I finished loading I am enabling all of them. Now the problem is some data which is not at all valid(Referred data not exists in parent table). How can I perform the integrity check on the loaded data and remove the unwanted same ?

Weird Thing with Inner Queries in SQL SERVER 2005 

This article demonstrated how inner queries work in SQL Server and what problems it can create if not used in best way.

Common Table Expressions in SQL Server 

In one of my recent project works, I was assigned to deliver the silverlight 2.0 solution to display Organization Chart. I was required to represent the flat or relational data into a hierarchy. Though there are number of traditional ways of achieving the same. I wanted to do something new which can increase the weightage of my decision to use Microsoft Technologies.

SQL Server SUBSTRING - Explained 

We have used SUBSTRING in many ways/scenarios. This article explains how it works.

Data Concatenation - SQL Server 

In this article, I shall show how to concatenate data from COLUMN1 by grouping against COLUMN2 without looping CURSOR.