SQL Server

SQL Server collate settings (character set) -- XP Chinese EnvironmentUse masterGoIf db_id ('test') is not null drop database TestGoCreate Database test -- default database creation collate = chinese_prc_ci_as is case insensitiveGoUse testGoCreate

data paging is a common problem during the development of both web and winform Programs , if you implement this process in Code , the efficiency of the server is obviously reduced, you can use the following stored procedures. Create procedure

  We all know that data warehousing and Data Optimization technologies are generally used when massive data problems are involved. So how to optimize the data? This article briefly introduces how to optimize massive data. 1. Use of indexes:

User 'sa 'Login Failed. Cause: it is not associated with a trusted SQL server connection. Compiled DatabaseProgramThis error occurs when you connect to a remote SQL Server database. The reason is that the SQL Server logon authentication mode is not

1. What is the database size? Exec sp_helpdb Select * From sysfiles 2. query a database space Use dbname Sp_spaceused 3. query a tablespace Sp_spaceused tablename 4. view the log file content DBCC log (dbname, type = 4)

Microsoft SQL Server 2005 (Chinese Standard Edition) $25200/22400/28000Microsoft SQL Server 2005 (unlimited user edition $33800 1 SQL Server 2008 R2 Standard Edition: 2,000Server use license 10,0003 SQL Server 2008 R2 Standard Edition purchase 46,46

Sqlconnection c = new sqlconnection ("User ID = sa; initial catalog = admin; Data Source = 799be7ef4229458 ");C. Open (); MessageBox. Show (C. State. tostring (); // display the data connection statusString SQL = "insert into T1 (name, PWD) values

SelectTable name = case when a. colorder = 1 then D. Name else ''end,FIELD No. = A. colorder,Field name = A. Name,Id = case when columnproperty (A. ID, A. Name, 'isidentity ') = 1 then' √ 'else' end,Primary Key = case when exists (select 1 from

Sysobjects tableEach object created in the database (constraints, default values, logs, rules, stored procedures, etc.) occupies one row in the table. Each temporary object occupies one row in the table only in tempdb.Column name data type

Connect to the remote server in SQL Server and create and delete a new database   1. Create a new database /*Connect to SQL2000 through the query analyzer in sql2005 and create the tmpdb Database: succeeded P_createdb 'tmpdb1', 'data', 'sa ', 'sa' */

[SQL Server] the following test is performed on the link between SQL Server and MySQL 2005 In the XP SP3 system.     -- Create a linked server through ODBC -- Method 1: Add a data source named mysql_testdb in advance to the system ODBC data source.--

Import java. SQL. connection;Import java. SQL. drivermanager;Import java. SQL. resultset;Import java. SQL. statement; Public class test {Private connection conn;Private string classforname = com. Microsoft. sqlserver. JDBC. sqlserverdriver ";Private

Instance description:　　Environment: Win2k + sqlserver 2 K + query AnalyzerSqlserver service instance name: mainserverName of the database to be backed up: MSDBLocal Machine name (client): DavidLocal User: ZF password 123Local Domain: domainFolder

1. Check whether your IIS is correct. 2. Check whether SQL Server is correct.   In the IIS directory wwwroot, create a file named testsqlserver. asp and write the following code: 'ole dB connection set cnn1 = server. createobject ("ADODB.

How SQL Server extracts Chinese characters, numbers, and letters   -- Extract numbersIf object_id ('dbo. get_number2 ') is not nullDrop function DBO. get_number2GoCreate Function DBO. get_number2 (@ s varchar (100 ))Returns varchar (100)AsBeginWhile

All information of the SQL Server database is stored in its system table. In most cases, the two most useful columns are sysobjects. Name and sysobjects. xtype. The previous one is used to list the names of objects to be evaluated, and the next one

Method 1:   Drop table:   If exists (select table_name from information_schema.tables where table_name = 'users ') Drop table users;     Method 2:   If exists (select * From sysobjects where name = 'cname' and type = 'P ') Drop proc

// Display the image saved in SQL Server in picturePrivate void listbox1_selectedindexchanged (Object sender, system. eventargs E){Byte [] buffbyte = NULL;String comm = @ "select IMG from Table1 where id =" + this. listbox1.selectedvalue;This.

Steps for configuring large memory for zookeeper: 32 GB can be used after large memory is used. It is not clear about more. Set step values:1. Install SQL Server2000, upgrade to SP4, and awe patch SQL2000-KB899761-v8.00.2040 installed after SP4,

Class sqlhelper { private string sqlconnstring; // database connection string private sqlconnection sqlconn = new sqlconnection (); // sqldatabase connection object private connectionstate sqlconnprestate = connectionstate. closed; // connection