Determine identity column (判斷識別規格欄位)

IF ((SELECT OBJECTPROPERTY( OBJECT_ID(N'table_name_here'), 'TableHasIdentity')) = 1)
    PRINT 'Yes'
ELSE
    PRINT 'No'

sql server - How do you determine what SQL Tables have an identity column programatically - Stack Overflow

HashBytes (MD5、SHA1)

Right(UPPER(sys.fn_VarBinToHexStr(HashBytes('md5', '123password456'))),32);
好用的 MS SQL 2005 欄位字串加密應用 ( MD5 與 SHA1 ) - IT X 4- 點部落