How to use watermark using jquery

script for jquery

$(document).ready(function() {
$(“.watermark”).focus(function() {
if ($(this).val() == this.defaultValue)
{
$(this).val(“”);
}
}
);

$(“.watermark”).blur(function() {
if ($.trim($(this).val()) == “”)
{
$(this).val(this.defaultValue);
}
}
);
}
);

css for watermark
.watermark
{
color: #ccc;
}

input text for watermark using asp.net textbox control

Drop table if exist and create table (SQL Server)

IF EXISTS(SELECT 1 FROM sys.objects WHERE OBJECT_ID = OBJECT_ID(‘table2′) AND type = ‘U’)
DROP TABLE table2
create table table2(lname varchar(20))

Note: type=’U’ means the object type is for table