Archive | October, 2010

RESETING IDENTITY COLUMN IN SQL SERVER

12 Oct

DBCC CHECKIDENT(‘tableName’, RESEED, 0)

Nexe record will be started with identity 1

CREATING USER DEFINED TABLE TYPE IN SQL SERVER 2008

5 Oct

USE [DB]
GO
CREATE TYPE [dbo].[typename] AS TABLE(
[column1] [type](size) NULL/NOT NULL,
[column2] [type](size) NULL/NOT NULL,
[column3] [type](size) NULL/NOT NULL,

..

..

)

GO

JQUERY- Introduction

5 Oct

JQuery is a lightweight, fast and concise JavaScript Library that simplifies HTML document traversing, event handling, animating, and Ajax interactions for

rapid web development. JQuery is designed to change the way that you write JavaScript.Query is a library of JavaScript Functions.

The jQuery library contains the following features:

* HTML element selections
* HTML element manipulation
* CSS manipulation
* HTML event functions
* JavaScript Effects and animations
* HTML DOM traversal and modification
* AJAX
* Utilities

JQuery Syntax:

The jQuery syntax is tailor made for selecting HTML elements and perform some action on the element(s).

Basic syntax is: $(selector).action()

* A dollar sign to define jQuery
* A (selector) to “query (or find)” HTML elements
* A jQuery action() to be performed on the element(s)

JQuery selectors allow you to select and manipulate HTML elements as a group or as a single element.