1. Export 1.1 Use SSMS tool to export database files as SQL scripts Please refer to this website for details: Export SQLserver database tables and data_sqlserver export table data_fyhs’ blog-CSDN blog 1.2 Use SSMS tool to export a single table to an Excel file (1) Right-click the database (2) Select Task->Export Data (3) Select data […]
Tag: sqlserver
ETL toolDatax-ETL-SqlServerToHDFS
Personal homepage–Personal homepage ? ? Thanks for the likes and attention, we will make a little progress every day! come on! ? Table of Contents Personal homepage–Personal homepage ? 1. Overview of DataX 1.1 Introduction to DataX 1.2 DataX framework 1.3 Functional limitations 1.4 Support Data Channels 2. Configuration example 2.1 Environmental information 2.2 SQLServer […]
Dynamic statement sqlserver
EXEC sp_executesql @DynamicSQL, N’@FirstName NVARCHAR(50), @LastName NVARCHAR(50)’, @FirstName, @LastName In the EXEC sp_executesql statement, the subsequent parameters need to be passed in a specific order. The order of these parameters is as follows: 1. The first parameter is the dynamic SQL statement itself, usually a variable of type NVARCHAR (MAX), containing the SQL query to […]
Optimization of VBA material information query (involving referencing other tables, filtering, copying, assignment, format adjustment, progress bar, and connecting to SQLSERVER)
The material query function developed some time ago has been optimized according to the requirements of the using department. 1. When selecting a machine tool number, a window will pop up and you can choose whether to view all materials or materials that have not yet arrived. 2. Add several columns of data to the […]
sqlserver experimental questions (updated regularly, currently homework 4)
Assignment 4 Creation and Management of Relationship Tables 1. Use SSMS in SQL Server to create the LIBRARY database, and create the “Book” table and “Publishing House” table in this database. book table (1) Set the primary key: book title (Primary key constraint: Duplicate elements are not allowed to avoid data redundancy and unique identification) […]
SQLSERVER The most comprehensive time & date processing conversion statement
Current time Grammar description getdate is a function term. The GETDATE() function returns the current time and date from SQL Server. SELECT getdate() SELECT CONVERT(CHAR(10),getdate(),23) SELECT CONVERT(CHAR(10),getdate(),112) Select CONVERT(varchar(100), GETDATE(), 8) Select CONVERT(varchar(100), GETDATE(), 24) Select CONVERT(varchar(100), GETDATE(), 114) Collection of commonly used codes — The first day of the month SELECT dateadd(mm,datediff(mm,0,getdate()-1),0) SELECT CONVERT(CHAR(10),DATEADD(mm,DATEDIFF(mm,0,getdate()-1),0),23) […]
Oracle/MySQL/PostgreSQL/SqlServer string date conversion
Oracle In Oracle Database, you can use the TO_DATE function to convert a string to a date and the TO_CHAR function to convert a date to a string. Convert string to date: SELECT TO_DATE(‘2023-07-19’, ‘YYYY-MM-DD’) AS converted_date FROM dual; This will convert the string 2023-07-19’ to a date type and return the result. Convert date […]
QT connects to SQLServer database
1. After installing the SQLServer database In SQL Server Configuration Manager After setting, you need to restart the SQL Server service 2. Key points* Configure ODBC data source Unable to connect because ODBC is not configured Start – ODBC Data Source Manager (64-bit) Afterwards select: SQL Server Authentication using user input login ID and password […]
SQLServer queries all database names, table names, table structures, etc.
1. Query all database names SELECT name FROM sysdatabases 2. Query all table names in the current database without specifying a database. Just select a database and execute SQL directly. — ‘U’: all user table names; ‘S’: all system table names; ‘V’: all view table names SELECT name FROM sysobjects WHERE xtype=’U’ OR xtype=’S’ OR […]
Weak password scanning tools: ssh, postgresql, Redis, MySQL, mongoDB, FTP, sqlserver (mssql), Dahua (Dahua), hikvision (Hikvision); 9 weak password detection sets
Weak password vulnerability Weak password tools Username-password set 1. SSH weak password 2. postgresql weak password 3. redis weak password 4. MySQL weak password 5. Mongodb weak password 6. Weak FTP password 7. sqlserver (mssql) weak password 8. dahua weak password 9. hikvision (Hikvision) weak password Tool source code address Weak password tools This tool […]