為stu表創建觸發器，添加的資料主鍵要有前綴97_，不然就不可以添加資料
該怎么寫，謝謝大佬
uj5u.com熱心網友回復：
你是指你現有資料，要添加prefix 97_？還是說 你想加個check contraint?
ALTER TABLE tempdb.dbo.#MyTempTable
ADD CONSTRAINT CHK_Column2 CHECK (Column2 LIKE '97_%');
GO
/*
INSERT INTO tempdb.dbo.#MyTempTable
VALUES (1, '', N'97_Success')
INSERT INTO tempdb.dbo.#MyTempTable
VALUES (2, '', N'Fail')
*/
Success
(1 row affected)
Fail
Msg 547, Level 16, State 0, Line 36
The INSERT statement conflicted with the CHECK constraint "CHK_Column2". The conflict occurred in database "tempdb", table "dbo.#MyTempTable________________________________________________________________________________________________________00000000001A", column 'Column2'.
The statement has been terminated.
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/154971.html
標籤：疑難問題
上一篇：就大佬解答一下.我小白一個