SQL Server

If exists (select * From sysobjects where name = 'webname') Drop table stuwebnamegocreate table stuwebname (stuid int identity (1, 1) primary key, stuname varchar (50) not null, stupassword varchar (50) not null, stusex char (2) default ('male'),

It is a regular issue to narrow down the MSSQL log file. However, there are already many answers to this question in the essence area. I will not go into details here. Now let's discuss the permanent problem, that is, how to make the log file no

The method is actually very simple: you need to nest an access connection in the SQL server connection, and then one by oneWrite. Conn. Open "driver = {SQL Server}; server = mamaco; uid = linner; Pwd = 123; datAbase = linner"SQL = "select * From

(1) error_number (): number of returned errors. (2) error_severity (): returns the error severity level. (3) error_state (): returns the error Status Number. (4) error_procedure (): returns the name of the stored procedure or trigger with an

SQL Server 2000 has three similar functions: scope_identity, ident_current, and @ identity. They both return values inserted into the identity column.1) The ident_current method returns the last generated id value for any session and a specific

Table: Create Table Category ( Id int, Name int, Parentid int ) Recursive upwards: 　Code Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->Create Function [DBO]. [getrootcategoryid] /* Author:

1. Handle deadlocks and set deadlock priority A deadlock occurs when multiple users apply for different blockages. The applicant has part of the blockages and waits for the blockages of other users. Set deadlock_priority can be used to control the

I. Preface   I plan to write some ideas about SQL server performance tuning in the near future, that is, it is too complicated to give a clue. when we write SQL statements, design tables, create DBAs, or create projects, there will be many

I. Introduction In terms of processing performance, DBA tends to focus on the system technical level, such as resource queue, resource utilization, and system loading. However, users only consider performance issues as waiting. They send a request

Takeaway:Table locking hints provide developers much tighter control of their transactions. Look at the benefits and disadvantages of using the nolock and readpast table hints in SQL Server. When data in a database is read or modified, the database

Cross apply and outer apply are similar to join. They are mainly engaged in M * n Cartesian sets. The obvious feature is that on joins are not used. It is also reasonable to think about it. The application scenario should meet the join constraint,

Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->1 create procedure testtran 2 3 4 5 declare @ userid int 6 7 set nocount on 8 9 begin Tran adduser 10 11 insert into testtable (username, password,

I visited the wooden study and reviewed char, nchar, varchar, and nvarchar, So I recorded it and hoped to share it with others, so that I could easily query it later. Of course, this is not plagiarism. 1. CHAR: it occupies 1 byte for English (ASCII)

  SilentSQL Server 2005There are two possible steps for installation: 1)CreateSetup. iniFile The template file contained in the SQL Server CD is called template. ini. Create another required ". ini file". This file contains a single [Options]

Reset the field value of the ID columnFor example, DBCC checkident (tablename, reseed, 1); sets the ID seed of tablename to 1.   The following is an explanation of msdn: DBCC checkident(Table_name[, {Noreseed | {reseed [,

Data integrity is any DatabaseThe focus of the system. No matter how well the system is planned, the problem of NULL data values always exists. This article discusses SQLThree problems involved in processing these values in server: Count, use empty

First, create a table and add data. Expected results -- Method 1 select distinct C. [user_name] As 'name', (select score from test_tb_grade where [user_name] = C. [user_name] and course = '') as '', (select score from test_tb_grade where [user_

1. Call the stored procedure without input/output parameters Create procedure testproc As Select pub_id, title_id, price, pubdate From titles Where price is not null Order by pub_id Use the following program to call this stored procedure. When

Operator priority When a complex expression has multiple operators, the operator priority determines the order of Operation execution. The execution sequence may seriously affect the obtained values. Operators have the following priority levels.

Concept of Replication Microsoft? SQL Server? 2000 of replication is a group of technologies that replicate, distribute, and synchronize data and database objects between databases to ensure consistency. Data can be distributed to different