#SQL

oschina-过年动弹抽奖sql

SELECT DISTINCT(u.id) FROM osc_opt_logs l, osc_users u WHERE l.user=u.id AND l.obj_type=10…

#SQL

自动更新日期列的值为最大日期的触发器

CREATE TRIGGER autosettimeasmax ON dbo.status after INSERT, UPDATE AS UPDATE dbo.status SE…

#SQL

身份证,组织机构,营业执照号检验函数

GO /****** Object: UserDefinedFunction [ro].[wj_ValidateIDC] Script Date: 09/29/2012 11:23…

#SQL

MsSQL Find Usages Table Or Stored Procedure

CREATE PROCEDURE [dbo].[sp_FindUsages] (@ObjectName SYSNAME) AS BEGIN SET NOCOUNT ON; CREA…

#SQL

格式化时间戳为日期格式 如,'%Y-%m-%d'类型

SELECT id, title,createdate,FROM_UNIXTIME(UNIX_TIMESTAMP(createdate),'%Y-%m-%d') AS create…

#SQL

网上看到的给大家分享一下

#SQL

求整数的逆序数

DECLARE @INPUT BIGINT,@RESULT BIGINT SET @INPUT=1234 SET @RESULT=0 while @INPUT>0 BEGIN…

#SQL

Oracle存储过程分离表中的数据

select rowid from books b; select sec8 from upload_sec; ----------------------------------…

#SQL

pl/sql九九乘法表

declare i integer; j integer; begin -- 9*9乘法表 for i in 1..9 loop for j in 1..i loop dbms_o…

#SQL

mysql 批量删除

CREATE PROCEDURE del_line() BEGIN DECLARE count_line INT; /** 先删除索引提高删除速度*/ ALTER TABLE `t…

#SQL

MySQL 导出 BLOB 字段到文件

SELECT certificate INTO DUMPFILE '/tmp/certificate.bin' FROM identity WHERE id = 42;

#SQL

将 MERGE 语句的执行结果插入到另一个表中

USE AdventureWorks2012; GO CREATE TABLE Production.UpdatedInventory (ProductID INT NOT NUL…