问题描述
如果我们想在插入的记录中Col3包含一个常量字符串'Foo',如何修改下面的存储过程?
How to modify the following stored procedure if we want in the inserted records the Col3 contain a constant string 'Foo'?
INSERT Table2 (Col1, Col2, Col3) SELECT T1Col1, T1Col2 FROM Table1
推荐答案
INSERT Table2 (Col1, Col2, Col3) SELECT T1Col1, T1Col2, 'Something' FROM Table1