风来君的专栏

select distinct Game from Orders排除相同的项

DECLARE @beginDate DATETIME,@endDate DATETIME SET @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=0 WHILE(1=1) BEGIN DECLARE @x INT SET @x=@i SET @i=CHARINDEX('~',@t,@x) IF @i=0 BEGIN BREAK END ELSE BEGIN PRINT substri