![](https://img-blog.csdnimg.cn/20201014180756780.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
DataBase/SQL
ImYourMan
这个作者很懒,什么都没留下…
展开
-
SQL database common object type
OBJECT_ID ( '[ database_name . [ schema_name ] . | schema_name . ] object_name' [ ,'object_type' ] ) Object type: AF = Aggregate function (CLR) C = CHECK constraint D = DEFAULT (constraint or st原创 2015-10-05 23:28:24 · 362 阅读 · 0 评论 -
sp_who
sp_who(Transact-SQL) Provides information about current users,sessions, and processes in an instance of the Microsoft SQL Server Database Engine. The information can be filtered to return only those原创 2015-11-26 16:05:30 · 1083 阅读 · 0 评论 -
SET NOCOUNT { ON | OFF }
SET NOCOUNT { ON | OFF }原创 2016-01-04 11:12:47 · 255 阅读 · 0 评论 -
object_id
IF OBJECT_ID(N'[dbo].[V_XXXX]', N'V') IS NOT NULL BEGIN DROP VIEW [dbo].[V_XXXX] END原创 2016-03-09 11:50:53 · 300 阅读 · 0 评论 -
查看DATABASE INFO
查看Database里面的table SELECT * FROM sys.tables 查看table里面的列 select object_id('SourceTable'),* from syscolumns where id = object_id('SourceTable');原创 2016-04-26 11:40:29 · 613 阅读 · 0 评论