SQL Server

Then we last the "step-by-step Learning sqlserverbi--Multidimensional Database Building", now we have a multidimensional database, and there are already data, then quickly enter the topic of our programmers. Today I want to develop two applications

SSIS is not only an ETL tool, but it's very powerful. Take its WMI data Reader task and the event watcher task to get even a lot of information about the operating system. Windows Management Specification (Windows Management Instrumentation) is one

This article supporting source code Let's start with SSIS and use SSIS to export data from SQL Server. First, open Vs.net 2005, select the Business Intelligence project, then select the Integration Service project in the template and enter the

Considerations for optimizing your database: 1, key fields to establish the index. 2. Using stored procedures, it makes SQL more flexible and efficient. 3, backup the database and clean up the garbage data. 4, the SQL statement syntax

A CLR user-defined function is simply a static method that is defined in a. NET assembly. The CREATE FUNCTION statement has been extended to support the creation of CLR user-defined functions. 1. Create DATABASE project 2. Add user-defined

SQL Server 2000 makes it easier to export data in XML, but it can be cumbersome to import and process XML data in SQL Server 2000. If you refer to the books Online (BOL), you will find relevant entries, including OPENXML and OPENROWSET. All of

The case may be one of the most misused keywords in SQL. Although you may have used this keyword before to create a field, it has more usage. For example, you can use the case in the WHERE clause. First let's take a look at the syntax of the case.

There is no doubt that many e-commerce sites have experienced a high number of vacation visits. For example, the 1-800-flowers.com company (1-800-flowers.com website) has had a dramatic increase in orders on Valentine's Day, Mother's Day, Christmas,

You cannot create an identical user and mapping the user to the database, and you cannot delete the database user: DemoUser. Please run the following script and then you can delete the user: DemoUser. Then create the user (DemoUser.) and mapping to

server|sqlserver| Tips There are table TableA as follows:-----------------------------------------------------ID, type, countnumber, countDate1 a 10 2005-02   -01 21:23:342 B 8 2005-02-01 21:23:343 C 5 2005-02-01 21:23:344 B 4 2005-02-01 11:23:345 C

server|sqlserver| problem SQL Server FAQ Response All rights reserved ©ashuixu reprint please remain complete and indicate the source

Each SQL Server developer has its own preferred method of action. My method is called molecular inquiry. These are queries that are grouped together by atomic queries, through which I can process a table. By combining atoms together, you can build

server| Data | database Method One: 1. Stop the source database, copy the database two physical files (MDF, LOG) to the destination. 2. Open the Enterprise Manager of the destination SQL Server database and attach the database file as a local

server| Backup | timing | data | Database backup to server data is a hassle, if daily or often manual backup is a painful thing. Here I introduce a way to set up automated backups via SQL Server job scheduling: 1, into Enterprise Manager->

As an extension of the XQuery language, XML DML provides greater flexibility for XML data operations rather than simply querying the XML data. With XML DML, users can insert, update, and delete node contents in XML as they do with relational tables.

server|sqlserver| Paging There are three ways to pagination with SQL and Oracle databases! Let's take a look at how the two methods are implemented if we want to get data from 1000th to 1010th in the database. 1. Methods of using temporary

This article outlines how to take advantage of the new Service Broker features in SQL Server 2005 to speed up and simplify the development of SQL Server applications based on asynchronous queued operations. (Note that in the sample file, the

server| Cursors How to use cursors: Use DB1 Declare my_cursor cursor Scroll dynamic/*scroll indicates that cursor pointers can be moved at will (otherwise only forward), and dynamic means that cursors can be read or written (otherwise cursors are

server|sqlserver| programming 1. Remove the data you just inserted (delete) Select field name from INSERTED (DELETED) 2, for update is actually first delete and then insert so if you want to get update before and after the data value, you should

Environment: MySQL Sever 5.1 + SQL Server 2008 R2 Problem: The difference between MySQL and SQL Server in inserting data First look at two pictures: Mysql: Sql server: Create a table in MySQL, the primary key is growing, when inserting data,