Chuck Lu

摘要： How to print GETDATE() in SQL Server with milliseconds in time? I want to print GETDATE() in SQL Server 2008, I need the time with milliseconds (this 阅读全文

摘要： LogInformation(string source, string eventCode, string eventDescription = "") // CMS.EventLog.EventLogProvider /// <summary> /// Writes a new informat 阅读全文

摘要： Cookie Category Cookie category definition (noun) A cookie category is a set of cookies defined by their function. Cookie categories may include perfo 阅读全文

摘要： cannot apply the specified columns kentico Pagination in union query of two page type The error has 2 specific messages in it: [SqlHelper.ReplaceColum 阅读全文

摘要： System.NotSupportedException: [DataTypeManager.GetFieldType]: SQL type 'datetimeoffset' is not registered, register the type with method RegisterDataT 阅读全文

摘要： 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 阅读全文

摘要： 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 阅读全文

摘要： 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((( 阅读全文

摘要： 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 阅读全文

摘要： What is the difference between SqlCommand.CommandTimeout and SqlConnection.ConnectionTimeout? Is there any difference between SqlCommand.CommandTimeou 阅读全文