创建表
CREATE TABLE [aa] (
[id] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'a' AND type = 'P')
DROP PROCEDURE aGO
创建存储过程
create proc a
as
begin
declare @id varchar(10)
select top 1 @id= id from aa order by id desc
if @id is null
set @id ='CS-'+'0001'+'-'+right(year(getdate()),2)
else
set @id ='CS-'+right('000'+cast (substring(@id,4,4)+1 as varchar(3)),4)+'-'+right(year(getdate()),2)
select @id
endexec aselect * from aa;以上是在sqlserver使用的存储过程,现需在mysql使用
CREATE TABLE [aa] (
[id] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'a' AND type = 'P')
DROP PROCEDURE aGO
创建存储过程
create proc a
as
begin
declare @id varchar(10)
select top 1 @id= id from aa order by id desc
if @id is null
set @id ='CS-'+'0001'+'-'+right(year(getdate()),2)
else
set @id ='CS-'+right('000'+cast (substring(@id,4,4)+1 as varchar(3)),4)+'-'+right(year(getdate()),2)
select @id
endexec aselect * from aa;以上是在sqlserver使用的存储过程,现需在mysql使用
delimiter //
create procedure get_page(ppage int,psize int)
beginset @ppage=ppage;
set @psize=psize;
set @pbegin=(@ppage-1)*psize ;
set @str='select * from money order by paytime limit ?,?';
prepare smt from @str;
execute smt using @pbegin,@psize;
end
//
delimiter