风来君的专栏

select distinct Game from Orders排除相同的项

DECLARE @beginDate DATETIME,@endDate DATETIMESET @beginDate='2010-12-12 17:42:28.050'--时间开始SET @endDate=GETDATE()--截至时间默认为GETDATE()最新时间SELECT CASE WHEN create_date>=@beginDate THEN 'create ' ELSE 'alter ' END AS NewState, name,modify_date, crea

DECLARE @t NVARCHAR(100)DECLARE @i INT --~位置SET @t='XDD-2011-01-14-0215~XDD-2011-01-14-0216~'SET @i=0WHILE(1=1)BEGIN DECLARE @x INT SET @x=@i SET @i=CHARINDEX('~',@t,@x) IF @i=0 BEGIN BREAK END ELSE BEGIN PRINT substri