Sining的共享空间

When running a long-term program, how to define the next program to run?

1) Whenever you run a long-term program (let us call it "prog.exe"), please do not run it directly.  You can create a batch file named "RunProg.bat" with following content:
----------------------
prog.exe
call next.bat
----------------------

2) Then, run the program with "RunProg.bat"

3) Now, you can define the next program to run freely and write them in "next.bat"

Check Date String
use HTTP::Date;
my $daystr="20091026";

if( str2time($daystr) )
{
   print "Yes";
}else
{
   print "No";
}

Today's String
my ($sec,$min,$hour,$mday,$mon,$year,$wday);
($sec,$min,$hour,$mday,$mon,$year,$wday,undef,undef)=localtime(time()); $year+=1900;$mon++;
 
$mon = "0".$mon unless $mon >= 10;
$mday = "0".$mday unless $mday >= 10;
 
my $today = "$year$mon$mday";

Iterate Days
for( my $str="20091001"; $str < "20101010"; $str++)
{
   if( str2time($str) )
   {
    #valid date string
   }
}

用NameManager代表离散地选择的几个列

 

=Sheet1!$B$1:$B$3,Sheet1!$J$1:$J$3,Sheet1!$A$1:$A$3

 

 

 

选择另一个表格的最后一行

行号'Newest Line'!$B$12 =  COUNT(Sheet1!A:A)

第一个值=OFFSET(Sheet1!$A$1,'Newest Line'!$B$12,COLUMN()-1)

其它值通过自动填充，自动添加。

Add Local Administrators
net localgroup Administrators "group\name" /add

Check Running Process
tasklist /m ie*

Creating

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE FUNCTION GetDateString ( @val varchar(200) )
RETURNS varchar(20)
AS
BEGIN
    DECLARE @left integer;
    DECLARE @right integer;
    DECLARE @datestring varchar(20);
    DECLARE @ret varchar(20);

    set @left = PATINDEX('%200%', @val);
    set @datestring = SUBSTRING(@val, @left, 8);
    set @right = CHARINDEX('\', @datestring);
   
    set @ret = SUBSTRING(@datestring,0,@right);
    RETURN @ret;
END
GO

Alter

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER FUNCTION [dbo].[GetDateString] ( @val varchar(200) )
RETURNS varchar(20)
AS
BEGIN
    DECLARE @left integer;
    DECLARE @right integer;
    DECLARE @datestring varchar(20);
    DECLARE @ret varchar(20);

    set @left = PATINDEX('%200%', @val);
    set @datestring = SUBSTRING(@val, @left, 12);
    set @right = CHARINDEX('\', @datestring);
   
    set @ret = SUBSTRING(@datestring,0,@right);
    RETURN @ret;
END

Test
select dbo.GetDateString('as\2009_6_22\33')

Reference

"DECLARE" http://doc.ddart.net/mssql/sql70/de-dz_2.htm
"SUBSTRING, PATINDEX, CHARINDEX" http://doc.ddart.net/mssql/sql70/fa-fz_23.htm
"CREATE FUNCTION" http://www.umachandar.com/technical/SQL2000Scripts/Main12.htm
"PATINDEX's pattern" http://www.cndw.com/tech/data/200602157855.asp
"IF" http://www.databasejournal.com/features/mssql/article.php/3087431/T-SQL-Programming-Part-1---Defining-Variables-and-IFELSE-logic.htm
"CAST" http://stackoverflow.com/questions/951320/how-to-concatenate-numbers-and-strings-to-format-numbers-in-t-sql