摘要:
1存储过程1.1存储的格式 create proc name as begin 语句 end1.2执行存储 exec name1.3无参数 --创建存储过程if (exists (select * from sys.objects where name = 'sstudent')) drop pro 阅读全文
摘要:
1 连接查询:通过连接运算符可以实现多个表查询。1.1 join onselect name,mark from student join mark on student.id=mark.studentid左连接-left joinselect name,mark from student left 阅读全文