摘要:
CREATE PROCEDURE MultipleTwoValue @Number1 int,@Number2 int,@Number3 int ASRETURN @Number1 * @Number2 * @Number3======================================... 阅读全文
摘要:
--------------------------------------------------------------------------------SELECT 姓名,--此处显示列名不能使用as性别 = CASE 性别 WHEN 0 THEN '女' ... 阅读全文
摘要:
注意:将游标封装在事务中可以防止操作不完整性======+脏读begin trybegin transactionDECLARE @Name varchar(10), @Sex bit, @Married bit, @Phone char(10), @ChineseSex char(2), @Chi... 阅读全文