參數說明
maxlength：字串的最大長度
UPDATE TABLE
SET <column> = REPLICATE( '<string>' , maxlength - LEN(<column>)) + <column>
maxlength：字串的最大長度
UPDATE TABLE
SET <column> = REPLICATE( '<string>' , maxlength - LEN(<column>)) + <column>
- 3月 29 週四 201221:43
【T-SQL】位數不足補某數
- 3月 29 週四 201216:32
【T-SQL】查詢SQL語句的執行時間
SET STATISTICS TIME { ON | OFF }
SET STATISTICS TIME ON
<SQL>
SET STATISTICS TIME OFF
1
Visual Studio (2)