Sqlserver
鳖鳖耶夫
这个作者很懒,什么都没留下…
展开
-
事务脚本
USE [test]GOBEGIN tran v_1_0_2_1 --指定版本号declare @tran_error intset @tran_error=0begin tryIF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N’[dbo].[test]’) AND type in (N’U’))DROP TABLE [dbo].[test]SET ANSI_NULLS ONSET QUOTED_IDENT原创 2021-04-28 16:49:49 · 126 阅读 · 0 评论 -
SQLSERVER查询某个外键被引用的表
exec sp_helpconstraint ‘Users’;原创 2020-08-27 13:10:56 · 795 阅读 · 0 评论 -
Sqlserver查询库中包含了某字段的表
select NAME from [库名].[dbo].sysobjects where id in (select id from [库名].[dbo].syscolumns Where name=‘字段名’)原创 2020-06-04 16:27:13 · 1055 阅读 · 0 评论 -
Sqlserver插入自增id
set identity_insert [dbo].[MU_RIGHT] onINSERT INTO [dbo].[MU_RIGHT]([UID],[RightName],[RightDescription],[GroupName])VALUES(621,‘Help_Doc_Delete’,‘Help_Doc_Delete’,‘Option’)GOset identity_insert [dbo].[MU_RIGHT] off原创 2020-05-26 14:47:56 · 1313 阅读 · 0 评论