摘要：1、比较得到两个时间相差的间隔SELECT datediff(minute, ’2009-04-28 12:05:00′, getdate());SELECT datediff(month, ’2009-04-28 12:05:00′, ’2009-04-28 12:05:00′); 返回结果是：0语法 DATEDIFF ( date-part, date-expression-1, date-expression-2 )date-part : year | quarter | month | week | day | hour | minute | second | millisecond参 阅读全文

摘要：/× 创建一个数据库*/CREATE DATABASE Drug ON PRIMARY(NAME='Drug',FILENAME='D:\Drug.mdf',SIZE=3027KB,MAXSIZE=UNLIMITED,FILEGROWTH=1024KB)LOG ON (NAME='Drug_LOG',FILENAME='D:\Drug.ldf',SIZE=1024,FILEGROWTH=10%)USE[Drug]GO/×创建一个用户表*/CREATE TABLE userinfo(id int identity 阅读全文