SQL Server

1. sp_spaceusedCalculates the amount of disk space used by the data and index and the amount of disk space used by the tables in the current database. If no objname is given,sp_spaceused reports the space used by the entire current

SQL Server database Row_number () function usage explainedExcerpt from: http://database.51cto.com/art/201108/283399.htmThe use of the SQL Server database row_number () function is what we are going to introduce in this article, and then we will

Here are some of the requirements that you might say with the SQL Server Management Studio client to see if you can, why bother! Yes, we can manually check when 1 tables, but when there are 10 tables, 100 tables? Manual inspection is not only

First, the demandBefore the ranking function of SQL Server should be row_number (), I usually use the row_number () + CTE to achieve paging; today, the park, see another built-in ranking function is also good, by the way I think of a demand, You can

Possible causes and solutions: 1,windows Installer 4.5 is not installed on the update package that is appropriate for the Windows platform2,powershell (2.0) is not installed correctly.3, if Windows Server 2008SP1 should update the server Pakages 3

The cursor is evil!In a relational database, our thinking about queries is set-oriented. The cursor breaks this rule, and the cursor makes us think in a progressive way. For developers of Class C, this way of thinking will be more comfortable.The

Generally speaking, we use SQL as a collection-oriented data operation, but cursors provide us with a more powerful capability to perform a selective manipulation of data sets on a row-by-line basis. Of course, cursors also have an unavoidable flaw:

The data dictionary is as follows Only, where ' xx ' means ' from ', because Oschina does not give input keywords Kmcode,kmname,pidkm101 , tax revenue, 010103 , sales tax, 1011010304, general business Tax, 1010310106, personal income tax, 101101

SQL Server CTP2.2 Installation NotesDownload an ISO file, extract it (about 2.8G or so), and then double-click the Setup.exe to start the installation.Install. NET 3.5 SP1 Before installing, install in Server Manager-add roles and featuresOpen the

Reference: http://www.cnblogs.com/knowledgesea/p/3696912.htmland Baidu Search SQL Server table partitioncreate partition function Sgy_partitionfun (int) as range left for values (n ' 10000 ', n ' 20000 ')//drop partition function Sgy

SQL Server has the following functions for ranking or sorting: 1, Rank: The position of each record in the result set, but the rank may be discontinuous, for example: if there are two first names within the same group, the next position in the group

in EF5 Environment , first add EF environment, add Syste.Data.Entity in reference, add namespace using System.Data.Objects.SqlClient;Then write a controller test 1 Publicactionresult Index ()2 { 3 intCount =0; 4

Project, there may be too many databases (SQL Server database) logs, which account for a lot of disk space, and can reduce the log file size by shrinking the database log.The following is an example of the Northwind database:1. Set the recovery

If you cannot remotely connect to a SQL Server server on your server by IP address, you can set it up by referring to the following contentBefore you make the following settings, make sure your network is installed and the server is connected to the

1. Open the SQL Server Manager manager and find ' security ' right-click on the left to select ' new '-' login ', as2, Pop-up dialog box, enter your login number in the login name, select ' SQL Server Authentication ', and enter the password, you

Method 1: TRUNCATE TABLE name --This will not only delete the data, but also reset the field of the identity property. TRUNCATE TABLE jsqMethod 2: Delete from your table name? DBCC CHECKIDENT (your table name, reseed,0) resets the field of the

Recently I has got some free time and go through the knowledge about SQL Server.write this acticle in order to review in the Future.1. Join OptionJoin is important option in relational database. There is many types of join including Inner join,

The SQL Server database queries the number of records in the table by percentage and the number of server records. Can I query the number of records by percentage during SQL Server database query? The answer is yes. This article describes the

Sort out commonly used MySql query statements (23 types) and mysql statements No more nonsense. paste the Code directly. 1. query numeric data: SELECT * FROM tb_name WHERE sum > 100; Query predicate:>, =, ,! =,!> ,! , = 2. query strings SELECT *

User jb51net Login Failed. Cause: the password of the Account must be changed, "/" Indicates a server error in the application. User 'jb51net' Login Failed. Cause: the password of the Account must be changed.Note: An unhandled exception occurs