SQL Server

After reading the books online, sqlserver spatial data can be divided into geometry and geography. The former belongs to the plane coordinate system (it is a headache when you see it, and you have not studied whether to configure projection

The recovery of the system database is summarized as follows: In the SQL Server database, the system information is stored in the system database. The main system databases include master, which controls the user database and SQL server

When it comes to text replacement in databases, most people first think of the replace function: Update table set column = Replace (column, 'oldkeyword', 'newkeyword ') However, when column is text or ntext, the preceding query will return the

During Development today, I encountered the problem of counting the number of database tables in SQL Server 2005. So I wrote the SQL statement myself: Select count (1) From sysobjects where xtype = 'u'. Once executed, I found that the number of

There are two statements: Select @ versiongo Selectserverproperty ('productversion') as productversion, serverproperty ('productlevel') as productlevel, serverproperty ('version') as edition, serverproperty ('engineedition ') as engineedition;

See http://www.cnblogs.com/jiang_zheng/archive/2009/02/05/1384622.html 1 ========== In the CMD window C: \ Documents ents and Settings \ Administrator> osql-e 1> sp_password null, 'abc123', 'sa' 2> go Password Changed.1> exit As a result, the

**************************************** ************************************* There is no problem with running the local machine, but this error is reported when it is published to the server. Then we can delete "Integrated Security = sspi", but I

In this article, the naming method of the standard blueprint is only applicable to SQL. If you are creating a new stored procedure or find a stored procedure that is not constructed according to this standard, you can refer to this standard.   Note:

Using system; Using system. Collections. Generic; Using system. componentmodel; Using system. Data; Using system. drawing; Using system. text; Using system. Windows. forms; // The namespace introducedUsing system. Data. SQL; Namespace enumsqlserver{

Introduction We already know that the smallest unit of SQL Server Io is a page, and the eight consecutive pages are a zone. SQL Server requires a way to know the space usage in the database under its jurisdiction. This is the GAM page and SGAM page.

Microsoft has established a flexible and powerful security management mechanism to improve the security mechanisms implemented by the SQL Server 7.0 series, it comprehensively manages the security of users' access to the SQL Server server system and

Recently, I was working on a report in an ERP system. The big column in this report is statistical, such as delivery rate and purchase percentage. This means that it is not possible to simply connect to several tables, the data of several basic

Master The master database stores all the databases on the sqlserver entity, and it is also a binder that holds the engine. If you do not use the primary database, sqlserver cannot be started. Therefore, you must carefully manage the database.

When the log file is full and the SQL database cannot write the file, you can use either of the following methods: One method: Clear logs. 1. Open the query analyzer and enter the command Dump transaction database name with no_log 2. open the

1. view the database role of the SQL 2005 userUse yourdbGo Select dbrole = G. Name, membername = U. Name, membersid = U. SidFrom SYS. database_principals U, SYS. database_principals g, SYS. database_role_members mWhere G. principal_id = M.

For the database system that has just been installed, if it is installed by default, it is likely that an error is reported during remote connection. The common error is: "When you connect to SQL Server 2005, this failure may occur if SQL server

If you have installed the full SQL Server version, the following error occurs when you use the ASP. NET Website Configuration tool: Failed to establish database connection. If you have not created an SQL Server database, log out of the website

IntroductionLet's skip the concepts, steps, and syntax of the cursor. Let's look at an example: Table 1 originsalary Table 2 addsalary There are now two tables, one of which is originsalary table-Payroll table. There are three fields: 0_id

By the end of the year, I have made some preparations for my work and study problems and some common knowledge points for future use. This article involves the database, which is a summary of development (1) --- supplement to the database article. 1.

Ranking function detailsSQL Server2005 is able to rank data rows in T-SQL code. The ranking function can rank each data row, providing a way to organize output in ascending order. You can give each row a unique sequence number, or give each group of