if(@@error<>0)
set@errorsave=@@error
return@errorsave
GO
SETQUOTED_IDENTIFIEROFF
GO
SETANSI_NULLSON
GO
SETQUOTED_IDENTIFIERON
GO
SETANSI_NULLSON
GO
createprocedurepinfo5000
asselect*fromprojectwhere项目标的>=5000
orderby项目标的desc
GO
SETQUOTED_IDENTIFIEROFF
GO
SETANSI_NULLSON
GO
SETQUOTED_IDENTIFIERON
GO
SETANSI_NULLSON
GO
createprocedurepro
@n1int,@n2int,@n3int,@avreageintoutput
asselect
@avreage=(@n1+@n2+@n3)/3
declare@avgscoreint
execpro11,2,3,@avgscoreoutput
select'Thescoreis:',@avgscore
GO
SETQUOTED_IDENTIFIEROFF
GO
SETANSI_NULLSON
GO
SQL Server的基础框架知识，我现在只能总结这么多，更多的总结还是在以后一点一滴的学习中。