ltrim rtrim

SQL Server puts used data into the cache to speed up access to the data. If there are no other processes competing, SQL Server uses almost all of the memory until another process needs memory to free up memory. In the case of a small concurrency,

In the initial SQL Server performance issue (2/4), we discussed the list of waiting resources or running session scripts. In this article we will look at how to list blocked sessions with specific information.1 /**************************************

This article introduces several methods for querying the database size in SQL. This article introduces several methods for querying the database size in SQL. First: (cricket) The Code is as follows: Alter table tb

After so many days, we continue to record 4th-records today ~ Chapter 5 ...... 1. String operations and regular expressions * remove null or other characters: trim (), ltrim (), rtrim (), that is, chop (); * use HTML Format: nl2br (), "n" "br" *

Guo hongjun For a very large data model, it is a waste to load the entire data source every time during paging retrieval. The common choice is to retrieve the data in the block area of the page size, instead of retrieving all the data, and then

 Method 1: Select top 10 B. * From (select top 20 primary key field, sorting field from table name order by sorting field DESC) A, table name B where B. primary key field =. primary key field order by. sorting Field 10 = number of records per page 20

Who_am_i () CREATE OR REPLACE FUNCTION who_am_ireturn varchar2is l_owner varchar2 (in); L_name varchar2 (+); L_lineno number; L_type VARCHAR2 (30); BEGIN Who_called_me (L_owner, L_name, L_lineno, l_type); RETURN L_name; END;

Today, I encountered this problem. I asked my friend about the following solutions. I posted the following solutions: (cricket) ALTERTABLEtbALTERCOLUMNcolnamenvarchar (100) COLLATEChinese_PRC_CI_AS -- Case Insensitive

/* ----------------------------------- Generate Forum Catalog Content table process -----------------------------------    */ CREATE PROCEDURE sp_createnew_bbscontent @tabname varchar (200) = ', @boardid int As declare @tri_inst_name nvarchar

Update [Table name] Set [Sex]=( Case when( Left( Right([ID Card],2),1)% 2 = 0) Then 'female' Else 'male' End)where Len([ID Card])= - and Left( Right([ID Card],2),1)<>'X'Update [Table name] Set [Sex]=( Case when( Right([ID Card],1)% 2 = 0) Then

Reprint: http://hi.baidu.com/gagahjt/item/fd081316450f05028ebde413/*First, to divide the string by the specified symbol, return the number of elements after the split, the method is very simple, is to see how many separators exist in the string, and

In the initial SQL Server performance issue (2/4), we discussed the list of waiting resources or running session scripts. In this article we will look at how to list blocked sessions with specific information.1 /**************************************

Automatic detection of the field in the table, both to avoid the deletion of errors, but also to improve the flexibility of the program. /* Author:nyb Time:2003/12/29 Fixtime: AIM: See if there is a field in the table, if so, delete Input: Call:

Original: Initial SQL Server performance issue (3/4): List blocked sessionsIn the initial SQL Server performance issue (2/4), we discussed the list of waiting resources or running session scripts. In this article we will look at how to list blocked

1. ASCIIReturns the decimal number corresponding to the specified character;SQL> select ascii (A) A, ascii (a) a, ascii (0) zero, ascii () space from dual;A ZERO SPACE------------------------------------65 97 48 322. CHRReturns the corresponding

String functions, mathematical functions, date functions, logical operation functions, and other functions String functions, mathematical functions, date functions, logical operation functions, and other functions Single-record functions in SQL 1

Method 1: In my opinion, the best method is to use regular expressions, which is the core principle.Secondly, this method uses the prototype attribute of JavaScript.In fact, you can use functions without using this attribute, but it is more

In fact, you only need to use the built-in storage process sp_spaceused to obtain table-related information.For example, sp_spaceused 'tablename'The following is a stored procedure for writing convenience. The purpose is to store all the information

Single record function in SQL 1. ASCII returns the decimal number corresponding to the specified character; SQLselectascii (A) A, ascii (a) a, ascii (0) zero, ascii () spacefromdual; The AAZEROSPACE------------------------------------659748322.CHR

Here we have added a list of oracle functions that are helpful to ORACLE beginners. If you need them, you can check them out. Here we have added a list of oracle functions that are helpful to ORACLE beginners. If you need them, you can check them