随笔分类 -  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 阅读全文
posted @ 2020-05-25 14:04 ChuckLu 阅读(625) 评论(0) 推荐(0) 编辑
摘要: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 阅读全文
posted @ 2020-04-21 13:50 ChuckLu 阅读(261) 评论(0) 推荐(0) 编辑
摘要: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 阅读全文
posted @ 2020-01-21 12:21 ChuckLu 阅读(150) 评论(0) 推荐(0) 编辑
摘要: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 阅读全文
posted @ 2019-09-10 16:01 ChuckLu 阅读(222) 评论(0) 推荐(0) 编辑
摘要: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 阅读全文
posted @ 2019-09-10 15:29 ChuckLu 阅读(1035) 评论(0) 推荐(0) 编辑
摘要:安装界面,点击左上角的log open log file C:\Users\clu\AppData\Local\Temp\{69EEB6B0-A9AD-4BD4-8231-92C992F1FF05}\RedGate.Logfile.txt use verbose logging 应该是会提供更详细的 阅读全文
posted @ 2019-05-08 10:03 ChuckLu 阅读(268) 评论(0) 推荐(0) 编辑
摘要:创建表以及主键 判断表是否存在 OBJECT_ID 判断主键是否存在 SELECT 1 FROM sys.indexes WHERE name = N'PK_LISA_NoUseWebpartReplacement' AND object_id = OBJECT_ID(N'[dbo].[LISA_N 阅读全文
posted @ 2018-11-14 10:59 ChuckLu 阅读(787) 评论(0) 推荐(0) 编辑
摘要:sql search对于新建的数据库或数据表无法智能提示 选择sql prompt菜单,然后子菜单refresh suggestions sql server自带的智能提示刷新 https://stackoverflow.com/questions/7825287/sql-server-how-to 阅读全文
posted @ 2018-09-05 10:27 ChuckLu 阅读(609) 评论(0) 推荐(0) 编辑
摘要:sql compare project's options https://documentation.red-gate.com/sc/setting-up-the-comparison/setting-project-options Add object existence checks Use 阅读全文
posted @ 2018-06-29 14:40 ChuckLu 阅读(355) 评论(0) 推荐(0) 编辑
摘要:找到C:\ProgramData\Microsoft\SQL Server Management Studio\11.0\Addins路径,用notepad++打开RedGate.SIPFramework.AddIn。 会发现其中的Assembly节点是空的,手动加上就可以了 阅读全文
posted @ 2018-01-10 16:50 ChuckLu 阅读(486) 评论(0) 推荐(0) 编辑
摘要:https://documentation.red-gate.com/soc6/common-tasks/exclude-objects-using-filters 如果有人上传了filter,name需要在sql source control的Get Latest的选项卡中pull from re 阅读全文
posted @ 2017-12-18 12:17 ChuckLu 阅读(247) 评论(0) 推荐(0) 编辑
摘要:https://documentation.red-gate.com/display/SOC5/SQL+Source+Control+5+documentation SELECT DB_NAME(DatabaseID) AS DatabaseName , UserName , * FROM dbo. 阅读全文
posted @ 2017-08-02 14:10 ChuckLu 阅读(565) 评论(0) 推荐(0) 编辑
摘要:SQL Monitor Installer 安装这个的时候,需要为这个Monitor创建一个Database安装完成之后,需要配置http://documentation.red-gate.com/display/SM7/Configuring+SQL+Monitor+with+IIS+7+and+ 阅读全文
posted @ 2017-07-14 14:36 ChuckLu 阅读(679) 评论(0) 推荐(0) 编辑
摘要:Press TAB to expand wildcard tab键之后,会自动展开,直接枚举表中所有的字段 根据名字查找存储过程,发现找不到 原因是,本地是一个备份库。服务器上通过sql source control进行版本控制的。 在通过sql source control将服务器上新增的存储过程 阅读全文
posted @ 2017-06-29 10:21 ChuckLu 阅读(2317) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示