what is mssql database

Self-growth of identity columns disabled/enabled in the databaseSET Identity_insert []tableon| OFF } To allow the identity column to insert data when recovering data, you must set the property above to on---------------------------------------------

Excel file Import Database multiple sheetif exists (select 1 from sysobjects where name=n ' p_import_excel ' and type= ' P ')drop proc P_import_excelGo--call example exec p_import_excel ' C:\123.xls ', ' Sheet1; Sheet2; Sheet3 ', ' tbl 'Create proc

These days in a project, contract management system (is the upgrade and transformation of the old system, the old system is VS2008 do), because the database table is the project group based on the old system of database built, so in the query of the

Our system is to support the installation of multiple sets on the same machine.The installation method is the right mouse button "copy", "Paste" (the. mdf is automatically attached to the directory at startup).Some people install multiple sets, want

First, the concept of the indexAn index is a way to speed up the retrieval of data in a table. The index of the database is similar to the index of the book. In books, the index allows users to quickly find the information they need without having

Today encountered a problem, the MSSQL2005 database installed on the server modified the default 1433 port, the server itself connected to the database without any problems (before others installed, configured), when I installed on other computers

Under Windows System, the PHP5.3 version already does not support MSSQL extensions. First http://msdn.microsoft.com/en-us/sqlserver/ff657782.aspx click get it download SQLSRV20.EXE. Unzip the file to the Extended folder in PHP, ext. Open php.ini

PHP's own extended Php_mssql.dll connects SQL Server 2000, operates with the MSSQL series functions, and operates as MySQL. 1, open the PHP configuration file php.ini, find; Extension=php_mssql.dll remove the semicolon from the front. 2, find

What is the logical file name? The program you use is connected with the database name, and then you right-click the property in your database, click "File" in the upper left corner, you can see that the database name and logical file name is not

Copy Code code as follows: ' Database table row number function, which is the number of rows to fetch the table Function gettblrows (tblname) ' If the Tblname table name value is empty, the If Tblname= "" Then Gettblrows= "Unknown

How to import a databaseYou can import the SQL shared Server database from the restriction file. If you want to import data that is stored elsewhere, you need to first copy the content to the restriction file. (Note: Before you import a database,

Copy Code code as follows: --row-and-column issues --Build a test environment Create Table TEST (Dates Varchar (6), EMPNO Varchar (5), Stype Varchar (1), AMOUNT Int) --Inserting data Insert TEST Select ' 200605 ', ' 02436 ', ' A ', 5

Copy Code code as follows: $serverSite = "."; $db = "Phpdemo"; $name = "sa"; $pass = "sa"; $conn = @mssql_connect ($serverSite, $name, $pass) or Die ("Database connection Error!) "); @mssql_select_db ("Phpdemo", $conn); Echo '

Copy CodeThe code is as follows: --row-and-column issues --Build a test environment Create Table TEST (Dates Varchar (6), EMPNO Varchar (5), Stype Varchar (1), AMOUNT Int) --Inserting data Insert TEST Select ' 200605 ', ' 02436 ', ' A ', 5 Union all

First, the concept of the index Indexing is the way to speed up the retrieval of data in a table. The index of the database is similar to the index of the book. In books, the index allows users to quickly find the information they need without

Stored Procedure | data | database In this example, we take the first two rows from the two tables and merge them into a table. In reality we often encounter situations where two tables exist in one database, assuming table 1 stores the quarterly

Many times, because of backup or other reasons, the log log files of the database have been lost, what should we do when the database files cannot be attached through normal SQL Enterprise Manager? Here are two ways for you to refer to: Method One

One, backup database 1. Open SQL Enterprise Manager, click to open Microsoft SQL Server in the console root directory 2, SQL Server group--> double hit Open your server--> double-click to open the database directory 3, select your database name

Solution | data | Database First provides a complex method for compressing logs and database files as follows: 1. Empty log DUMP TRANSACTION Library name with NO_LOG 2. Truncate the transaction log: BACKUP LOG database name with NO_LOG 3. Shrink

This article mainly introduces the ASP to obtain the database table to specify the criteria for the number of functions of the function of the relevant data, need friends can refer to the The code is as follows:' Database table row number function,