SQL Server

SQL Server 2014 CTP2 publishes a feature for backup, which is native backup encryption. In view of the previously bad impact on the network database leakage events, is essentially a database backup leaked to the third party, SQL Server's original

Ø Basic Common Query --select SELECT * from student; --all Query All Select all sex from student; --DISTINCT Filter Repeat Select distinct sex from student; --count Statistics Select COUNT (*) from student; Select count (Sex) from student; Select

Recently to develop a search engine similar to the in a 1 million table through the keyword to a large character field query, query all the data containing keywords and paging, and the highest matching data in the first place, requiring query

In this series of articles, we'll delve into how to combine the. NET 2.0 and SQL Server 2005 query notification features to inform the application when critical data changes in order to eliminate the recurring query database. First, the introduction

Everyone is waiting for the new features of Microsoft SQL Server 2008 to appear, but we should first know what is not recommended (deprecated) and unsupported (discontinued) features. The "Not recommended" feature refers to features that appear in

One install Sybase client Version: Sybase Client 11.9.2 for NT 1 after the installation completes, the operation starts-> program->sybase->dsedit 2 Select Menu ' Server Object ',-> ' Add ' to enter service name like 1.70 3 then select ' 1.70 '

In a SQL Server database, backup and restore are only performed on the server, the backed up data files are on the server, and the restored data files are only available on the server, when the SQL Server client is started on a non-server machine.

ObjectiveIn the previous article, we analyzed the usage of query hint as the first of the last play module of tuning series. Interested can click to view: SQL Server Tuning Series play turn (how to run with query hint (Hint) bootstrap statement)This

DateDiff (Week,zy_time,getdate ()) =0//query this weekDateDiff (Month,zy_time,getdate ()) =0//enquire this monthThis season: SELECT * from table where DATEDIFF (Qq,c_calltime,getdate ()) =0First half year 1-6, after half year 7-12:select * from

Reproduced in this blog, the original blog: http://blog.csdn.net/baiduandxunlei/article/details/9180075CONVERT (Data_type,expression[,style])CONVERT (varchar (10), field name, conversion format)DescriptionThis style is typically in the time type

Error message:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or could not be accessed. Verify that the instance name is correct, and that SQL Server is configured to

I do not know what the reason, the log-in database today, this error may be related to my previous installation of MySQL, just started to think it was password input errors, tried several times or not resolved. Finally wait for you, haha, in this

Because of the work required, today you will install SQL Server 2005 on your computer. Previous projects are using ORACLE,MS database is not really how to use, the installation of Oracle has been pro, but installed SQL Server seems to have a little

Database design Specifications 1. IntroductionDatabase design refers to a given application environment, constructs the optimal database pattern, establishes the database and other application system, enables it to effectively store the data,

SQL Server Agent is the core of all real-time databases. Proxies have a lot of non-obvious uses, so the knowledge of the system is useful for developers or DBAs. This series of articles will be popular to introduce its many uses. In this

When you do data coversion for an SSIS project, you often encounter two issues like the following:1.Validating (Error)Messages* Error 0xc02020f4:data Flow Task 1:the column "XXXX" cannot be processed because more than one code page (936 and 1252) is

SQL Server Agent is the core of all real-time databases. Proxies have a lot of non-obvious uses, so the knowledge of the system is useful for developers or DBAs. This series of articles will be popular to introduce its many uses. In the

SQL Server field type decimal (18,6) before the decimal point is a few?Admittedly, this is a very low-level problem ....Why do you ask such a low-level question?Because of this problem, an SP failed to perform a data import .... That bothered me for

Change data capture, or CDC, records the INSERT, update, and delete activities of SQL Server tables. Using change data capture makes it more efficient to keep track of the DML history of Table objects, which is also useful for data transfer such as

This article is mainly script examples, more instructions to see Official documents: Auditing (Database Engine)--The audit use master must be created in the master database; go--Create a Server Audit