SQL Server

Set conn = Server.CreateObject ("ADODB. Connection ") Conn.Open "ODBC name", "username", "password" Sql1= "SELECT * from dbo.sysobjects where type is not in (' S ', ' D ', ' K ')" Sql1= "SELECT * from dbo.sysobjects where type = ' U '" Set RSCC =

How to get more than one recordset from ADO and how to use SQL Server stored procedures in ADO DataType Value Length Data

In the process of maintaining SQL Server databases, do you often encounter thousands of log20050901 such as the log table, each table is not a lot of data, one open look is very inconvenient, or sometimes we need to put the data in these tables, One

One of the new features of Microsoft SQL Server 2000 is that it supports XML, so users can access XML-enabled SQL directly via HTTP Server2000 database. The implementation method is described below. System environment: Windows2000 Server (contains

Same-Library operationsSelect a. Column name 1,b. Column name 2,a. Column name 3 from table name 1 as aJoin table Name 2 as BOn a. Association field =b. Associated Fields Different library operationsSelect a. Column name 1,b. Column name 2,a.

Mssql_connect function in php cannot be used by default. We need to configure it as follows:In PHP. ini, open the extension = php_mssql.dll option (that is, remove the previous; number)2. Download the correct version of ntwdblib. dll (2000.80.194.0)3

Method 1,This is a primary method for deleting duplicate records. We use distinct to store unique data in a table. The code is as follows:Copy code Select distinct * into # tmp from tablename Then, delete the original table. The code is as

Method: The code is as follows:Copy code            Select distinct * into # tmp from tablename drop table tablename select * into tablename from # tmpDrop table # tmp We often encounter the need to delete repeated records in SQL Server. Here

Let's take a look at our error prompt.Error message: the backup of the DATABASE in the backup set is different from the existing "XXXXXX" DATABASE, and the restore database is terminated abnormally.The cause of this error is that the physical

First, you can try sp_attach_single_file_db and try to restore your data file. Although it is unlikely to be restoredIf this database executes a checkpoint, it may still be successful.If you are not lucky enough to be lucky enough to touch the

Q: How can I operate SQL Server 6.5 servers under SQL Enterprise Manager version 6.0?A: Before using SQL Enterprise Manager version 6.5 to operate SQL Server 6.0, you must first run it on the 6.0 Server.SQLOLE65. SQL. The file is in the MSSQLINSTALL

Q: How can I start a transaction on SQL Server?A: There are three types. The first is an explicit TRANSACTION, which must start with begin transaction. The second is automatic submission.This is the default setting of SQL Server. Each T-SQL

Recently, I have been designing databases and sometimes cannot figure out the data types in SQL2000. So I picked this article.(1) char, varchar, text and nchar, nvarchar, ntextChar and varchar are both between 1 and 8000 characters in length. The

Directly copy the data file to the database data file (*. mdf) and log files (*. ldf) are copied to the target Server and restored in SQL Server Query Analyzer using statements: EXEC sp_attach_db @ dbname = 'test', @ filename1 = 'd:

1. Ranking function and PARTITION The code is as follows:Copy code -- All dataSELECT * FROM dbo. student AS a inner join dbo. ScoreTB AS B ON a. Id = B. stuidWHERE scorename = 'China'--------------------------------------------- The usage of ROW_

Because sqlserver is intelligent, we only need one sentence to implement automatic database backup for SQL server. The code is as follows:Copy code Backup database [SiteWeaver] to disk = n'e: workbackupdatabaseSiteWeaver. bak 'with noformat,

1: If the parameter is of the int type: The code is as follows:Copy code Declare @ a xmlSet @ a =' 1 5 4 3 2 'Select * from product where id in (Select d. x. value ('./id [1]', 'int') from @ a. nodes ('/*') as d (x ))  1: If the

Yesterday, someone discussed in the group three functions that SQL Server returned the last IDENTITY value: IDENT_CURRENT, @ IDENTITY, and SCOPE_IDENTITY, and made some markup and summary.In fact, MSDN has an official explanation for this: all three

Forgot the sa logon password for Microsoft SQL Server 2005.Solution: Use windows Authentication to log in, and then right-click 'sa '-'properties' in 'security'-'logins'. Change the password and click confirm.If not1. Enter in windows authentication