SQL Server

If object_id ('[tmp_processinfo]') is not null drop table [tmp_processinfo] Create Table tmp_processinfo (finterid int, fname varchar (255) -- insert tmp_processinfo -- select 0, 'A' Union all -- select 1, 'B' -- select * From tmp_processinfodeclare

-- Test declare @ sname varchar (20) Declare dd cursor for select sname from sopen DD. you need to determine whether the cursor exists select * from master. DBO. syscursors where cursor_name = 'dd' -- perform the following operations to check

How to connect to a SQL Server 2000 named instance with JDBC View products that this Article applies. Article ID : 313225 last review : July 2, 2004

Database environment: SQL Server 2005 + 1. Replication. We often use transactional replication. Supports one-way and two-way data synchronization. Work at table level. Because it is based on transaction (the method similar to snapshot chain is

After two days of searching and practice, I finally had a rough understanding of-how to synchronize the data of the two SQL servers. Instead of writing SQL statements, you can use- Forced subscription enables Database Synchronization. Large amounts

For XML Path some people may not know. In fact, it shows the query result set in XML format, with this feature, we can simplify our query statements to implement some work that may previously need to be completed through the function live storage

First, place the file to be restored in the data file in ms SQL, and enter the ms SQL master database server. 1. We use the default method to create a database for recovery (such as mhdyf2005 ). It can be created in SQL Server. 2. Stop the

identity) column, which is also called an auto-increment column. in SQL Server 2000, the identity column is defined by identity, the following is an example of a function related to getting the id value of the last inserted record SQL Server, you

In the previous article, a function is used to convert a string into a table based on a specific separator. How can I implement this Article in turn? Many people will think of a cursor loop table to achieve the goal. It is true that this can achieve

Porting a SQL Server Reporting Services 2005 report directly to PDF or Excel exporting a SQL Server Reporting Services 2005 (SSRS) report directly to PDF/Excel is a handy way of generating high quality reports without being stuck to using the

1. Use microsoftoledbproviderforodbc to connect to MySQL   Install MySQL ODBC driver myodbc   1. Create an ODBC data source for MySQL. For example, set database to test and data source name     Mydsn   2. Create a linked Database

We often spend a lot of time writing entity classes, data entity classes, and business classes when doing small websites. After these things are done, we can only engage in the UI and specific services. It is a bit oily. Although there are some

Create an SQL Server table:Create Table [Table name]([Automatic number field] int identity (1, 1) primary key,[Field 1] nvarchar (50) Default \ 'default value \ 'null,[Field 2] ntext null,[Field 3] datetime,[Field 4] Money null,[Field 5] int default

Log parser is a good IIS log analysis tool that has been used for a long time. It mainly summarizes IIS logs and reports. However, it has never been used to completely import IIS logs to the database. In the past two days, the company needs to

SQL Server backs up database Stored Procedure scripts and supports complete and differential backup 1 -- ========================================================== ===== 2 -- Author: Shu mu 3 -- Create Date: 2011-02-15 4 --

From: http://support.microsoft.com/kb/307487/zh-cn This article discusses three methods to shrink the tempdb database to a size smaller than the size configured last time. The first method allows you to fully control the size of the tempdb file,

Carriage returns and line breaks in sqlserverTab: Char (9) linefeed: Char (10) carriage return: Char (13)1. Use the varchar value as a condition to query the value of the where ID in listDeclare @ A varchar (100)Set @ A = '56, 58'-- Correct:Select *

  A few days ago, due to an exception, the database directly deleted the table records without backing up. Afterwards, you need to query the content of the deleted record. Therefore, online softwareSSAfter half a day, I foundLog exlorer for SQL

-- View table attributesSelect * From sysobjects where [name] = 'core'-- UsageIf exists (select * From sysobjects where [name] = 'region' and xtype = 'U ')Drop table Table1GoCreate Table1 () -- Get all user tablesSelect name from sysobjects where

SQL Server sorting rules are usually not used many times, and many beginners may be unfamiliar, but some A common error occurs when you query a database that is connected to multiple tables in different databases. If the default Character Set of the