SQL Server

In DB2, the database can be restored to the specified time point. When the SQL Server database recovery model is full or bulk copy, the database can be recovered from the log. In fact, one of the statements recorded in the log redo these SQL

In SQL Server, the identity column is often used. This self-increasing field operation is indeed more convenient. But it sometimes brings some trouble. Example 1: when some data is deleted from a table, the number of the auto-increment column is no

  Scalar functions: View code Create Function DBO. fn_getdistance (@ lngbegin real, @ latbegin real, @ lngend real, @ latend real) returns float as begin declare @ distance real declare @ earth_radius real set @ earth_radius = 6378.137 --

Here are twelve helpful tips for ensuring that you 've constructed your SQL Server Stored Procedures to perform in the most efficient manner possible. 1. Use stored procedures instead of heavy-duty queries. This can reduce network traffic as

ArticleDirectory 1. Open the Enterprise Manager, expand the server, right-click the local server, and choose properties: 2. Select the regular window. The SQL Server proxy is automatically enabled: 3. Repeat Action 1. Open the SQL

There are three basic methods for connecting SQL server to a remote data source: OpenDataSource : The OpenDataSource function is used to specify connection information for a remote data source by specifying the ole db provider and an initialization

1. Naming Conventions are often used for database development. 1> use a singular table name that does not contain numbers. You can add a module name prefix if necessary. 2> for primary key naming, the table name + id is used. 3> the names of

When using SQL Server, the most common problem is that the connection fails. Generally, there are two ways to connect to SQL Server. One is to use Client tools provided by SQL Server Such as the Enterprise Manager, query analyzer, and transaction

How to: Use osql to manage the SQL Server Desktop Engine (MSDE 2000) Transferred from blog of msdn accpwww This page Summary   What is osql?  

1> Binary data type Binary data makes some data in hexadecimal format. Binary data types include binary, varbinary, and image. Binary [(n)]: a fixed length of n Bytes of binary data. The maximum length is 8 KB. Varbinary [(n)]: Variable Length

What is osql? Osql is a Microsoft Windows 32 command prompt tool that can be used to run Transact-SQL statements and script files. Osql tool uses ODBC database applicationsProgramThe programming interface (API) communicates with the server. To put

The main challenge is to understand how the code that accesses the database works. the. NETTechnology that permits accessing a database from C # code is called ADO. net. Ado. netGroups all. Net classes that are related to database access.Ado. Net is

When SQL server uses a job to import data. Because t_ SQL is a script processing error, the exception is inconvenient, but an error is reported, causing the job to fail. For example, the execution of the stored procedure fails due to different

To facilitate the management of database permissions,SQL ServerSeveral "Roles" are provided, which are security subjects used to group other subjects. They are similar to groups in Microsoft Windows operating systems. The permission scope of a

When you log on to SQL Server 2005, you may encounter an error: 'No process is on the other end of the pipe '. Solution: (1) Open up SQL Server suraface area Configuration tool by clicking Start > Microsoft SQL Server 2005 > Configuration

1. memory usage Classification Categories by Purpose1) database cache (data page ). All pages in SQL Server are stored in 8 KB as one page. When SQL server needs to use a page, it will read the page to the memory and cache it in the memory after

A faulty statement: SQL = "select PWD, answer from [member] Where userid = '" & userid & "' and answer = '" & Answer &"'" You can also make such a low-level error. At this time, you only need to construct a special user name and password based on

I found some information on the Internet, which is suitable for favorites: /****** Export to excelExec master.. xp_mongoshell 'bcp settledb. DBO. shanghu out c: \ temp1.xls-C-Q-s "gnetdata/gnetdata"-U "sa"-P ""' /*********** Import ExcelSelect

Loop result sets using Transact-SQL statements You can use three methods to cycle a result set by using a Transact-SQL statement. One way is to useTemporaryTable. Using this method, you create a "snapshot" of the initial SELECT statement and use

If you first install vs2005 2010 and then install sqlserver, you may find that the installation of Management studio is still not found.   Common online solutions 1. The installation of your sqlserver2005 development edition is incorrect. After