SQL Blogs

SQL

Learn SQL, a language to query and manipulate relational database management systems.

Blogs

ASCII function in SQL Server

ASCII function in SQL Server
Venkatesan Jayakantham Apr 22, 2011
Identity insert in SQL Server table

Identity insert in SQL Server table
Venkatesan Jayakantham Apr 22, 2011
Inline Declaration and value assignation in SQL Server 2008

Inline Declaration and value assignation in SQL Server 2008
Venkatesan Jayakantham Apr 22, 2011
Generating Alpha numeric values in SQL Server like Identity property

Generating Alpha numeric values in SQL Server like Identity property
Venkatesan Jayakantham Apr 22, 2011
Puzzle question in SQL Server

Puzzle question in SQL Server
Venkatesan Jayakantham Apr 22, 2011
List down all the collations available in SQL Server

List down all the collations available in SQL Server
Venkatesan Jayakantham Apr 22, 2011
Getting Parent Child XML using TSQL

I was going through my scripts and found a neat query to get parent-child relationship. Hope this helps others as it helped us.
Raja Krishnamurthy Apr 13, 2011
Fetch random records from the table using NewID() function

Fetch random records from the table using NewID() function
Venkatesan Jayakantham Apr 06, 2011
Fetch random records from the table using NewID() function

Fetch random records from the table using NewID() function
Venkatesan Jayakantham Apr 06, 2011
ASCII function in SQL Server

ASCII function in SQL Server
Venkatesan Jayakantham Apr 06, 2011
All possible SQL Date Operations

SQL Server 2005 Date operations
Raja Krishnamurthy Apr 06, 2011
Insaller issue in Dotnet application

Insaller issue in Dotnet application
Venkatesan Jayakantham Apr 01, 2011
Prevent read and write permissions to app.config file

Prevent read and write permissions to app.config file
Venkatesan Jayakantham Apr 01, 2011
Order of Execution of Select Statement

Order of Execution of Select Statement
Venkatesan Jayakantham Mar 31, 2011
Case Statement in SQL Server

Case in Select Statement in SQL Server
Venkatesan Jayakantham Mar 31, 2011
Identify the Collation settings of the server

Identify the Collation settings of the server
Venkatesan Jayakantham Mar 23, 2011
Get the description of the Collation settings

Get the description of the Collation settings in SQL Server
Venkatesan Jayakantham Mar 23, 2011
Enable Backup compression in SQL Server

Enable Backup compression in SQL Server
Venkatesan Jayakantham Mar 23, 2011
Combining two views in SQL Server

Combining two views in SQL Server
Venkatesan Jayakantham Mar 23, 2011
Executing *.sql file form C#

How to execute sql script file from C#
Hasibul Haque Mar 22, 2011

441 - 460 of 498