SQL Server

This article supporting source code We have introduced three methods for merging data stream source and database data. That is, the data in Excel and the data in the database to synchronize, the existence of the data to update operations, do not

This article supporting source code We have implemented the import of data from Excel into the data flow target. That's the database, but we just simulate the data that's not duplicated, which is the data that doesn't exist at this time in the

I do the site basically have to use an infinite level of table of contents, used to organize various types of article information. This table has only three fields (Id,parentid,name), which has always been the case with no problems. It was not until

The basic theory of lock used in all kinds of large database is consistent, but it is different in concrete realization. SQL Server is more focused on managing locks by the system. When the user has the SQL request, the system analyzes the request,

Indeed, database maintenance is often given to professional database administrators, but as a developer, you may occasionally need to do this work temporarily. So, try these two SQL Server maintenance tips: Easily change the database owner,

This article explains why you should understand database consistency detection (DBCC), how to run DBCC, and the five extensions that apply to it. Database consistency Detection (DBCC) may be your most important tool in times of crisis. This article

Environment: Development of the Ide:jbuilderx Database used: MS SQL Server 2000 Database driver used: Jsql Driver (JDBC 3.0) Description 1. Hibernate explicitly "Microsoft Driver (not recommended!)" In the configuration file, so use Jsql Driver

server| concept The page is the most basic data storage unit of SQL Server, with 8KB per page in SQL Server, which means that the SQL Server database has a total capacity of 128 pages per trillion data files. Type of page: Data, index, text/image,

server|sqlserver| Backup | compression SQLSERVER2000 Backup Example 1: (Backup) 1 Use Master 2 Declare @path = ' C:\aa\zy.bak ' 3 Backup Database Zy to 4 disk= @path with Noinit Description 1 Using System libraries 2 set the path and filename

Many times, when we plan for the space of the SQL Server database, or to the storage space, we need to estimate the size of the required database space, the simplest way to estimate the future is to look at the past trends, which is often the most

4 levels of SQL code can be found Select menu_id,menu_name,father_id from Sys_menu where menu_id= ' or father_id=18 or--first level, level two father_id in (select M enu_id from Sys_menu a where menu_id= ' or father_id=18 ' or --level three

The author once interviewed the DBA, "Why is tempdb faster than any other database?" So that more than 95% of the candidates have a blank face. As an important feature of SQL Server, tempdb has all along been familiar and unfamiliar to it.

ASP (Active Server Pages) is a very early Web application solution from Microsoft, and a simpler programming environment that most developers of web sites are familiar with. With ASP, we can create powerful dynamic Web applications. Although the ASP

Some time ago, I sent such a problem on the Internet, now has been resolved, and now the code to share, I hope to help intranetmis enthusiasts The approach is simple: you need to nest an access connection in a SQL Server connection, and then write

This article explains how to use the search for left join, CROSS join, and identity values to improve the performance or scalability of a SQL Server based application. The phenomenon you will encounter: SQL queries in your application do not

Building a table To test this example you need a table with data (you can create it in your current library or create a new one), and here's the structure: 　　 Column Name　　 Datatype　　 Purpose　　 ID　　 Integer　　 identity column Primary key　　 IMGTITLE　

As a network administrator, regardless of the size of its management networks is large or small, in the day-to-day management in addition to maintaining the smooth operation of the network, timely removal of network failures, protection of network

This article illustrates the comparison of SQL Server with stored procedures from several perspectives. Why do ① use stored procedures? Because it executes faster than SQL statements. What is the ② stored procedure? With a bunch of SQL

Create　function fun_getPY ( 　　@str nvarchar(4000) ) returns nvarchar(4000) as begin 　declare @word nchar(1),@PY nvarchar(4000) 　set @PY='' 　while len(@str)>0 　begin 　　set @word=left(@str,1) --If non-Chinese characters, return the original character

This paper introduces the storage mechanism and access method of MIS SQL Server for image data. Aiming at the VB development tool, this paper introduces a method of accessing the image data in MIS SQL server by using the GetChunk method of ADO Field