atzqtzq的博客

原因竟然是它默认的System.Data.SqlClient版本太低。遇到同样问题的解答：https://stackoverflow.com/questions/47974837/enlisting-in-ambient-transactions-is-not-supported-using-transactionscope-in-asp升级Confirmed, I'm using .Net Core 2.2, and installing the latest NuGet package

1.sqlserver使用Row_Nubmer()时乱序问题，但结果几乎却是正确的？SELECT *FROM (SELECT [x].Name AS [MasterID], [x].[MarginAmount] AS [MarginAmount], x.PlatformOrderCount, (SELECT TOP 1 ProvinceName FROM ServiceArea sa WHERE sa.Maste

总结的几种方案1.代码中用for循环拼接sql,类似的用CHARINDEXName like '%福田%' or RegionName like '%南山%2.使用“逗号”切割要查询的字符串后放到临时表,再使用CHARINDEX函数特性create function func_split(@str varchar(2000),@split varchar(2)) returns @table table(col varchar(20)) as .

1.存储过程create proc query_table_struc@tablenames varchar(5000)asdeclare @table varchar(50)declare @endPosition int declare @subString varchar(5000)set @subString=@tablenamescreate table ##tmp( tablename varchar(50))while(len(@subString)>0)