craeteing temp table in sqlserver 2005

CREATE TABLE #names_sample (
name_id INT IDENTITY(1, 1) NOT NULL,
company_id varchar(50),
full_name VARCHAR(110) NULL,
first_name VARCHAR(50) NULL,
middle_name VARCHAR(50) NULL,
last_name VARCHAR(30) NULL,
suffix VARCHAR(20) NULL
)

sql case statement with selecting records.

select case
when len(id)=5 then 'CO'+'000'+cast(id as varchar(5))
when len(id)=6 then 'CO'+'00'+cast(id as varchar(6))
when len(id)=7 then 'CO'+'0'+cast(id as varchar(7))
end,ContactPosition,CompanyID
from contact_id_temp

No. of visitors who are currently online

http://www.developerfusion.com/code/1745/number-of-visitors-online/





http://www.aspdotnetfaq.com/Faq/How-to-get-detailed-info-about-all-online-visitors-that-are-currently-browsing-your-ASP-NET-website.aspx

Diff between Response.Write() and Response.Output.Write()...

Response.Output.Write() will give the formatted output

Related site :http://www.dotnetspider.com/forum/ViewForum.aspx?ForumId=17922



http://www.allinterview.com/showanswers/8331.html

Mouce over in certin button

Buttaon1.Attributes.Add("onMouseOver","someClientCode();");

now you can add the code inside the JavaScript function of someClientCode()