SQL Server

Display SQL Server version information Description Display SQL Server version information. Supported platforms SQL Server 2000Yes Script code Strdbservername = "." Set objsqlserver = Createobject ("sqldmo. sqlserver ")Objsqlserver.

To reinstall ms SQL Server 2000, you usually need to completely delete the original installation file. You can't reinstall it before. By default, it is occupied. Use the following methods to handle installation suspension: 1. Enter Regedit in

Error: If the logon trigger cannot be properly executed, the logon will fail.For example, if this trigger is created, you can design the following code to achieve the purpose of failure.Copy codeThe Code is as follows:Create trigger BadLogonTrigger

Operation Method: first install SQLServer2005, and remember the user name and password you set during installation. The following describes how to restore the database file epdmdb20101008.bak backed up by SQLServer as an example. ① Open SQLServer2005

-- SQL Regular Expression replacement functionCopy codeThe Code is as follows:CREATE function dbo. regexReplace(@ Source ntext, -- original string@ Regexp varchar (1000), -- Regular Expression@ Replace varchar (1000), -- replace value@ GlobalReplace

-- Simple Case FunctionCASE sexWHEN '1' THEN 'male'WHEN '2' THEN 'female'ELSE 'others' END-- Case search functionCase when sex = '1' THEN 'male'WHEN sex = '2' THEN 'female'ELSE 'others' END These two methods can achieve the same function. Simple

Map data is stored in sqlserver 2008. When mapxtreme7 is used for development and Feature. Update () method is used, the error prompt contains "MSSQL truncates string or binary data"The main reason is that when a field is assigned a value, the

1. Scenario: query by student ID and return all students in the student's class. You can automatically locate the student ID page in the query condition by PAGE, custom sorting, and result set.Copy codeThe Code is as follows:Create proc [dbo].

I previously added a field to this list to help me prompt the administrator if the product list has a Status field such as modification, so I can conclude that this field is added.First, let's take a look at how I previously wrote this prompt Status

Of course, the first reaction is to use stored procedures. Determine the original field value and then UPDATE it.I cannot find a solution after a rough query on the Internet. I have a very interesting result, and I don't even need to use

Depending on the implementation policy, there are three main types: snapshot replication, transaction replication, and merge replication. The three replication types have their own characteristics and are applicable to different scenarios. Generally,

1. Adjust Memory Sp_configure 'show advanced options', 1GORECONFIGUREGoSp_configure 'awe enabled', 1GORECONFIGUREGoSp_configure 'min server memory ', 1024GoSp_configure 'max server memory ', 3072GORECONFIGUREGoPS: OS needs to open AWE and add/3G

First: connect to the database through ODBCJAVA's cross-platform processing capabilities (Write Once, Run Anywhere) and excellent image processing capabilities (I believe there is no such language that can surpass JAVA's network processing

SQL event probe data columnThe SQL event probe allows you to select data columns when creating a template. The list of data that you want to return when running the trail. Data displayed in the SQL event probe can be displayed in the event sequence,

Summary1. EXEC usage2. Use of sp_executesqlMSSQL provides two types of commands for dynamic execution of SQL statements: EXEC and sp_executesql. Generally, sp_executesql is more advantageous. It provides an input and output interface, but EXEC does

Unicode Character Set is generated to solve the incompatibility problem of character sets. All its characters are expressed in two bytes, that is, English characters are also expressed in two bytes.If you are still struggling with this issue, let's

The following are their commonalities:1. Concepts about left and right tables. The left table refers to the table on the left of left join in the SQL statement, and the right table refers to the table on the right of left join.2. In a large table,

I had no intention of entering a website when I was searching for information on the internet yesterday. I entered the website in a confused manner. I couldn't raise my right. Then I added the Q Number of the service provider to ask a Social

If we insert a value in the ID column, for example:Insert member (id, username) values (10, 'admin ')The query analyzer will return an error message:Reference contentServer: Message 544, level 16, status 1, Row 1When IDENTITY_Insert is set to OFF,

Database Operation statement7. Outer Join-cross Query7.1 Query7.2 equijoin7.3 right Outer Join7.4 left Outer Join7.5 update operationsIntroduction:External Connection and self-connectionInner join (equivalent join) returns only rows with equal join