SQL Server

C: \> osql /?Usage: osql [-u Login ID] [-P Password][-S server] [-H hostname] [-e trusted connection][-D use database name] [-l login timeout] [-T query timeout][-H headers] [-s colseparator] [-W columnwidth][-A packetsize] [-e echo input] [-I

1. Clear logsDump transaction dbname with no_log 2. truncate transaction logs:Backup log dbname with no_log 3. Shrink database filesEnterprise Manager-> right-click the database you want to compress-> all tasks-> shrink database-> shrink File--

How to batch insert multiple data entries into a database data table? Use sqlbulkcopy, for example: /// /// Batch import data to the database /// /// Data source table /// Database Table Name /// Database connection string ///

I am often asked by professionals: Is checkdb still recommended in SQL Server 2008? Calculate the checksum from SQL 2005 to prevent physical page corruption. However, in my experience (since SQL Server 7.0), I have never clearly indicated that

SQL Server query performance optimization-analysis of transactions and locks (2)   Next let's take a lookSp_who2If you query the stored proceduresSource code, You can find that the storage process of this system is organizedMaster. SYS.

Tools: SybasePowerdesigner 12.5 Microsoft SQL Server 2005 Step 1: Conceptual Data Model OpenPowerdesignerSoftware, design"Conceptual Data Model"(Conceptual Data Model)It is usually used in the outline design stage. Design table

1. How to get the ID of current inserted record? Using @ identity keyword. e. g. create Table Table1 (ID int identity (1, 1) not null, name nvarchar (64) goinsert into Table1 ('Hello World') goselect @ identity2. how to cleanup SQL Server plan cache?

View 1. What is a view? A view is a virtual data table. The data records in the data table are obtained by a query statement.   2. Create a view Criterion To create a view, consider the following guidelines: # View names must follow the

AlgorithmIt is an important research direction in computer science and the key to solving complex problems. Algorithms are everywhere in the computer world. A database is a place for storing data and performing mass computing. It is not uncommon to

A few days ago, I was learning how to operate databases in C. There has been no problem. However, after re-installing SQL Server2000, I found that it was not usable when I was writing a connection to the database. Conn. connectonstring = "Server =

1. UseProgramTo minimize the number of accesses to the database. By searching for parameters, You can minimize the number of rows accessed to the table and the result set, thus reducing the network burden; separate operations should be processed

You may be familiar with the top keyword usage, but do you know whether the top query returns a table result or a cursor? When the top clause is used, the same order by clause assumes the role of determining the logical priority of the rows for

After one year of work, I always felt that I was missing something. Among them, I feel the strongest about SQL Server, so now I start to learn again. Click to download the database script. See the following SQL statement. 1 Select Custid,

See sp_renamedb and sp_rename in SQL Server books online1. Change the Database Name Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--> Sp_renamedbChange the database name. SyntaxSp_renamedb [ @

First: Formulation of scheduled jobs 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

SQL Server Stored Procedures and C # paging class simplify your code! The following is the Stored Procedure (passed under sqlserver2000) -- The most common paging Stored Procedure-- Get data on a specified page Create procedure Pagination @ TblName

-- Create the following User-Defined Function (UDF) Create function StrComp (@ Str1 VARCHAR (50), @ Str2 VARCHAR (50 ))-- Alter function StrComp (@ Str1 VARCHAR (50), @ Str2 VARCHAR (50 ))RETURNS INTEGERASBEGINDECLARE @ I INTEGER-- DECLARE @ Str1

Create a database. The user must be sysadmin or dbcreator. 1. The simplest syntax is create database USER2. 2. create database USER8ON(NAME = 'user8 _ dat ',FILENAME = 'C: \ mssql7 \ data \ User8dat. mdf ',SIZE = 10,MAXSIZE = 50,FILEGROWTH =

1. Right-click the database to which logs are cleared, such as "TestDB", and click [new query (Q)]2. Enter the following SQL statement. "TestDB" indicates the database name. Dump transaction TestDB WITH NO_LOG 3. Execute the SQL statement. After

I got a good MSDN help: Embedding SQL Server Express into Custom Applications It introduces methods to deploy by a class wrapper. (Usually, we create a setup project and add SQL Express as prerequisite to deploy) And it also gives an idea to embed *.