Sun Application Server Startup Command: /opt/SUNWappserver/bin/asadmin start-domain --domaindir /opt/SUNWappserver/domains --user admin

Friday, January 19, 2007

SQL Server: export Resultsets into Text file and Retrieve back

create table #errorlog(line varchar(2000))
execute master.dbo.xp_cmdshell 'osql -S10.1.1.6 -E -Q"execute PSIWebV3.dbo.sp_Test" -o"c:\temp\sp_out.txt" -s"" '
insert into #errorlog
execute master.dbo.xp_cmdshell 'type "c:\temp\sp_out.txt" '
select line from #errorlog

Wednesday, January 10, 2007

JavaScript: Automatically popup window on saving file

a jwcid="helpWindow" onClick="var helpwindow=window.open(this.href,'helpwin','width=650,
height=450,left=100,top=100,resizable=yes,scrollbars=yes');
helpwindow.focus();return false">Help/a>

Wednesday, January 03, 2007

Add/Update/Delete/Select comment on SQL Server 2000

EXEC sp_addextendedproperty 'MS_Description', 'Employee ID', 'user', dbo, 'table', employee, 'column', empId

EXEC sp_updateextendedproperty 'MS_Description', 'Employee ID', 'user', dbo, 'table', employee, 'column', empId

EXEC sp_dropextendedproperty 'caption', 'user', dbo, 'table', 'employee', 'column', empId

SELECT *
FROM ::fn_listextendedproperty (NULL, 'user', 'dbo', 'table', 'employee', 'column', default)