SQL Server

1/early grammatical structure of the internal connection INNER joinSELECT * from Person.person JOIN humanresources.employee on Person.Person.ID = HumanResources.Employee.IDEquivalent to an earlier version of the oldSELECT * from

Original: Database management--security management--Identifying logins for SQL Server hollow or weak passwordsOriginal translation from:Http://www.mssqltips.com/sqlservertip/2775/identify-blank-and-weak-passwords-for-sql-server-logins/?utm_source

I've been using MySQL for 2 years, and I've always been ASP. NET + MySQL DevelopmentWhy not use MSSQL?Reason:In my country, I can hardly find any hosting company that provides SQL SERVER, or 2005-year version, or very high price.I think it's strange

Original: SQL Server Tour--a preliminary understanding of the 13th station lockFinally this series is coming to an end, the new year is coming again, there is no mood to write blog ... As a developer, the lock mechanism is something that our

Declare @s varchar (a); Set @s = N' tuck '; Select UniCode (@s),nchar(UniCode(@s));When working with Unicode string constants in SQL Server, you must precede all Unicode strings with the uppercase n as the prefix, and the n prefix represents the

1. First create a login for SQL Server authentication and map to the database. such as: Create User [KK] mapping to a database [MyTest] , this time the database [MyTest] will add a user [KK]2. Delete the login name at this time [KK], after deletion,

In general, login created in SQL Server, regardless of permission size, can see all of the databases in its SQL Server, which can be verified by the following T-SQLIF EXISTS(SELECT * fromSys.server_principals SPWHEREName= 'Test') DROPLOGIN

Original: SQL Server 2005 MD5 functionIn SQL Server 2005, the function Hashbytes (), which is provided by Microsoft in SQL Server 2005, can be used to calculate the MD5 and SHA1 values of a string, using the following method:--Get 123456 MD5

In the process of using the database, there are always some special needs. Sometimes it is necessary to store Chinese characters, to be case-sensitive or to be sorted in the order of the English. This involves the choice of database arrangement

In SQL Server 2005/2008/2008 R2, we can use SQL Server's own pre-editing 200-line feature, which is intended to simplify the use of update, allowing developers, DBAs and some people who do not understand T-SQL are able to directly modify data in the

SQL Server Global VariablesIn SQL Server, global variables are a special type of variable, and the server maintains the values of those variables. Global variables begin with the @@ 前缀, do not have to be declared, they belong to the system-defined

The original: Remember the paging optimization of SQL Server and talk about the problems of using row_number () pageRecently there is a project response, in the server CPU usage is high, our Event query page is very slow, query a few records

Knocking at the computer room, VB. Net do the front desk of the computer room for operation, use SQL Server to do backstage to save the data, the foreground and backstage contact, use to ADO. It is a set of object-oriented class libraries for

There are two parameters in SQL Server, syntax:ISNULL (Check_expression, Replacement_value)Check_expression and Replacement_value data types must be consistentIf Check_expression is NULL, the Replacement_value is returnedIf Check_expression is not

1. FOR XML path (' str ')Select Id,createtime from dbo. Articleinfo FOR XML Path (' MyTitle ')Result: (Note: If it is select Id,createtime from dbo.) Articleinfo FOR XML path below results becomes default )42015-02-03T10:44:15.85752015-02-03T14:04:4

OriginalOriginal: http://blog.csdn.net/tjvictor/article/details/5251351?If your database is running in full or bulk log recovery mode , you will need to use the job to back up the transaction log regularly, keeping your transaction file size in a

first, write it in front.Recently has been thinking about a problem, what can let us do not appear impetuous, the real calm down, the heart to feel, intentions to answer everyone's questions, intentions to help others. The reality of life, often let

1. Place the data sheet given by the teacher in the directory "C:\Program Files\Microsoft SQL Server\mssql10_50.mssqlserver\mssql\data".2. Open SQL Server 2008. Link the local server.If the connection is not on, the displayThen the SQL Server

0 or 100 (*) default value mon dd yyyy hh:miam (or PM)1 101 US MM/DD/YYYY2 102 ANSI Yy.mm.dd3 103 UK/France Dd/mm/yy4 104 German Dd.mm.yy5 105 Italy Dd-mm-yy6 106-dd Mon yy7 107-mon DD, yy8 108-HH:MM:SS-9 or 109 (*) Default value + MS Mon dd yyyy hh:

The so-called database refers to: according to a certain data structure to organize the storage and management of the warehouse.The database is mainly divided into the following categories:Hierarchical type: Generally used in enterprise organization