SQL SERVER 必须要掌握的内容

SQL Server查询所有用户表

?

1	select name from sysobjects where xtype='u' order by name

SQL Server查询所有用户视图

?

1	select name from sysobjects where xtype='v' order by name

 

select * from sys.objects 

sql server存储过程简单使用

https://www.cnblogs.com/xifengmo/p/10976591.html

 

exec usp_book 'CS000001', 2

declare @CareerID nvarchar(50)
declare @CareerTypeID int
exec usp_book @CareerID='CS000001', @CareerTypeID=2

 

SQL Server基础之存储过程

https://www.cnblogs.com/selene/p/4483612.html#_labelTop