Wednesday, January 7, 2009

Link For JavaScript Validations

Just go through this..
http://msdn.microsoft.com/en-us/library/aa218652(office.11).aspx

U want to show ur msg on taskbar

Just Check it..k

msg = "welcome to My Own Network";
timeID = 10;
stcnt = 16;
wmsg = new Array(33);
wmsg[0]=msg;
blnk = " ";
for (i=1; i<32; b =" blnk.substring(0,i);" j="0;"> -1) str = wmsg[stcnt]; else str = wmsg[0];
if (stcnt-- < -40) stcnt=31;
status = str;
clearTimeout(timeID);
timeID = setTimeout("wiper()",50);
}
wiper()

Tuesday, January 6, 2009

At Task Bar

My Scrolling

Monday, November 17, 2008

Can u Expect whats d output


write this below code in console application


string str = "ramesh;sapi;latha";
Console.WriteLine(str);
string[] saray = str.Split(new char[] { ';' });
foreach (string month in saray)
{
Console.WriteLine("{0}", month);
}
Console.ReadLine();

Tuesday, November 11, 2008

Cimple Sql Queries,Try it And Gve Sugetions



--SELECT * FROM emp e WHERE 0 < (SELECT COUNT(*) FROM emp B WHERE
--e.empsal < B.empsal)
--select min(empsal),empname from emp where empsal in(select top 4 empsal from emp order by empsal desc)
--select empname,empsal from emp where empsal in(select min(empsal) from emp where empsal in(select top 4 empsal from emp order by empsal desc))
--select empid,empsal from emp where empsal in(select min(empsal) from emp where empsal in(select top 4 empsal from emp order by desc))
--select *from emp1 order by replicate('0',len(empid)),empid
--error number--select @@error
--version name--select serverproperty('productversion'), serverproperty('productlevel')
--this is also version--select @@version
--select @@error
--select max(getdate())
--to get empnames in reverse order--SELECT * FROM emp1 ORDER BY 'empname'desc
--select * from emp1 where empname="[^l-x]%";
--select @@rowcount
--sp_columns emp1
--sp_help emp1
--By using following query we wil get the duplicate records
--SELECT empname FROM emp1
--Group By empname
--Having Count(*)=1
--select convert(char(10),getdate(),101)
--sp_configure
--sp_renamedb 'swapna','ramesh'
--DBCC CHECKDB
--DBCC CHECKALLOC
--DBCC CHECKFILEGROUP
--select STUFF('lathala',6,7,'xx')
--select replace('lathalalala','la','ramesh')
--to give ur own data type--sp_addtype ramesh,'varchar(15)','not null'
--list of tables-->sp_tables
--sp_who2
--sp_helpdb msdb
--to know DB Space--sp_spaceused emp
--use ramesh
--select name from systypes
--to know DB Space--sp_spaceused @updateusage='TRUE'
--to copy complete column into another table--
select empdesg into emp3 from emp1
select empdesg into emp10 from emp1
select *from emp4
select count(*) from information_schema.tables --how many tables in ur database(count)
select * from information_schema.tables --1.displays database tables
select *from sys.tables --2.displays database tables
select *from sys.tables order by name desc --3.displays database tables in desc order
select *from sys.indexes --displays database indexes
--to rollback a dropped table
begin tran
drop table emp10
rollback tran
select *from emp10
---u cant roll back a truncated table
begin tran
truncate emp10
rollback tran
select *from emp10
--
begin tran
select *from sys.tables
drop table emp2,emp3,emp4,emp9
rollback
select *from sys.tables

Followers