The driver cannot establish a secure connection with SQL Server by using secure sockets layer (SSL) encryption. Error: "no approve protocol (protocol is disabled or cipher"

This article solves the following exception information, hoping to be helpful to your programming! Abnormal information The driver cannot establish a secure connection with SQL Server by using secure sockets layer (SSL) encryption. Error: "no appropriate protocol (protocol is disabled or cipher suits are inappropriate)"“ Oper ...

Posted by feidakila on Sun, 05 Dec 2021 16:15:32 -0800

round function in SQL Server

round function in SQL Server 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 ---SQL Rounding question 1: SELECT CAST('123.456' as decimal) ---123 You will get 123 (the after the decimal ...

Posted by Permutant on Tue, 30 Nov 2021 06:02:01 -0800

Basic use of EF Core in ASP.NET Core (CodeFrist) 1

1, Construction project In our daily projects, we usually have a multi-layer architecture. The domain layer (entity) is generally not placed together with the application layer (business: such as api and mvc). We only do this when doing exercises. Then I will directly share the most practical and layer according to the most basic project objec ...

Posted by ssj4gogita4 on Tue, 16 Nov 2021 06:39:30 -0800

. net operation Dameng database

1, Introduction I happened to see the domestic database - Dameng database. Suddenly became interested and made a fuss. The following introduction is taken from Baidu Encyclopedia Dameng database is a high-performance database product with completely independent intellectual property rights launched by Wuhan Huagong Dameng database Co., Ltd. ...

Posted by flamtech on Wed, 10 Nov 2021 08:02:07 -0800

SQL server stored procedure learning record

https://www.cnblogs.com/c-supreme/p/9482321.html In short, a stored procedure is a collection of one or more sql statements, which can be regarded as a batch file, but its function is not limited to batch processing. 1, Overview of stored procedures Stored procedures in SQL server use t_ Code snippet written in SQL. Its purpose is to easily ...

Posted by twsowerby on Tue, 28 Sep 2021 04:03:54 -0700

Telegraf and Grafana monitor SQL Server on multiple platforms

problem SQL Server is deployed on multiple platforms (Windows,Linux and Container) in many enterprises. A solution that can support multiple platforms is needed to collect and display related monitoring indicators. I choose the popular monitoring display tool Grafana and monitoring indicator collection tool Telegraf to implement. This is also t ...

Posted by hermand on Mon, 01 Jun 2020 03:48:16 -0700

SQL Server Database Foundation (the most commonly used database and table building, 54 classic cases and syntax formats)

Building database and table: if DB_id('TicketManager ')is not null --Judge whether the database already exists drop database TicketManager --Remove the existing database go create database TicketManager --New database on ( name='TicketManager ',--Database name filename='E:\CS Review cases of Architecture\TicketManager\DB\TicketManager. ...

Posted by waltonia on Mon, 04 May 2020 04:11:09 -0700

Design Mode-Observer Mode

Storytelling Assuming that we are a coupon offering platform, the story happens after the customer has successfully paid for the purchase of our platform. Some actions to be done by the platform after the payment is completed: SMS informs customer that an order has been generated Increase customer credit Start vouching on order ....(The ...

Posted by bachx on Wed, 22 Apr 2020 20:49:04 -0700

SQL Server table partition

1. introduction When there is a large amount of data in a table, it is natural for us to think of splitting the table into many small tables. When we execute the query, we go to each small table to query. Finally, we summarize the data set and return it to the caller to speed up the query. For example, the order table and inventory table of e-c ...

Posted by miro on Tue, 07 Apr 2020 22:29:17 -0700

SQL Server solution -- a summary of the uniqueness of object naming

About the uniqueness of object naming in SQL Server database. For example, database objects such as tables, indexes, constraints, etc. sometimes, DBA s often need to create or rename objects when doing database maintenance. At this time, they will encounter a problem, the uniqueness of object naming. Although it's a small question, it's not cle ...

Posted by EverToDesign on Thu, 20 Feb 2020 21:10:20 -0800