Blog

T-SQL Programmability Features in SQL server 2008 - Part 4

This is Part 4 of T-SQL Features in SQL 2008. In this article we discussed about Table value parameters, Large user defined Types, Constructor support, The hieararcy id data type, DDL trigger enhancements and User defined Aggregate functions.

By Admin

XML Webservice in SQL Server

Microsoft provides a standard mechanism for accessing the database engine using SOAP via HTTP in SQL server 2005. Web services are Application Programming Interfaces, or web APIs, that will be accessed via the Hypertext Transfer Protocol and can be executed on a remote system. In order to run the following example, you have to install IIS.

By Admin

SQL Constraints

A constraint is a rule or condition defined on a table or table column(s) to prevent wrong data from being entered into the database. DML operations like INSERT, UPDATE or DELETE that violate the constraints are not allowed to modify the data and thus the constraints maintain the database integrity (i.e. the accuracy and reliability of the data in the database).

By Admin

GARBAGE COLLECTION IN .NET

The term “Garbage collection” can be defined as management of the allocation and release of memory in an application. Garbage collection is the mechanism to manage the memory by clearing up the memory allocated for unused objects in the application.

By Admin

Nullable types in C#

Nullable types are the instance of the System.Nullable struct. A Nullable type can represent the normal range of values and a null value. For example a Nullable can be assigned a value range from -2147483648 to 2147483647 or it can be assigned a null value. Another example would be a Nullable, which can be assigned the values true, false, or null. While handling databases, the ability to use null to numeric or Boolean types will a the vital role.

By Admin