SQL Server

Rand () Definition: returns a random floating point value from 0 to 1. Example: Select rand () as random number result Select cast (floor (RAND () * n) as INT) -- Method 1 Result: 47 Select cast (celing (RAND () * n) as INT) -- method 2

As we mentioned earlier, the stored procedure and view are as follows, Next, let's take a simple look at the while, case, if... else objects in the database. 1 While While is a command object that executes repeated operations based on whether

Currently, I have encountered a situation where I need to extract the first letter of a field in SQL Server, which consists of Chinese characters, English letters, numbers, and "-". Baidu has a bunch, find the following method and record it for

1. Make sure that the following is Enabled: 3 Services: SQL Server (MSSQLServer) SQL Server Reporting Services (MSSQLServer) SQL ServerProxy(MSSQLServer)--- SQLThe proxy service is very important. mail subscription depends on it.  

-- ===================================================== ==================== --ListSQL ServerAll tables, field names, primary keys, types, lengths, decimal places, and other information --Run in the query analyzer.,You can generate a table and

Example of data and workload The following example describes how to use the SQL server performance tool. First, create the following table. Create Table Testtable (nkey1 Int Identity , Col2 Char ( 300 ) Default ' ABC ' ,

The soundex function converts a string to a four-digit number.CodeTo be used in comparison. The vowels are ignored during comparison. Non-letter characters are used to end the comparison. This function always returns a value. The following example

During our investigation, we often wonder where a data comes from. We often use capture SQL statements such as Event Viewer to find out. In fact, we can also use the following SQL statement. However, when the data volume is large, it is indeed slow.

Generally, you need to obtain the current date and calculate some other dates, such as your Program You 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,

SQL Server automatic numbering and comparison. I. UseProgramObtain the database ID. Insert the obtained ID number when inserting the record. Advantage: flexible. Disadvantage: You need to interact with the database twice. When inserting data, you

Original http://www.cnblogs.com/zhenpingwang/archive/2013/04/15/3021979.html 1. Determine whether the database exists If exists (select * From SYS. databases where name = 'database name ') Drop database [database name] 2. Check whether the table

This article from (Baidu space), if there is infringement, Please mail to xiaoqcn@126.com Network Address: Http://hi.baidu.com/followashadow/blog/item/7dd5ce12673ba7876438db77%2Ehtml The following is the Stored Procedure (passed under

Today, I want to copy a database under SQL server2005. The result is an error in the last step. If the replication fails, the database cannot be opened, The "single user" is displayed after the name. It is estimated that it will be automatically

-- Revoke get the qualified name of the given object use pubsgodeclare @ object_id int, @ qualified_name nvarchar (512) Select @ object_id = object_id ('author') exec sp_msget_qualified_name @ object_id, @ qualified_name outputselect @

The IP address of a is 192.168.0.1.The IP address of B is 192.168.0.2.One database in a is Testa, table tablea User: SA, password: SA, 123456 One database in B is testb, table tableb User: SA, password: SA, 123Now we want to export data from

/* Lvl1 lvl2 lvl3 lvl4 LVL4 3 4 13 2 2 12 2 3 44 4 3 43 1 2 2How to WriteCodeCompare the values of each line corresponding to lvl1, lvl2, lvl3, and lvl4, take the smallest value, and add the value to the LVL column.The running result should beLVL11

Not to mention that I am a title party, although you may think that IIS /. net/SQL Server installation may be easier for you than writing "Hello World", but do you develop software for yourself? Should most of them be used by customers? Since it is

--- Lowercase output: abcdefSELECT Lower ('abcdef'); --- uppercase output: abcdefselect upper ('abcdef '); -- remove the left space-> 'abcdef' select ltrim ('abcdef'); -- remove the right space-> 'abcdef' select rtrim ('abcdef '); -- truncates a

ASP. NET backup and restoration of SQL Server databases 1. Backup SqlConnection connection = new SqlConnection (ConfigurationManager. etettings ["Connection"]);String dbFileName = DateTime. Now. ToString ("yyyyMMddHHmmss") + ". bak ";Try{SqlCommand

Ii. Import and export data from SQL SERVER and EXCEL1. query Excel Data in SQL SERVER:-- ===================================================== ====================SELECT *FROM OpenDataSource ('Microsoft. Jet. OLEDB.4.0 ','Data Source = "c: \