SQL Server

Database storage query (the size of the database and the amount of data in each table in the database and the size of each row of records)IF not EXISTS (SELECT * from dbo.sysobjects WHERE id = object_id (N ' [dbo].[ Tablespaceinfo] ') and

Original: Inserting data into SQL Server database Insert Values Insert Select Insert Exec Select into Bulk Insert Insert values is the most common way to insert data, the basic syntax is as follows, the name of the

backgroundIn SQL Server, if we query the database to associate a table in another database, in this case we can do so by adding a server link.Case List Mode 1. SQL Server provides a graphical interface, as follows:Right-click >>new Linked ServerFill

Specific steps such as:1, first drag a foreach control in the SSIS Toolbox, and select the corresponding folder, matching the corresponding file, as follows2. Create variables to receive3. Drag into a data Flow task, and then drag it into an Excel

function format Create function-- =============================================--author:clive Chinery--Create date:08nov2008--Description:trim long strings to prescribed length-- =============================================CREATE

First big class: Integer dataThe Bit:bit data type represents 0,1 or null, which means true,false. Consumes 1byte.int: The positive and negative numbers are stored in 4 bytes. Storage range: -2^31 to 2^31-1.SmallInt: Stores the positive and negative

First step: Create a Wizard FileCreate a TXT file on the desktop and change the file suffix to ". udl". Step Two: Select the Provider tab pageDouble-click the newly created. udl file, enter the Provider tab, and select Microsoft OLE DB Provider

The database contains many tables and data, and sometimes you need to create a script to export the table structure along with the dataHere's how:1. Right-click the database and select Tasks---> Generate script2. According to the requirements,

Skilled use of various usage methods in SQL Server can bring a lot of convenience to queries. Let's introduce except and intersect today. Note This syntax is supported only for SQL Server 2005 and later version numbers.Except refers to the data that

problem leads to: The DateTime data type in SQL Server is accurate to milliseconds. If we use GetDate () to record the time that the record was inserted when inserting a piece of data, the current time is inserted, exactly to the millisecond. We do

create FUNCTION [dbo]. [Splittotable] (@SplitString nvarchar (max), @Separator nvarchar (10) = ") RETURNS @SplitStringsTable TABLE ([id] int identity (), [value] nvarchar (max)) as BEGIN DECLARE @CurrentIndex int DECLARE @NextIndex int;

If two threads modify the same record in the database at the same time, it causes the latter record to overwrite the previous one, causing some problems.For example:A ticketing system has a number of votes, the client every call to the ticket method,

For program developers, the two most popular background databases currently used are mysql and sql server. The most basic similarity between the two is that the data is stored and belongs to the query system. You can use SQL to access the data for

In SQL Server, users can not only use standard built-in functions, but also use their own defined functions to implement some special functions. Can be created using the Create FUNCTION statement. It is important to note that the function name must

Characters are:char (n) a fixed-length string.   A maximum of 8,000 characters. Nvarchar (n) variable-length string. A maximum of 8,000 characters.VARCHAR (max) variable-length string. A maximum of 1,073,741,824 characters.The text variable-length

Skilled use of various usage methods in SQL Server can bring a lot of convenience to queries. Let's introduce except and intersect today. Note This syntax is supported only for SQL Server 2005 and later version numbers.Except refers to the data that

Objective:In the previous chapter, you demonstrated how to use SSMS to configure resource governor. But as a DBA, there is always a time to write a script, because it can be reused and extended. And can be quickly deployed on different servers.The

1. In the current server right-click on the "property page", "Security", tick SQL Server and Windows Authentication mode, OK.Because the SA is not enabled by default, if you enable the SA account login, you will also need the following settings:2,

Read the online a lot about the deadlock of the blog, we usually introduce the principle of the deadlock, I also write a detailed analysis. Of course, it's about SQL Server's deadlock.Fetching deadlock events using SQL Profiler2. Select tab: Event

The SQL statement cyclically processes the data of the current row and the data of the previous row plus or minus, and the SQL statement In the following example, we use a cursor to cycle the data in Table # temptable, and then add argument1 in the