Pages

Saturday, 29 September 2012

Saturday, 22 September 2012

Wednesday, 19 September 2012

Defining Variables

Querying Microsoft SQL Server : Defining Variables: Defining Variables in SQL Server: Like other programming languages T-SQL allows to defining your variables. A variable is known as lo...

Querying Microsoft SQL Server : Certifications

Querying Microsoft SQL Server : Certifications: If you  would like to obtain a certification for SQL Server. The latest certification Microsoft offer for SQL Server are the MC...

Stored Procedures in SQL Server

Querying Microsoft SQL Server : Stored Procedures in SQL Server: Stored Procedure: Stored Procedure is a powerful part of SQL Server. It is group of T-SQL statements compiled into single execution ...

Control Statements in T-SQL

Querying Microsoft SQL Server : Control Statements in T-SQL: Control statements are used to control execution flow within a T-SQL.Here I provides some example on control statements. ·          ...

Saturday, 8 September 2012

Create database to test Queries of this blog..........

Run this script:


CREATE DATABASE dbTest;

CREATE TABLE Person
(
pid INT IDENTITY(1,1),
name VARCHAR(200) NOT NULL,
dob DATETIME NULL,
occupation varchar(100) NULL,
address VARCHAR(200),
city VARCHAR(100),
state VARCHAR(100),
isBlock BIT,
PRIMARY KEY(PID)
)

USE [dbTest]
GO
/****** Insert Data into Person table   ******/
SET IDENTITY_INSERT [dbo].[Person] ON
INSERT [dbo].[Person] ([pid], [name], [dob], [occupation], [address], [city], [state], [isBlock]) VALUES (1, N'Abhishek', CAST(0x00007A1B00000000 AS DateTime), N'Student', N'E-56', N'Delhi', N'Delhi', 0)
INSERT [dbo].[Person] ([pid], [name], [dob], [occupation], [address], [city], [state], [isBlock]) VALUES (2, N'Ram', CAST(0x00006E2500000000 AS DateTime), N'DBA', N'PritVihar', N'Lucknow', N'U.P.', 0)
INSERT [dbo].[Person] ([pid], [name], [dob], [occupation], [address], [city], [state], [isBlock]) VALUES (3, N'Abhijit', CAST(0x00007E8300000000 AS DateTime), N'J.DBA', N'', NULL, NULL, 1)
SET IDENTITY_INSERT [dbo].[Person] OFF


Friday, 7 September 2012

Welcome Querying SQL.

Hi,
I extend a hearty welcome on my Blog.I hope this blog be helpful for those who preparing Microsoft SQL Server certifications and also for those who are hungry to learn querying SQL server. 



Links:


Y