SQL Server

SQL is short for structured querylanguage (Structured Query Language). It is a type of database query andProgramA design language used to access data and query, update, and manage relational database systems. It is also the extension of the database

Function: Create Function fn_formatnumber (@ value numeric (18, 4 ))Returns varchar (30)AsBeginDeclare @ t varchar (30)Set @ T = cast (@ value as varchar (30 ))While right (@ T, 1) = '0'Set @ T = left (@ T, Len (@ t)-1) Declare @ I intSet @ I =

In general, you can access SQL Server metadata through a system stored procedure or information_schema view. When a query window is used, the system stored procedures are perfect and optimized for a database administrator, but not all of them apply

 After SQL Server is installed on the server, all unused ports need to be blocked and only necessary ports must be opened for the sake of server security. The following describes the ports used in SQL Server 2008: First, port 1433 is the most

SQL Server connection books SQL ServerTimestampThe data type is independent of the time and date. SQL ServerTimestampIt is a binary number that indicates the relative sequence of data modifications in the database. ImplementationTimestampThe data

CreateCatalog Now you need to create a full-text catalog. This directory seems to be a container that indexes all the full text. Therefore, if you want to search for the text of the three required tables, you need to generate three indexes (one

There is a need in the past two days to determine the string format in the database, so I collected some information from the Internet and sorted it out. The following is a user-defined function. You can call this function to determine whether the

This article does not introduce how ADO connects to the database, but describes the connection steps and simple methods.1. Obtain the connection string. The _ connectionptr object open method is required for database connection. The parameters are

  2010-08-05 09:21:51. 31 spid11 error: 823, severity: 24, status: 22010-08-05 09:21:51. 31 spid11 I/O error (torn page) detected during read at offset 0x00000000496a000 in file 'd:/Microsoft SQL Server/MSSQL/data/xxxxx_data.mdf '. ==================

Pad_index Specifies the space to leave open onEach page (node) in the intermediate levels of the index. The pad_indexOption is useful only when fillfactor is specified, because pad_indexUses the percentage specified by fillfactor. By default, SQL

---------------------------------------------------------------------------- ---- This is andkylee's personal originality. Please repost it with respect to the author's Labor achievements; ---- The original source must be specified for reprinting. :

Microsoft SQL Server internal technical data exposure Build a dream team from the SQL server development team and Support Department SQL Server troubleshooting Bible   "The contents of this book are none of other blogs, websites, or books. When the

I. Definition and features of an ID column The ID column in SQL Server, also known as the identifier column, is also called an auto-incrementing column.This type of column has the following three features: 1. The column data type is Numeric without

Syntax:Create [index type] Index nameOn Table Name (column name)With fillfactor = fill factor value 0 ~ 100Go /* Instance */Use Database NameGoIf exists (select * From sysindexes where name = 'ix _ test_tname ') -- check whether the ix_test_tname

SQL Server does not have a hierarchical search method that is as convenient as in Oracle. I tried to use a stored procedure to implement this function. The stored procedure was previously changed by someone else who wrote something similar.   Create

When the middlegen tool is configured today, the configuration is always bad. The error message is: the database is connected, but the data table cannot be found. Then I checked it online and found the correct way. As follows: % Middlegen

Storage, we immediately remember the warehouse of various items that we encountered around us, that is, how the Stored Procedure stores items in the warehouse. This is a stored procedure in our life. However, in a database, a stored procedure is an

Backing up and recovering databases is an important task for database administrators to ensure data security. SQL Server 2008 provides high-performance backup and recovery functions, allowing you to perform database backup and recovery in multiple

In the database, tables are very important. Most of the data is stored in tables. Operations on tables directly affect the data in the database! Below is my summary in this chapter! Summary of this chapter! You can directly operate a table, or

A view is a common database object that stores query results in a virtual table. The view has many advantages: 1. It can simplify operations, 2. It can set up front-end and back-end buffering, 3. It can combine and split data, 4, the most important