kuyz1的专栏

freesql自定义sql和参数查询

sqlserver 分页查询

select c.FBillID 发票内码,max(t.FDate) FDate from t_rp_checkEntry cjoin t_rp_newcheckinfo a on c.FInterID=a.FInterIDjoin t_rp_contact b on a.FContactID=b.FIDinner join (select b.FDate, c.FID from t_rp_checkEntry cjoin t_rp_newcheckinfo a on c.FIn...

Create Table #TmpCheckInfo(FNumber varchar(255) default(' '),FRP int default(1),FSortID int default(-1000),FDate datetime,FID int ,FCheckID int default(0),FCheckManerID int default(0),FCheckTypeID int default(0),FCheckManer varchar(255) defa...

Mac的workbench设置白色在cmd终端输入执行defaults write com.oracle.workbench.MySQLWorkbench NSRequiresAquaSystemAppearance -bool yes

declare @xml xmldeclare @Str varchar(max)select @xml= FDefinitionXml from t_wf_defversion where FProcDefId='5bd83a0b5ca689' and FVERSION='0083'set @Str=REPLACE(CONVERT(varchar(max),@xml),'<Logic...

sql数据自动完全备份数据库实体

创建表：CREATE TABLE Product(Id UNIQUEIDENTIFIER PRIMARY KEY,NAME VARCHAR(50) NOT NULL,Price DECIMAL(18,2) NOT NULL)代码：   void InsertTwo()        {            Console.WriteLine("使用Bulk

创建表：CREATE TABLE Product(Id UNIQUEIDENTIFIER PRIMARY KEY,NAME VARCHAR(50) NOT NULL,Price DECIMAL(18,2) NOT NULL)c#代码：   void InsertTwo()        {            Console.WriteLine("使用Bu