工作需要筆記

SELECT 1/0

哇哈哈，Got you !!! 世宇教的！

DECLARE @_i INT
DECLARE @_MAX INT
 SET @_i = 0
 SET @_MAX = 10 -- 要產生幾筆資料
 WHILE (@_i<@_MAX)
 BEGIN
        --要迴圈的語法
        INSERT INTO #TT VALUES('T')     
        
        --加1
        Set @_i=@_i+1
 END

http://www.codedata.com.tw/database/mysql-tutorial-basic-query

-- Case 2 Primary Key Non-clustered Index
USE TempDB
GO
-- Create table
CREATE TABLE TestTable
(ID INT NOT NULL PRIMARY KEY NONCLUSTERED,
Col1 INT NOT NULL)
GO
-- Check Indexes
SELECT OBJECT_NAME(OBJECT_ID) TableObject,
[name] IndexName,
[Type_Desc]
FROM sys.indexes
WHERE OBJECT_NAME(OBJECT_ID) = 'TestTable'
GO
-- Clean up
DROP TABLE TestTable
GO

http://alexchuo.blogspot.tw/2010/09/sql-server-2008-expess-sql-server-agent.html