Search This Blog

Thursday, November 12, 2009

How to use identity column in a SQL select statement

Using following statement we can select identity column in a SQL select statement.

SELECT Userid,ServiceLineID,IDENTITY(int,1,1) AS i2
INTO
#t
FROM
users
ORDER BY
ServiceLineID
SELECT * FROM #t
DROP TABLE #t

How to find width and height of an image using javascript

Using javascript we can get width and height of an image as follows.

var newImg = new Image();
newImg.src = 'file://D:\image\img123.gif';

var height= newImg.height;
var width= newImg.width;