SQL Server

1. Add log4net configuration file Log4net.configConfiguration file properties are set to:The configuration is as follows:XML version= "1.0" encoding= "Utf-8"?>log4netDebug= "false"> Appendername= "Adonetappender"type= "log4net."

The leaf page of a clustered index stores the table's data. As a result, table rows are physically sorted by clustered index columns, because table data can only have one physical order, so a table can have only a single clustered index.When we

The trigger--it's all my understanding of the trigger.When you do the INSERT, delete, and so on, do some extra work,For example, adding new data to the inserted table when it is addedWrite an exampleInsert into UserInfo (Name) output inserted. Id

When SQL Server modifies the table structure after it has been modified by the designer: Save to text problem, this problem may be resolved by modifying the settings itemTools > Options > Designer > in the popup window is the "block save required to

Studied: http://www.cnblogs.com/amwicfai/p/3181003.htmlConfiguration notation in Beans.xml: Data Source - BeanID= "DataSource"class= "Org.springframework.jdbc.datasource.DriverManagerDataSource"> Propertyname= "Driverclassname"value=

--╔══════════╗--=====================================║cast function conversion ║--╚══════════╝The CAST () function syntax is as follows:--CAST ( as [length])/*"0", convert also provides a rich style for date conversion, cast only for normal date

Ext.: http://www.cnblogs.com/pangpanghuan/p/6432331.htmlSQL Server Add fields, modify fields, modify types, modify default values1. Modify the field name:ALTER TABLE name rename column A to B2. Modify the field type:ALTER TABLE name ALTER COLUMN

1. Structure language classificationDDL (data definition Language) Create drop alter creates deletes and modifies databases, tables, stored procedures, triggers, indexes ....DML (Data manipulation language) Insert Delete update to manipulate data in

1. To change the properties of the database file right-click on the properties of the two files--security--add--immediately find--find everyone this user to check his permissions are OK and then attach on OK.2. In the database manager, right-click

functions commonly used to intercept strings in SQL Server:1. Left(character_expression, integer_expression) function Description: Left('Source String','to intercept the leftmost number of characters') returns the specified number of characters from

The first step, in terms of SQL ServerHere is the login with authentication.Here I have built a HW database, and nothing else to say.The second step, the main partBecause the SQL Server database is connected for the first time, you do not know this

Last write a query in some simple query method, if said last is the primary query, then this is the advanced query.Today is mainly the aggregation function, the group query, the connection query, the union query. In my opinion the first three is

SQL PRIMARY KEY ConstraintPrimary key must be unique, primary key column cannot be nullEach table should have a primary key, and each table can have only one primary keyForeigh KEY to learnCreate a tableCreate Table TableName(Id int not NULL Primary

Tag: des ORDER by const TLE JOIN NULL expression CLU ParentCreate a test data tableCREATE TABLE [dbo]. [Test] ([ID] [int] IDENTITY (*) Not NULL,[PARENT_ID] [INT] Null[Agent] [Bit] NullCONSTRAINT [pk_test] PRIMARY KEY CLUSTERED([ID] ASC) with

About SQL SERVER Alwayon database restore operationsIdeas:In practice and in conjunction with related documentation, it is broadly divided into four steps:First step: Remove the db that needs to be restored from the availability group, (at which

CREATE TABLE ttable ( ID INT, F1 varchar (ten), F2 varchar (), f3 varchar) Goinsert Into Ttable Select one, one, 14INSERT into ttable Select, 25,26gocreate TABLE ttable2 ( ID INT, f5 varchar (ten), f6

Problem Description: You want to copy the tables and fields from one database to another database;Method One: A. Generate script file Select Database right button-"task-" Generate script;B. Select a specific database object-"next step;"C.

1. String type character string (based on ASCII encoding)Unicode string (Unicode-based encoding)Note: Using char to store Chinese characters (double-byte characters) can be garbled (and also look at the encoding format of the database), while using

DECLARE @startDate1 DATE;DECLARE @startDate DATETIME;SET @startDate1 =getdate (); SELECT @startDate =dateadd (day,-1, @startDate1);DECLARE @endDate DATETIME; SET @endDate =dateadd (Second,-1,convert (DATETIME, @startDate1));SELECT @startDate

1.DISTINCT returns the only difference is the value2.where extract records that meet subsequent conditions3.and & OR and & or4.insert into the table to insert a new record5.update updating records in a table6.delect delete records in a table7.select