我需要从Windows中的Perl脚本内部运行以下命令。代码不能比这更简单了:
#! C:\Perl\bin\perl
perl -e "print qq(Hello)";
我将此文件另存为test.pl。我在Windows中打开一个命令提示符,并从c:\Per\bin目录运行以下命令。当我以perl test.pl身份运行它时,我得到以下结果:
C:\Perl\bin>perl test.pl
syntax error at test.pl line 3, near ""perl -e "print"
Execution of test
DECLARE @ServDate DATE = '01/04/2013',
@PaidDate DATE = '01/25/2013'
SELECT @ServDate AS DATE ,@PaidDate AS PaidDate ,
CASE WHEN (MONTH(@ServDate) IN (9,10,11) AND MONTH(@PaidDate) IN (9,10,11)
AND YEAR(@ServDate) = YEAR(@PaidDate)) AND (convert(CHAR(4
我想知道是否可以将一个或多个参数传递给WITH子句查询;以一种非常简单的方式,这样做(显然,这是不起作用的!):
with qq(a) as (
select a+1 as increment
from dual
)
select qq.increment
from qq(10); -- should get 11
当然,我要做的用法要复杂得多,因为with子句应该在子查询中,并且我要传递的参数是根据请求从主query....details中获取的值……;-)
谢谢你的任何提示