ChuckLu - 博客园

2021年6月22日

摘要： 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'

摘要： 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 阅读(1155) 评论(0) 推荐(0)

2021年6月21日

What is the difference between SqlCommand.CommandTimeout and SqlConnection.ConnectionTimeout?

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

posted @ 2021-06-21 18:13 ChuckLu 阅读(114) 评论(0) 推荐(0)

Reference Microsoft.SqlServer.Smo.dll

摘要： 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 阅读(157) 评论(0) 推荐(0)

Execute a large SQL script (with GO commands)

摘要： 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 阅读(140) 评论(0) 推荐(0)

For SameSite cookie with subdomains what are considered the same site?

摘要： 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?

摘要： 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 阅读(275) 评论(0) 推荐(0)

How can I show the table structure in SQL Server query?

摘要： 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)

SQL Server Cursor Explained By Examples

摘要： SQL Server Cursor Explained By Examples Summary: in this tutorial, you will learn how to use the SQL Server cursor to process a result set, one row at 阅读全文

posted @ 2021-06-21 10:37 ChuckLu 阅读(106) 评论(0) 推荐(0)

SQL Server Cursor – When (Not) to use them?

摘要： SQL Server Cursor – When (Not) to use them? I’ll try to give an objective answer to the question – “When you should use SQL Server cursors and when no 阅读全文

posted @ 2021-06-21 10:34 ChuckLu 阅读(93) 评论(0) 推荐(0)

Chuck Lu

公告