SQL Server

1. An error occurred while establishing a connection with the server. When you connect to SQL Server 2005, the default setting does not allow remote connection to SQL Server may cause this failure. (Provider: named pipeline provides Program , Error:

Yesterday's blogsql statement: displays the information of all tables in SQL Server. It organizes an SQL statement that displays the information of tables and columns in all databases. Today, I used it as a small tool to export the SQL server2005

Problem: When backing up an SQL Server database, you can specify a file name. Suppose we need to back up data every day, and we want to back up different file names every day, for example, using the current date as the file name   My answer: Use

How to batch insert multiple data entries into a database data table? Use sqlbulkcopy, for example: /// /// Batch import data to the database /// /// Data source table /// Database Table Name /// Database connection string ///

If the default value of a column is set when a table column is added dynamically, If you use the alter table tablename drop column columnname statement, an error is returned, For example: "Message 5074, level 16, status 1, 1st row object 'df _

-- Obtain the version number of MS SQL Execute master .. sp_msgetversion -- Obtain the hard disk file information-- Parameter description: directory name, directory depth, and whether to display filesExecute master .. xp_dirtree 'C :'Execute

Retrieve table information   Select Sysobjects. Name, SYS. extended_properties.value From Sysobjects Left   Join SYS. extended_properties On Sysobjects. ID = SYS. extended_properties.major_id Where Type =   ' U

Generally, SQL Server is used as the background database. The simplest and easiest way to encrypt user passwords and verify passwords is to use SQL Server's own functions, which is convenient, fast, and easy to use. However, it is worth noting that

Enterprise-levelDatabaseMost applications are deployed inRaidThe disk array server can improve the disk access performance and implement fault tolerance/disaster tolerance.RAID (redundant disk array) is simply an array made of cheap hard disks. The

In SQL Server 2005, you can use% Lockress %Obtain the physical path information corresponding to the data row.% Physloc %Obtain and useSYS. fn_physlocformatterAfter the binary data is converted% Lockress %But these are not described in msdn. %

AlgorithmIt is an important research direction in computer science and the key to solving complex problems. Algorithms are everywhere in the computer world. A database is a place for storing data and performing mass computing. It is not uncommon to

An error occurred while establishing a connection with the server. When you connect to SQL Server 2005, the default setting does not allow remote connection to SQL Server may cause this failure. (Provider: named pipeline providesProgram, Error:

When locking an SQL Server database, in addition to locking different resources, you can also use different degrees of locking, that is, there are multiple lock modes. The locking modes in SQL Server include: 1. in SQL Server, shared locks are

The following instances are created on Sunday as the first day of the week. For details, see @ datefirst.Datediff (datepart, startdate, enddate)The datediff function calculates the total number of time intervals between two dates, such as hour, day,

Create procedure [DBO]. [up_pager] @ Table varchar (2000), -- table name @ Col varchar (50), -- pagination by this column @ Orderby bit, -- sort, 0-order, 1-inverted @ Collist varchar (800), -- List of fields to be queried, * indicates all fields @

Rsync_serverrsync Server Download Download rsync_client rsync Client Will be appliedRsyncIt is mainly because of the needs of the company's projects, the key isSqlserverA database backed up regularly to another backup server. Some other

Sometimes we need to save some binary data into the database. SQL Server provides a special data type called image for us to save binary data. Binary data can be images and documents. In this article Article In SQL Server, we will see how to save

The following is the most direct way to use a cursor: Code Running Condition: A tb_paperinfo (paperid, papername) Table -- Declare a cursor marked as C. The cursor identifies two columns from the tb_paperinfo table. Declare C

Use convert to convert the date format in SQL Server   Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--> Select   Convert ( Varchar ( 10 ), Getdate (), 112 ) -- Yymmdd 2010

Create Database book Use book Create Table personlike(Id int primary key,Likecontent varchar (100) not null) Insert into personlike values (1, 'Sports ')Insert into personlike values (2, 'travel ')Insert into personlike values (3, 'game