个人SQL总结

1:MSSQL内外连接(INNER JOIN)语句详解

   http://www.jb51.net/article/4848.htm

2:精妙SQL语句

   http://blog.csdn.net/zhuyutong186/archive/2009/09/22/4576231.aspx

3:过渡到SSAS之一

   http://blog.csdn.net/jinjazz/archive/2009/04/07/4053719.aspx

4:使用游标

   DECLARE @GroupName  [VARCHAR] (50) 

   DECLARE @DataCSR             CURSOR   
   SET @GroupName = 'Pooling Group'

    
  /*Mask Group Name*/
  SET @DataCSR = CURSOR FOR    SELECT PoolingGroupCode, Status FROM MASTER_GROUP_TBL  
  
  OPEN @DataCSR
  FETCH NEXT FROM @DataCSR INTO @PoolingGroupCode,@RecordStatus
  WHILE @@FETCH_STATUS = 0
    BEGIN
      UPDATE MASTER_GROUP_TBL SET XXXGroupName = @GroupName + '-' + CAST(@iNumber AS VARCHAR(5))
      WHERE XXXGroupCode = @XXXGroupCode AND Status = @RecordStatus      
        FETCH NEXT FROM @DataCSR INTO @XXXGroupCode,@RecordStatus
    END
  /*关闭游标*/
  CLOSE @DataCSR

  /*删除游标*/
  DEALLOCATE @DataCSR

5:一个项目涉及到的50个Sql语句

http://topic.csdn.net/u/20100517/17/b2ab9d5e-73a2-4f54-a7ec-40a5eabd8621.html

6: