SQL Server

The default datetime format for ms SQL Server Chinese edition is yyyy-mm-dd hh: mm: ss. mmmLong/short Date FormatCopy codeThe Code is as follows:-- Short Date Format: yyyy-m-dSelect replace (CONVERT (varchar (10), getdate (), 120), N'-0 ','-')--

SQL Server provides a system data type set that defines all data types that can be used with SQL Server. The following lists the data type sets provided by the system.You can define a user-defined data type, which is the alias of the Data Type

In actual work, especially in the production environment, the optimization of SQL statements is very important, and it also plays a significant role in improving the database performance. we are always complaining about machine performance problems,

SQL Server basic functions1. String function length and AnalysisDatalength (Char_expr) returns the number of characters in the string, but does not contain spacesSubstring (expression, start, length ).Right (char_expr, int_expr) returns int_expr

GUID (Global unique identifier) is a globally unique identifier, which consists of the ID numbers on the NIC (each Nic has a unique ID number) and a 16-byte binary value generated by the unique number of the CPU clock.The GUID format is

Ms SQL performance is very good, but the database has been used for a period of time, the database has become very large, the actual amount of data is not large. It is generally caused by database logs! The growth of database logs can reach several

1. String FunctionsLength and AnalysisDatalength (Char_expr) returns the number of characters in the string, but does not contain spacesSubstring (expression, start, length ).Right (char_expr, int_expr) returns int_expr characters to the right of

Copy codeThe Code is as follows:Create procedure sp_pageQuery@ Sqlstr nvarchar (4000 ),@ Page_index int,@ Page_size int,@ Rec_count int out --AsSet nocount onDeclare @ cursor_id intDeclare @ rowcount intExec sp_cursoropen @ cursor_id output, @

I have provided many articles on the Internet for sending mails from sqlserver. Most of them are reprinted. Most of them are about the win2000 + outlook2003 environment. It is of little significance today when the operating system and office have

Aggregate functions such as SQL max can only perform n-row operations on the same column. If n-column operations are performed, the case statement is generally used for determination. If the number of columns is small, it is easier to write, if

1. Export data from SQLServer Run BCP:Bcp "..." queryout "F: \ test.txt"-c-S1.2.3.4-Usa-P1111Command parameter description:(1) import.This operation is completed using the in command, followed by the file name to be imported.(2) Export.This

PersonAreIn useSQLHourOften fall intoIncorrectArea, that is, tooOffNote on the obtainedEndIf they are correct, they are ignored.ImplementationMethodRoomPossible performance differences,ThisPerformance differences between large orComplexDataLibrary

Paging:Copy codeThe Code is as follows:/* Query data by page */Create procedure [dbo]. [GetRecordSet]@ StrSql varchar (8000), -- Query SQL, such as select * from [user]@ PageIndex int, -- query the current page number@ PageSize int -- Records

The procedure is as follows: 1. First, of course, we need to design the package in Business Intelligence and debug it. 2. There are two ways to run the SSIS package using commands in SQL Server. The first is to directly execute the ssis package file.

The concept of virtual inheritance is proposed mainly to solve the problem of C ++ multi-inheritance. The simplest example is as follows:Copy codeThe Code is as follows:Class animal {Public:Void op (){Cout };Class tiger: public animal {Public:Void

Create two tables:Table 1: student:Table 2: course:(In this case, the table is created to demonstrate the connection to the SQL statement. Of course, we will not create the table in actual development. In actual development, the two tables will have

For new users who are new to SQL databases, there are many questions about SQL versions, but they are too lazy to study them carefully. Although the problem is simple, the impact is not small.Version differencesSQL Server 2000 has four editions:

Create proc sp_PublicTurnPageWebSite (@ TBName nvarchar (100) = '', -- table name, such as pinyin@ PageSize int = 10, -- number of records per page. The default value is 10.@ CurPage int = 1, -- indicates the current page 1@ KeyField nvarchar (100) =

Generally, you need to obtain the current date and calculate some other dates. For example, your program may need to determine the first or last day of a month. Most of you probably know how to divide a date (year, month, day, and so on ), then,

Copy codeThe Code is as follows: use masterDeclare @ dir varchar (256), @ dir_db varchar (256 ),@ Verb varchar (256), @ cmd varchar (256 ),@ Backup_name varchar (256), @ dynamic_name varchar (10 ),@ Disk_name varchar (256)-- Establish a network