SQL Server

The script that implements the string Decomposition Method in SQL Server is as follows: Create Function [DBO]. [fn_splitstr] (@ sourcesql varchar (max), -- string @ strseprate varchar (10) -- Characters Used for decomposition) returns @ temp table

Sysaltfiles: files stored in the database in the master database Syscharsets primary database character set and sorting order Sysconfigures master database configuration options Current configuration options of the syscurconfigs master

Transaction logs are very important but often ignored in the database structure. Since it is not as active as the schema in the database, few people are concerned about transaction logs. Transaction logs are records of database changes. They can

ArticleDirectory Syntax SQL Server convert () function   Definition and usage The convert () function is a general function that converts a date to a new data type. The convert () function can display date/time data in different

SQL Server2000 cannot be enabled without installing the SP4 patchProgramThe TCP 1433 port is bound to 0.0.0.0 (all IP addresses), but only the IP address obtained by the physical network adapter bound to the LAN. Therefore, when the connection fails,

The purpose is to view the system (ApplicationProgram+ Database) Performance of calling SQL stored procedure stored procedures and SQL statements. How slow is it? Which Stored Procedure consumes the most time? Sometimes when you set several

Various Stages of SQL Server Query Processing SQL is different from otherProgramming LanguageProcessing is the most obvious featureCode. In programming languages with large numbers, the code is processed in the encoding order, but in SQL, the

= Generate a random number in the number range = -- Create a view Create view myview as select Re = rand () -- Custom function: gets a random number within a specified range.Create Function mydata (@ A int,@ B INT)Returns decimal

An error occurred while restarting the SQL Server database. An error is reported using an additional method. The method of replacing files with common files on the Internet, changing the emergency status, single-user mode, and dbcheck fails. Major

When using SQL Server 2000 to automatically generate SQL scripts, there are some special keywords. I didn't care much about them before, and I didn't remember which one to check and which one to use, this is a simple list (for more information, see

In the database development process, you have to consider the concurrency issue, because it is very likely that when someone else is updating a table record, you read data from the table again, the data you read may not be the data you want. It can

Compared with compression, database partitioning is more complex and cumbersome. In addition, unlike compression, a partition is an operation that requires long-term maintenance cycle change. Partitioning is to physically cut big data into several

1. String function length and Analysis Datalength (char_expr) returns the number of characters in the string, but does not contain spaces Substring (expression, start, length ). Right (char_expr, int_expr) returns int_expr characters to the right of

// Write the image to the databasePrivate void writeimage (){Sqlcommand comm = conn. createcommand ();Comm. commandtext = "insert into images (image, type) values (@ image, @ type )";Comm. commandtype = commandtype. text;Sqlparameter Param = comm.

A view is also called a virtual table, because the result set returned by the view is in a similar format as a table composed of columns and rows, the method for referencing a view in an SQL statement is the same as that for referencing a table. The

Commands related to SQL server privilege escalation and Prevention Measures ; Exec master.. xp_cmdshell "Net user name password/Add "-- ; Exec master.. xp_cmdshell "net localgroup administrators name/Add "-- ProgramCodeEnable the SQL statement

SQL Server Index Structure and usage (III) General paging display and storage process for small data volumes and massive data Creating a web application requires paging. This problem is very common in database processing. The typical data

1: Add fields to the table Alter table [Table Name] Add [Column name]Type 2:Delete Field Alter table [Table Name] Drop column [Column name] 3:Modify Field Types in a table(You can modify the column type, whether it is null) Alter table

Recently, the walnut network project did not add any data at the time of creation, but the log files were all 10 MB, so we found a compression method. 1. Find the database to be compressed, right-click and click "properties" 2. Select "option" and

You can use the SQL-server Enterprise Manager to create an instance. Pay attention to rpc and rpc out. You can also use SQL statements to complete the definition, which involves three stored procedures. Sp_addmediaserver, sp_serveroption, and