Friday, June 5, 2009

Saturday, May 23, 2009

Site for Custom Validation

http://regexlib.com/

Friday, May 22, 2009

How to find when SQL Server was last started?

When ever SQL Server is (re)started ‘TempDB’ gets recreated. So the below query should give us the time of when ‘SQL Server’ was last started.


Select create_date from sys.databases where [name] = 'tempdb'


When a SQL Server starts all the tasks which it initiates makes an entry in sysprocesses table with its ‘login time’. That said, all we need to do is find the least login_time which has got recorded in that table!

1. Select min(login_time) from master.dbo.sysprocesses
OR
2. Select login_time from master.dbo.sysprocesses where spid = 1
OR
3. Select login_time from sys.dm_exec_sessions where session_id = 1

Tuesday, February 3, 2009

Javascript submit

Javascript Submit Object

The Submit object represents a submit button in an HTML form. For each instance of an tag in an HTML form, a Submit object is created.

You can access a Submit object by indexing the elements array (by number or name) of the corresponding form or by using getElementById().

IE: Internet Explorer, F: Firefox, N: Netscape, W3C: World Wide Web Consortium (Internet Standard).

Javascript Submit Object Properties

Javascript select

Javascript Select Object

The Javascript Select object represents a drop-down list in an HTML form. For each instance of an HTML tag in an HTML form, a Radio object is created.

You can access a Radio object by indexing the elements array (by number or name) of the corresponding form or by using getElementById().

IE: Internet Explorer, F: Firefox, N: Netscape, W3C: World Wide Web Consortium (Internet Standard).
Javascript Radio Object Properties

Javascript Input

Javscript Input Button Object

The Button object represents a button in an HTML form. For each instance of an tag in an HTML form, a Button object is created.

You can access a Button object by indexing the elements array (by number or name) of the corresponding form or by using getElementById().

IE: Internet Explorer, F: Firefox, N: Netscape, W3C: World Wide Web Consortium (Internet Standard).

Javascript checkbox

Javascript Checkbox Object

The Javascript Checkbox object represents a checkbox in an HTML form. For each instance of an tag in an HTML form, a Checkbox object is created.

You can access a Checkbox object by indexing the elements array (by number or name) of the corresponding form or by using getElementById().

IE: Internet Explorer, F: Firefox, N: Netscape, W3C: World Wide Web Consortium (Internet Standard).

Javascript Checkbox Object Properties

Javascript Form


Javascript Form Object

The Form object represents an HTML form. For each instance of an HTML
tag in a document, a Form object is created.

Forms are used to prompt users for input. The input data is normally posted to a server for processing.

IE: Internet Explorer, F: Firefox, N: Netscape, W3C: World Wide Web Consortium (Internet Standard).

Form Object Collections

Javascript Location

Javascript Location Object

The Javascript Location object is an object that can be accessed through the location property of the Window object.

The Javascript Location object contains information about the current URL.

IE: Internet Explorer, F: Firefox, N: Netscape, W3C: World Wide Web Consortium (Internet Standard).

Javascript Window

Javascript Window Object

The Javascript Window object represents the browser window. A Javascript Window object is created automatically with every instance of a or tag.

IE: Internet Explorer, F: Firefox, N: Netscape, W3C: World Wide Web Consortium (Internet Standard).

Javascript Window Object Collections

Javascript Table


Javascript Table Object

The Javascript Table object represents an HTML table. For each instance of an HTML tag in a document, a Table object is created.

IE: Internet Explorer, F: Firefox, N: Netscape, W3C: World Wide Web Consortium (Internet Standard).

Javascript Table Object Collections

Javascript Textarea


Javascript Textarea Object

The Javascript Textarea object represents a text-area in an HTML form. For each instance of an HTML