SQL Server

The source of this article: http://www.cnblogs.com/wy123/p/5960825.htmlWhen we do the development, sometimes we need some help data, must need continuous number, continuous interval of time, continuous quarterly date and so on.Many people use the

SQL Server 9003 Error resolution applies only to SQL2000 (SQL2000 only) "Cannot open new database ' POS '." CREATE DATABASE abort. (Microsoft SQL Server, Error: 9003) "Look at the 9003 error, the thought might be due to the log file, and then look

SELECT * from Master. sysdatabases ORDER by NameSelect Name,* from Master. sysdatabases where name='TestDB'%testdb% ' *'%com_userlogin%'stringConnectionString ="server=.; Uid= '"+ UID +"'; Pwd= '"+ pwd +"';D atabase= '"+ DB +"'"; string[]

Soft code generator in SQL Server, the generated code incorrectly identifies a unique index as the primary key.After you decompile the source code, you find that the SQL condition is incorrect, and now fix the bug.FIX: Replace the

The interface is as follows:Because the computer's SQL Server service does not start on its own, and sometimes needs to shut down the SQL Server service, you find a tutorial on the Internet.The source code is as follows:@echo offchoice/t 3/c yn/d

First, SQL Backup of the database :1. Open Start menu → program →microsoft SQL Server 2008→SQL server Management studio→ database: dsideal_school_db is the database of students we need to back upFigure (1)2, select the database to be backed up

In the condition with the Chinese can not be queried, because the field sender_su_name is nvarchar type, need to precede a nSELECT * from [test]. [dbo].  [Ship_user_email] WHERE [sender_su_name]=n ' reward 'Why take N as explained below:Using

Toss SQL SERVER 2012, get a morning to modify the database name, mainly need to modify the name of Db.mdf and Db_log.ldf, finally solved. Write it down here, and change it later, and don't forget it.Assuming the original database name is DB, the

RPM: Http://www.cnblogs.com/lyhabc/archive/2013/01/13/2858916.htmlSQL Server Read statement run statistics SET STATISTICS time IO profile OnFor statements to run, there are other factors to consider, in addition to the execution plan itself, such as

How the database uses tables when storing data: Columns are called fields in the database Rows are called records in the database Data type: Character data type: char, varchar, etc. Date Time Data: datetime, etc. Numeric type:

SQL Server implements 6 isolation levels to prevent the occurrence of problems similar to attempts to concurrently access or modify the same data in a concurrency scenario. This article will take you through all 6 isolation levels. As you'll see

Concept IntroductionDevelopers like to use with (NOLOCK) in SQL scripts, with (NOLOCK) is actually one of the table hints (table_hint). It is equivalent to readuncommitted. The specific function functions are as follows (from MSDN):1: Specifies that

FIX: Installing SQL 2008 does not provide an invalid credential for the SQL Server Agent serviceInvalid credentials provided by SQL Server 2008 Agent serviceInvalid credentials provided by SQL Server 2008 Agent serviceProblems that occur when you

Detach the database as follows:use master go sp_detach_db ‘mydb‘ go Then, copy the data and log files from the current location (D:\Mssql7\Data) to the new location (E:\Sqldata). Reattach the databases that point to the files in the new

Arithmetic as follows:--Subtraction (+ 、-、 *, \,%) take the remainder operationSELECT--addition Operation3+5 asAddition result 1,3.5+6 asaddition result 2,--Subtraction OperationsTen-2.5 asSubtraction Results 1,15.5+5.5 asSubtraction Results 2,--

In fact, in Microsoft's cloud services Azure, nearly one-fourth of the services are provided by the Linux operating system. But we can't make Microsoft's software run on a Linux server. It's really embarrassing.But this week, Microsoft finally

Error: SQL Server blocked access to STATEMENT ' openrowset/opendatasource ' of component ' Ad Hoc distributed Queries ' because this component has been shut down as part of this server's security configuration Closed. System administrators can

For DBAs, backing up and refreshing resumes is two of the most important tasks, and if a failure occurs and the backup is not available, then the importance of refreshing the resume appears, wow! Of course, backup is the most important thing for

SQL server table data change trigger mail sending method, SQL send mail Today, I encountered a problem where the original production system is running properly. Now I need to monitor a data table and send an email to the Administrator when adding

Explore the efficiency of select in postgresql, selectpostgresql You can see this problem in zhihu: How does MySQL query select * from table where id in (hundreds or thousands of IDS) to improve efficiency? Modify E-commerce websites, a commodity