Chenindex的专栏

select convert(datetime ,'20080531',120)－－－字符转换成日期CONVERT (data_type[(length)], expression [, style])select CONVERT(varchar, getdate(), 120 ) 2004-09-12 11:06:08select replace(replace(replace(CONVERT(varchar, getdate(), 120 ),/'-/',/'/'),/' /',

<br />set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go -- ============================================= -- Author: 陈伟 -- Create date: 2010-5-5 -- Description: 分页，用到了ROW_NUMBER() -- ============================================= ALTER PROCEDURE [dbo]

<br />-- ============================================= -- Author: 陈伟 -- Create date: 2010-8-9 18：49 -- Description: 分页，用到了ROW_NUMBER() -- ============================================= create PROCEDURE [dbo].[proc_ShowPage] @tblName varchar(255),

<br />今天<br /><br />select * from 表名 where to_days(时间字段名) = to_days(now());<br /><br />昨天<br /><br />SELECT * FROM 表名 WHERE TO_DAYS( NOW( ) ) - TO_DAYS( 时间字段名) <= 1<br /><br />7天<br /><br />SELECT * FROM 表名 where DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date

<br />如果由于外键约束删除table失败，则先删除所有约束：<br />--/第1步**********删除所有表的外键约束*************************/<br />DECLARE c1 cursor for <br />    select 'alter table ['+ object_name(parent_obj) + '] drop constraint ['+name+']; '<br />    from sysobjects <br />    where xty