SQL Server

Enterprise Manager-- Manage-- SQL Server proxy-- Right-click a job-- Create a job-- Enter the job name in "general"-- "Step"-- New-- Enter the step name in "Step name"-- Select "Transact-SQL script (tsql)" in "type )"-- "Database": select the

I. Split line use SQL:I have a table like thisId commaseperatedstring1 A, B, C, D, E2 x, y, zWhat I want is to convert thisId text11 B1 c2 x2 yLike this. Answer:SelectT. ID, right(left(t.csv, number-1 ),Charindex(',', reverse(left(','{t.csv,

when setting up a private server, two servers are often used for load balancing. Some people often ask me how to do this, today, I will send out the method of this dual-host load for you to learn. 1. set the client network utility click "start"-"

Introduction to locking in SQL Server Http://www.sqlteam.com/article/introduction-to-locking-in-sql-server   SQL Server also has an object called latch. SQL Server provides a performance counter to monitor a resource lock called latches in SQL

1. Create a stored procedure Create proc Stored Procedure name [Parameter list (multiple parameters are separated by commas (,)] As SQL statement Example: Create proc upgetusername @ Intuserid int, @ Ostrusername nvarchar (20) Output

/* Author: Jiangong sun */ I 've made a web site prototype these days, I 've found there are some useful information to share with you about some usual problems about users. 1/how to create a user and give it rights to access a

From: http://51even.iteye.com/blog/1490412 Introduction   In SQL Server, indexes are enhanced, which means that SQL server can still implement its functions even if there is no index. However, indexes can greatly improve query

Understand the concept and principle of Indexing in SQL Server From: http://51even.iteye.com/blog/1490412 Introduction   In SQL Server, indexes are enhanced, which means that SQL server can still implement its functions even if there is no index.

There are many methods to capture blocking information. Several types are listed here. And analyze the advantages and disadvantages of each type. So that we can choose. Before enumeration, let's briefly demonstrate blocking. First, create a test

SQLIn the group aggregation operation, why are other expressions included in the group by clause in the query column apart from the aggregate function operation? Reward score: 10 | resolution time: | Questioner: ristal11 Hope you can advise Best

What do you do if you want to analyze data in the database at a specific time? For example, what measures do you take if you want to analyze the data at pm? The most frequently used method is to create a scheduled task, perform a backup at, and back

SQL Server 2000 SP4 Enterprise Edition Lite version 8 M I used to download a lite version from the Internet, but I had to install too many things to destroy the original SQL on my machine. I modified my green SQL that I had been using some days ago,

In SQL Server, You need to delete some data in a large data table Table1 (more than 10 million records). If you use the delete method, the execution usually times out. You can use the following method: Select the record you want to keep to the new

In the previous article, performance tuning of SQL Server: memory management of resource management (I) introduces some theoretical knowledge about memory management of SQL Server, this article uses this knowledge to solve some common problems in

In the query analyzer, perform the following three steps in sequence, where databasename is your database file name 1. Clear logs: dump transaction databasename WITH NO_LOG 2. truncate transaction logs: backup log databasename WITH NO_LOG 3. shrink

This article is about how to full backup the SQL Server 2005 database. this solution uses the SQL Server Agent to start a job with schedule to fullback it automatically. it always have 7. bak files in recent 7days. the schedule is 2: 00 am every day.

There is a ROW_NUMBER function in SQL Server2005, which will number each row returned by the SELECT statement starting from 1 and assign it a continuous number. After a sorting standard is applied during a query, the sequence can be consistent only

This article describes how to import the data table structure designed in SQL Server to PowerDesigner. I use SQL Server 2005 and PowerDesigner15.1. First, enable Powerdesigner15.1, as shown in, Double-click PowerDesigner to open the software.Create

In the past, system permissions or status were expressed by different fields or a permission string to indicate combined permissions. A few days ago, when developers of the tax department developed a system together, it is found that they use an int

There are can use to iterate through result set by using Transact-SQL statements three methods. One way is to useTemporaryTable. Using this method, you create a "snapshot" of the initial SELECT statement and use it as the basic "Pointer ". For