SQL Server

1 --Take the record of article M to nth from table tables: (not in version)2 Select TOPN-M+1 * 3 from Table 4 Where(ID not inch(Select TOPM-1Id from Table )) 5 6 7 --Remove the M-to-N records from table tables (exists version)8 Select TOPN-M+1 *

Data type Character type varchar (8000): Supports up to 8,000 charactersnvarchar (4000): Supports up to 4,000 characters Integral type Floating point Type Operators, functionsISNULL (value,0);  --if NULL, the

/*    material Equipment Table: Id code name etc     inventory Inventory table:id  MATERIAL_IDMATERIAL_CODE1, inventory list associated equipment table, only associated with Material_code, no associated material_id (NULL)     2, now according to

The statement under this script is not I write, forget where to see from, here to share to everyone, because in my understanding technology is used to share, I hope the original author see not mind.1. Create a text to change the suffix name to. bat2.

Sometimes it may be necessary to detect whether a machine's service is up, or if a certain library of a machine can be connected and not open to ssms or log on to the server.1. Right-click on the desktop to create a text, and then change the suffix

The last time you learned to add a field to a table in a database, let's continue to learn--Modify a column field in a database tableUse databaseALTER TABLE name ALTER COLUMN type--How to delete a column field in a databaseUse databaseALTER TABLE

Management LocalDB1. Sqllocaldb commandAfter the installation, you can look at the environment variables in the path, there will generally be%programfiles%\microsoft SQL Server\110\tools\binn This is the location of SQLLOCALDB storage, if the CMD

A. Shrinking a data file to a specified target sizeThe following example shrinks the size of a data file named DataFile1 in the UserDB user database to 7 MB. CopyUse UserDB; GODBCC Shrinkfile (DataFile1, 7); GOB. Shrinking a log file to a specified

--cte[common table expressions are actually provided in SQL Server] to implement recursion: Declare @Id Int Set @Id = 24; ---Modify the parent node here With rootnodecte (Id,parentid) as ( select  id,parentid from dept where  

SQL Server sorting in the tree structure departmentBecause you want to implement the departmental sorting function, and to consider the departmental hierarchy, it is not possible to sort directly with SQL, so write a SQL function to support it.First

--Check the index fragmentation situationDBCC SHOWCONFIG (tablename)Specific examples:--Before the defragmentationALTER INDEX all on citation REBUILD-After the defragmentation--Extents Switches:extents Scanned-1-AVG. Pages per Extent: Default 1 Zone

This is mostly the previous installation of MSSQL, not uninstalled clean caused.Here's how to fix it:First, the MSSQL unloaded clean1. Uninstall SQL Server from the Add-remove program;2. Delete the entire Microsoft SQL Server folder;3. Run the

How to export data as XML and Json in SQL Server Sometimes it is necessary to export data from SQL Server to other departments at a time for association or analysis. This requirement is of course very simple for SSIS, however, in many cases, you

SQL Server uses SQL statements to merge duplicate row data into one row and separate them with commas (,). 1. Define table Variables The Code is as follows: DECLARE @ T1 table ( UserID int, UserName nvarchar (50 ), CityName nvarchar (50) );   Insert

SQL Server database Stored Procedures What is stored procedure If you have been familiar with other programming languages, you can understand that the stored procedure is like a method. Even if he is a method, then he has a similar method name, the

Three ways to operate databases Database operations can be divided into three types: first, writing hard SQL code directly without parameters, second, writing hard Code directly, parameters, and third, calling the stored procedure. Take a logon

SQL Server extended storage process for remote backup and recovery Instance description: Environment: win2k + sqlserver 2 K + query Analyzer SQL SERVER service instance name: mainserver Name of the database to be backed up: msdb Local Machine name

SQL Sever uses SQL statements to merge duplicate row data into one row and separate them with commas (,). 1. Define table VariablesCopy codeThe Code is as follows:DECLARE @ T1 table(UserID int,UserName nvarchar (50 ),CityName nvarchar (50)); Insert

Use Performance Monitor to monitor common metrics of SqlServer in Windows, and monitor sqlserver As mentioned in the above article, win's Performance Monitor is an essential tool for monitoring database performance. Next I will introduce some common

SQL Server DBCC command details, serverdbcc Today, the R & D center will hold an annual meeting. In the evening, my departments will have dinner. I personally like to drink dry red. You can enjoy the cool and bitter taste in the dry red... Why isn't