DataBase
piaolingzxh
这个作者很懒,什么都没留下…
展开
-
StudentDB
简单的三个实体 学生、老师、班级,如下图 use StudentDBcreate table Classes ( ClassesId int identity, ClassesName nvarchar(25) null, CreateTime date原创 2010-05-27 17:00:00 · 708 阅读 · 0 评论 -
游标
1、sql Server游标1declare mycursor cursor for (SELECT * FROM Brand) open mycursor FETCH NEXT FROM mycursor INTO @BrandID,@Name while(@@FETCH_STATUS = 0) BEGIN if not exists(select 1 from bran原创 2010-05-27 20:10:00 · 449 阅读 · 0 评论 -
Sql 数据导出到XMl 与 从XML导入到数据库
1、导出到XMl select * from Brand for xml auto ,root(Brands) 2、将上边XML内容导回 数据库CreatePROCEDURE [dbo].[P_BrandSynchronization]@xmlDocument NVARCHAR (MAX)ASBEGIN SET NOCOUNT ON原创 2010-05-27 20:15:00 · 1566 阅读 · 0 评论 -
Sql server Case when
select WorksheetID,worker,WorkDate,merchantName ,merchantNo ,manager, case when insCount>0 then 新装 else end InsStr,case when repCount>0 then 换装 else end RepStr,case when UnInsCount>0 then原创 2010-05-27 20:18:00 · 509 阅读 · 0 评论 -
Sql server With
with HostDevice as (----商户主机select TerminalID ,Deviceid hostDeviceid ,Device.ModelID,Device.SN HostSN,Device.MerchantID,Device.InstallAddress,Device.SoftVersionfrom Devicejoin model HostM on Device.Mo原创 2010-05-27 20:21:00 · 435 阅读 · 0 评论 -
Oracle 触发器
create or replace trigger InsertEdcTerminalafter INSERT on edc_terminalFOR EACH ROWDECLAREmerchantId char(15);terminalId char(8);uservalue char(6) ;updatedate char(8);updatetime char(6);v_cardtype Mer原创 2010-05-27 20:25:00 · 389 阅读 · 0 评论 -
OfflineCubeHelper
操作OfflineCubeusing System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Configuration;using System.Data.OleDb;using System.Xml.Linq;using System.Text.RegularExpressions;namespace DAL{ public clas原创 2011-01-24 19:37:00 · 624 阅读 · 0 评论 -
Sqlitehelper
<br />和SqlHelper很像,使用时只需要把System.Data.SQLite.dll放到相应目录下即可<br /> <br />using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Configuration;using System.Collections;using System.Data.SQLite;using System.原创 2011-01-24 19:32:00 · 934 阅读 · 0 评论