摘要：SELECT * FROM ( SELECT 1 AS ID , 'C#' AS Name union SELECT 2 AS ID , 'Java' AS Name union SELECT 3 AS ID , 'JavaScript' AS Name ) TEMP for json auto,r 阅读全文

摘要：当前两天使用数据库关系图设计表关系时还是好好的，周一一打开添加表就出现索引异常的错误，尝试过删除今天新增的外键 然后重启服务器的MSSqlServer 服务还不行，网上大多数的说法也是说更新MSSqlServer management Studio 我的解决方案还是想使用重启，重新远程的服务器，找到 阅读全文

摘要：CREATE TABLE [dbo].[T_GoodsType]( [ID] [int] IDENTITY(1,1) NOT NULL, [ParentID] [int] NOT NULL, [LevelNum] [int] NOT NULL, [Name] [nvarchar](50) NOT N 阅读全文

摘要：SELECT A.ID,'['+STRING_AGG( JSON_MODIFY(T_ShopCart_Append3.value,'$.MerchantsID',CAST(JSON_VALUE(T_ShopCart_Append3.value,'$.MerchantsID') as bigint)+ 阅读全文

摘要：append3 字段的sql格式如下[{"ID":1,"Name":"身高、体重、血压","MerchantsID":681,"MarketPrice":null,"CashPrice":null,"SettlePrice":null,"NormalPrice":null},{"ID":35,"Na 阅读全文