SQL Server

In SQL we often use null values,So what is NULL? The following is a brief description of MSDN (see "Null Values"):? A value of NULL indicates the value is unknown. A value of NULL is different from an empty or zero value. No null values are equal.

process: yesterday afternoon the database ran, the performance is not even on the database, restart service after the good.Query Japanese files, "autogrow of file ' Xx_log ' in database ' XX ' is cancelled by the user or timed out after 1896

Create a new Web page locally, and then write JavaScript code, you can directly manipulate SQL Server database, is not the cock burst!Prerequisites must be used in IE.The following code is tested in WINDOWS10 + IE 11 environment.DOCTYPE

1, SUBSTRING (operation of the string, the beginning of the position of interception, the number of characters returned)For example:Return ' CCC ' from ' ABBCCC ', charindex function usage (charindex (Find string, found string, position to start

As usual, first on the Delphi Interface Control layout:1 adoconnection, 1 adoquery, 1 DataSource, 1 button, 1 Dbgrideh (optional)Pre-Preparation: 1, set adoconnection connectionstring, for convenience: Provider=SQLOLEDB.1; password= database login

Environment: POWERDESIGNER15 Database SQL Server 2005The first step, open PowerDesigner, establishes a physical data model, as follows:Second step, after the new success, click on "Database", "Connect ...", configure the data sources that need to be

1. PRIMARY KEY constraint:To add a primary KEY constraint to a column, this column must satisfy the condition that the non-nullBecause of a PRIMARY KEY constraint: A column is constrained to be (not NULL, not duplicated)Here is the code to add a

--Database log name QueryUse DBNAMEGOSELECT file_id, name,* from Sys.database_files;GO---------------------------------------------------------------------------------------------------------sql SERVER 2005 Cleanup methodsUse [master]BACKUP LOG

SQL Server InstallationReference Links:Http://blog.csdn.net/sangjinchao/article/details/62044021?locationNum=6&fps=1JDBC Connection to SQL ServerReference Links:http://blog.csdn.net/stewen_001/article/details/19553173/ If the article is wrong,

Classification:Windows Authentication mode and Mixed modePlatform:WindowsProperties:Authentication ModeThe differences between these two types of authentication modes are:(1) Windows authentication ModeOnly Windows authentication is performed. The

SQL Server supports both Windows Authentication mode and mixed Mode authentication modes.Classification:Windows Authentication mode and Mixed modePlatform:WindowsProperties:Authentication ModeThe differences between these two types of authentication

Knowledge section1. SQL Server Data type• Data type is a property of the data used to define the data as time, number, string (text, letter), etc.· SQL Server provides a set of system data types that define all data types that can be used with SQL

SELECTTable name= Case whenA.colorder=1 ThenD.nameElse "' End, table describes= Case whenA.colorder=1 Then IsNull(F.value,"')Else "' End, Field ordinal=a.colorder, field name=a.name, Logo= Case when

Https://www.cnblogs.com/luluping/archive/2010/11/26/1888364.htmlBecause of the amount of SQL Server Management policy for system memory, unless the system memory is not enough (about the remaining memory is about 4M),SQL Server will not release a

SQL Server Basic OperationsCreation of a database1. Open the SSMS tool and connect to SQL Server. Right-click "Database"-"New Database"2. Specify the new database name, owner. (When you create a new database, the system automatically creates a

Original: SQL Server database MirroringTags: SQL server/mssql server/Database/dba/MirroringOverviewThis chapter covers the installation of database mirroring, which is installed in a domain environment.Environment: SQL Server R2 Enterprise

"51" When the system reinstall, in the case of SQL Server 2008 is not uninstalled, try to install SQL Server 2008R2, the installation prompt was successful but prompted a few errors, found that SSMs was not found, as well as in the SQL Server

Environment: SQLSERVER2008R2 One, Web server oneSoftware support: IIS, Dynamic Web site source codeTopology:Steps:Database section:1. Start-click SQL Server Management Studio2. Enter the SQL Server name or IP address, login name, password-click the

if exists(Select 1 fromsysobjectswhereType='TF' andName='atpublic_tf_getsummarydate') Drop functionatpublic_tf_getsummarydateGoCreate functionAtpublic_tf_getsummarydate (@calltype varchar(1)="',--0: Year 1: Month 1: Day

Method/Step1Click "Start" in the lower right corner of the computer, click "Control Panel" and click "Programs". In the list of programs, locate Microsoft SQL Server 2008, and right-click Uninstall (or double-click).2Pop-up SQL Server uninstall