javazbpm
- 浏览: 2904 次
-
最新评论
文章列表
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>ExportTablesToExcel</title>
<script src="js/echarts.js"></script>
<script src="js/jquery.js"></script>
</head> ...
create table AA_student
(
id int PRIMARY KEY IDENTITY(1,1),
name varchar(10),
age int
)
alter PROCEDURE API_FLOWTEST
as
BEGIN
SET XACT_ABORT ON
begin tran
insert into AA_student(name,age) values('中国人民a',null);
insert into AA_student(name,age) values('中国人民共中国人民共中国人民共',null); --插入name， ...
CREATE PROCEDURE AA_TESTSP(@s_d datetime,@e_d datetime)
AS
print @s_d
print @e_d;
WHILE datename(year,@s_d)+'-'+datename(month,@s_d) <= datename(year,@e_d)+'-'+datename(month,@e_d)
BEGIN
print datename(year,@s_d)+'-'+datename(month,@s_d)+'-01' + '_' +convert(varchar(10),dateadd(dd,-DatePa ...