lovesq2018的博客

一、基础 1、说明：创建数据库 CREATE DATABASE database-name 2、说明：删除数据库 drop database dbname 3、说明：备份sql server — 创建 备份数据的 device USE master EXEC sp_addumpdevice ‘disk’, ‘testBack’, ‘c:\mssql7backup\MyNwind_1.dat’ — ...

USE [xtfsdz0331] GO /****** Object: UserDefinedFunction [dbo].[F_GetdepName] Script Date: 05/28/2019 13:46:13 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER function [dbo].[F_Getde...

set @errorSum =0 --初始化为0，即无错误 begin transaction begin set @errorSum=@errorSum+@@ERROR if(@errorSum>0) rollback transaction else commit transaction --提交回滚事务 end BEGIN TRANSACTION BEGIN TRY IF...

select sum(case when mark = 0 then point else 0 end) as Point_0, sum(case when mark = 1 then point else 0 end) as Point_1, Account from 表A group by Account; select id ,sum(case when type in (1,2...

–测试: –创建表及描述信息 create table geovindu(duname varchar(10),isname char(2)) –为表添加描述信息 EXECUTE sp_addextendedproperty N’MS_Description’, ‘人员信息表’, N’user’, N’dbo’, N’table’, N’geovindu’, NULL, NULL –为字段duna...