-
Summary of commonly used functions and time processing in SqlServer
YEAR() The function returns an integer value that represents the year of the specified date, typically used as Year, such as:YEAR('2023-03-1416:50:08.543')--2023REPLACE() The string replacement function is generally used as: Replace (the searched string, the string to be replaced, and the replacement value), such as:REPLACE ('Test Added ',' of ',' Test Data ') -- Test Added Test DataSTUFF() The function is used to delete a specified length of character and insert another set of characters at the specified starting point...
Database Operation Tutorial 2023-05-12 12:13:30 -
Summary of several methods for removing duplicate data in SQL (window function for data deduplication)
catalogueMethod 1: distinctMethod 2: groupbyMethod 3: Window functionWhen using SQL to extract and analyze data, we often encounter scenarios where data is duplicated, requiring us to perform data deduplication and subsequent analysis.Taking the sales report of a certain e-commerce company as an example, we commonly use distinct or group by statements to deduplicate data...
Database Operation Tutorial 2023-05-12 12:13:26 -
Solution to Short Term Forced Expiration of SQL Server Database Passwords
1. Open Sqlserver, select the account under the login name, right-click, and click Properties2...
Database Operation Tutorial 2023-05-12 12:13:01 -
How to use Pycharm to connect to SQL Server (detailed tutorial)
SQL Sever1433 pycharmpycharmSQL SeverTipSQL Sever: ------------------------------ LAPTOP-40O6HVDS ------------------------------ : (provider: Shared Memory Provider, error: 0 - ) (Microsoft SQL Server: 233) SQL Sever SQL Sever Window create database soft2104soft2104soft2104pycharmuse master --drop database soft2104 -- yunmengzepycharmSQL Sever 123456123456pycharm db_ower SQL Sever SQL Sever: ------------------------------ LAPTOP-40O6HVDS ------------------------------ : (provider: Shared Memory Provider, error: 0 - ) (Microsoft SQL Server: 233) 1433 1433 1433winRcmdtelnet localhost 1433'telnet' winRcontrol Windows Telnet1winRcmdtelnet localhost 1433localhost....
Database Operation Tutorial 2023-05-12 12:12:22 -
SQL Server Detailed steps for changing the default backup directory for databases
This article also applies to the latest version of SQL server 2008, 2016, 2019Open SSMSSelect Database, right-click, PropertiesSelect&quo; Permissions”, Click on&quo; View Server Permissions&# quo;Select&quo; Database Settings;, Modify&quo; Backup; Box PathNote: After changing the backup path of a database, it is valid for all databases. Please note that the final prompt indicates whether to save...
Database Operation Tutorial 2023-05-12 12:12:17 -
SQL Server database judgment of the latest backup execution results (latest recommended)
1 2 errorlogtrace3 backupset4 SQL1 SQL Servermsdb.dbo...
Database Operation Tutorial 2023-05-12 12:12:02 -
SQL Server judges whether there is summary for database, table, column, view, stored procedure and function
catalogue1 Introduction Overview2 Database related judgments2.1...
Database Operation Tutorial 2023-05-12 12:11:57 -
Detailed Solution to SQL Server Installation Failure in Win11
catalogueDelete SQLServer related registryterms of settlement:summaryWin+R opens and runs the input services.msc to view all services and stop all services related to SqlServer, as follows:Open the control panel - uninstall all related software of SQL server;Delete SQLServer related registry1...
Database Operation Tutorial 2023-05-12 12:11:49 -
Idea Connect SQL Sever2019 Tutorial (Super Detailed)
catalogue1. First, let's open sqlsevers2...
Database Operation Tutorial 2023-05-12 12:11:42 -
SQL Server 2022 Installation Tutorial (latest recommended)
catalogue1 Configuring and installing SQL Server(1) Download link on official website2 Install visualization tool SSMS3 Common installation errorsSQL Server is a relational typeDatabase Management System(RDBMS), composed ofMicrosoftCompany development and maintenance. It supports Structured Query Language (SQL) and Transact SQL (T-SQL), and is a scalable database platform used to process large amounts of data and support high-performance data access, with a wide range of applications...
Database Operation Tutorial 2023-05-12 12:11:34 -
Detailed explanation of SQL Server's memory management architecture
WindowsSQL Server 2.12...
Database Operation Tutorial 2023-05-12 12:11:27 -
SQL Detailed explanation of server's row level security
catalogue1 Preface2 Description3 Permissions4 Security note: Side channel attack5 Cross functional compatibility6 Example1 PrefaceRow level security allows you to control access to rows in database tables using group membership or execution context.Row level security (RLS) simplifies security design and coding in applications...
Database Operation Tutorial 2023-05-12 12:11:21
