随笔分类 - RedGate
摘要:Subquery may return more than one row. A subquery can only be scalar, meaning that it can return just one value. Even if you correctly place just one
阅读全文
摘要:Working with scripts folders A scripts folder is a set of object creation scripts representing a database's schema and (optionally) data. An object cr
阅读全文
摘要:https://forum.red-gate.com/discussion/84930/use-drop-and-create-did-not-work-with-index-on-both-normal-column-and-computed-column https://forum.red-ga
阅读全文
摘要:You can link data that doesn't change very often to SQL Source Control. This lets you commit data changes to source control. To source-control data: 1
阅读全文
摘要:https://documentation.red-gate.com/sdc14 About SQL Data Compare With SQL Data Compare, you can compare and deploy the data in two Microsoft SQL Server
阅读全文
摘要:安装界面,点击左上角的log open log file C:\Users\clu\AppData\Local\Temp\{69EEB6B0-A9AD-4BD4-8231-92C992F1FF05}\RedGate.Logfile.txt use verbose logging 应该是会提供更详细的
阅读全文
摘要:创建表以及主键 判断表是否存在 OBJECT_ID 判断主键是否存在 SELECT 1 FROM sys.indexes WHERE name = N'PK_LISA_NoUseWebpartReplacement' AND object_id = OBJECT_ID(N'[dbo].[LISA_N
阅读全文
摘要:sql search对于新建的数据库或数据表无法智能提示 选择sql prompt菜单,然后子菜单refresh suggestions sql server自带的智能提示刷新 https://stackoverflow.com/questions/7825287/sql-server-how-to
阅读全文
摘要:sql compare project's options https://documentation.red-gate.com/sc/setting-up-the-comparison/setting-project-options Add object existence checks Use
阅读全文
摘要:找到C:\ProgramData\Microsoft\SQL Server Management Studio\11.0\Addins路径,用notepad++打开RedGate.SIPFramework.AddIn。 会发现其中的Assembly节点是空的,手动加上就可以了
阅读全文
摘要:https://documentation.red-gate.com/soc6/common-tasks/exclude-objects-using-filters 如果有人上传了filter,name需要在sql source control的Get Latest的选项卡中pull from re
阅读全文
摘要:https://documentation.red-gate.com/display/SOC5/SQL+Source+Control+5+documentation SELECT DB_NAME(DatabaseID) AS DatabaseName , UserName , * FROM dbo.
阅读全文
摘要:SQL Monitor Installer 安装这个的时候,需要为这个Monitor创建一个Database安装完成之后,需要配置http://documentation.red-gate.com/display/SM7/Configuring+SQL+Monitor+with+IIS+7+and+
阅读全文
摘要:Press TAB to expand wildcard tab键之后,会自动展开,直接枚举表中所有的字段 根据名字查找存储过程,发现找不到 原因是,本地是一个备份库。服务器上通过sql source control进行版本控制的。 在通过sql source control将服务器上新增的存储过程
阅读全文