SQL Server

The interconnection of different database platform is commonly called the heterogeneous service of the database, now each big database can realize such heterogeneous interconnection, but the specific implementation technology of each vendor is not

1. View the version of the database SELECT @ @version Several common SQL Server patched version numbers: 8.00.194 Microsoft SQL Server 2000 8.00.384 Microsoft SQL Server SP1 8.00.532 Microsoft SQL Server SP2 8.00.760 Microsoft SQL Server SP3 8

You must have encountered a time-triggered event while you were programming, there are timer controls in VB, and there is no ASP, if you want to constantly query the database to wait for a return result, I think you must know, it will consume a lot

SQL Server temp tables are often needed, and here's how you can use SQL Server temp tables to troubleshoot problems that prevent users from recurring logins for your information. When we develop business software, we often encounter the question of

Data Type type Description Bit Integral type The bit data type is an integral type, and its value can only be 0, 1, or null. This data type is used to store data that has only two possible values, such as Yes or no, True

server| Solution Database operation deadlock is unavoidable, this article does not intend to discuss how deadlocks are generated, the focus is to resolve deadlocks, through SQL Server 2005, now seems to have a new solution. The following SQL

This article introduces the 10 features of SQL Server 2005 database management and analyzes the benefits of its application. 1. Database Mirroring The new database mirroring method is used to extend the performance of record file transfer. You will

Microsoft's next-generation server operating system Lonhorn and Microsoft's Windows Vista support only SQL Server SP2, according to an article in Microsoft's official website. Microsoft says this is done to provide customers with more secure

This article discusses some of the new features of SQL Server 2005 that will help you create a new type of database application. The way database development is changing as Microsoft SQL Server, the release of Beta 2, is released. As a database

Converting a MySQL database to a SQL Server database, or converting a SQL Server database to a MySQL database, is often used in NT environments. Using MySQL ODBC is easier, you can use the SQL Server7 management tools, you can use the MySQL

Myth #30:30 Misconceptions about Backup It's all wrong. Before starting a misunderstanding about backup, if you are not aware of the basics of backup, see my previous article in TechNet Magazine: Understanding SQL Server Backups. 30-01) backup

A cube is a special kind of database that, in its default mode (MOLAP), aggregates data from fact tables and dimension tables in a data warehouse into a separate set of file systems. Aggregated data is improved in statistical performance and allows

Environment: SQL Server 2008 R2 Problem: The update or insert of the view or function ' XXX ' failed because it contains a derived domain or a constant field to resolve To create a view command: Create View D_s_g (Sno,avg_grade) as select

Obtain the version number of MS SQL Execute master.. Sp_msgetversion Get Hard Drive File information Parameter Description: Directory name, directory depth, whether to display files execute master..xp_dirtree 'c:' execute master..xp_dirtree 'c:',

Invalid SQL Server error 9003:LSN (invalid log scan number) Today, I got a problem database file and log file from my friend, and when I use sql2000 and sql2005 to attach the database, SQL Server error message: "The log scan number (2806:120:1) of

The logical design of logical database and table design database, including the relationship between table and table, is the core of optimizing the performance of relational database. A good logical database design can lay a good foundation for

When any new software is released, you will find new features that you don't know it exists or that you don't know you need. Many of the features of backup and storage in SQL Server 2000 remain intact in SQL Server 2005, but there are some new

In a database in SQL Server 2005 or earlier, a table variable is not a parameter to a stored procedure. When multiple rows of data to SQL Server need to send multiple rows of data to SQL Server, developers either send a list of records each time, or

As a database administrator for billing applications (DBA), the company's chief information Officer (CIO) often invites me to meet with Sarbanes-oxley reviewers to discuss the security and consolidation of corporate data. Simply put, he wants us to

Brief introduction I recently participated in a project to migrate a Sybase database to Microsoft SQL Server 2000, and my experience with this project will help the Sybase database administrator migrate the Sybase database to the SQL Server 2000