[MSSQL] 使用 SQL 產生亂數字串

select cast((Abs(Checksum(NewId()))%10) as varchar(1)) +
       char(ascii('a')+(Abs(Checksum(NewId()))%25)) +
       char(ascii('A')+(Abs(Checksum(NewId()))%25)) +
       left(newid(),5)
from table

參考來源
http://stackoverflow.com/questions/15038311/sql-password-generator-8-characters-upper-and-lower-and-include-a-number

將 CSV 透過 SQL 語法匯入 MSSQL

SELECT * FROM OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Text;Database=C:\;','SELECT * FROM [import.csv]')

[網站介紹] MSSQL 討論與教學

http://blog.sqlauthority.com/

MSSQL Table 中更改 seed 值

DBCC CHECKIDENT (yourtable, reseed, 要設定的編號)

ex.
DBCC CHECKIDENT (yourtable, reseed,  10)

MSSQL Union 與 Union All 的不同

Union

將兩個 SQL 執行結果合併, 並將重複值移除

範例
select * from table1
union
select * from table2


Union All

將兩個 SQL 執行結果合併, 但保留所有重複值
範例
select * from table1
union all
select * from table2

使用條件: 所有欄位值需相同

MSSQL 判斷是否含有非數字

select * from table where ISNUMERIC(col) = 0