摘要：
How .NET Standard work A little journey under the hood of .NET Standard implementation If you deal with Microsoft technologies you’ve probably heard a 阅读全文
posted @ 2021-06-24 18:21
ChuckLu
阅读(121)
评论(0)
推荐(0)
摘要：
Deleting 1 millions rows in SQL Server I am working on a client's database and there is about 1 million rows that need to be deleted due to a bug in t 阅读全文
posted @ 2021-06-23 10:08
ChuckLu
阅读(82)
评论(0)
推荐(0)
摘要：
Get size of all tables in database 回答1 SELECT t.NAME AS TableName, s.Name AS SchemaName, p.rows, SUM(a.total_pages) * 8 AS TotalSpaceKB, CAST(ROUND((( 阅读全文
posted @ 2021-06-22 18:12
ChuckLu
阅读(71)
评论(0)
推荐(0)
摘要：
Unable to load DLL 'Microsoft.Data.SqlClient.SNI.x64.dll' Take a look at the following two references: Unable to load native SNI (Server Name Indicati 阅读全文
posted @ 2021-06-22 11:02
ChuckLu
阅读(1157)
评论(0)
推荐(0)
摘要：
What is the difference between SqlCommand.CommandTimeout and SqlConnection.ConnectionTimeout? Is there any difference between SqlCommand.CommandTimeou 阅读全文
posted @ 2021-06-21 18:13
ChuckLu
阅读(115)
评论(0)
推荐(0)
摘要：
Reference Microsoft.SqlServer.Smo.dll I need to use Server class which is stored in Microsoft.SqlServer.Smo.dll I don't see this assembly in usual Ref 阅读全文
posted @ 2021-06-21 16:11
ChuckLu
阅读(158)
评论(0)
推荐(0)
摘要：
Execute a large SQL script (with GO commands) I need to execute a large set of SQL statements (creating a bunch of tables, views and stored procedures 阅读全文
posted @ 2021-06-21 13:58
ChuckLu
阅读(141)
评论(0)
推荐(0)
摘要：
For SameSite cookie with subdomains what are considered the same site? For the samesite cookie attribute I'm not clear on if I set a cookie with domai 阅读全文
posted @ 2021-06-21 13:33
ChuckLu
阅读(94)
评论(0)
推荐(0)
摘要：
How to handle multiple cookies with the same name? Say for example I had an application sending the following HTTP headers to set to cookie named "a": 阅读全文
posted @ 2021-06-21 13:18
ChuckLu
阅读(278)
评论(0)
推荐(0)
摘要：
How can I show the table structure in SQL Server query? 回答1 For SQL Server, if using a newer version, you can use select * from INFORMATION_SCHEMA.COL 阅读全文
posted @ 2021-06-21 10:53
ChuckLu
阅读(90)
评论(0)
推荐(0)
浙公网安备 33010602011771号