sql server split string

. NET SQL Server Connection string syntaxThe connectivity of the database has evolved into a standard aspect of application development. The database connection string is now a standard requirement for each project. I found myself in order to find the syntax that I need, I often have to copy the connection

("Adodb.connection");Third, the connection string (all connection strings are case insensitive, and the keys and values are not distinguished)：Provider=sqloledb.1//The key is used to indicate the database type that provides the database service, and the value is not the same for different databases. Other types please refer to: http://www.w3school.com.cn/ado/prop_conn_provider.asp Integrated security/trusted=true[yes,no,false,sspi]//when the key is y

, insert string)In a string, delete the character of the specified length and insert a new string at that location;ExampleSELECT STUFF (' ABCDEFG ', 2, 3, ' small movers ')Return: a small porter EFG7. Replace (Specify string, string to be replaced,

Tags: SQL Server Multi-table search stringSQL Server Multi-table search stringWe described a number of SQL Server articles earlier, today we mainly introduce the SQL Server under the co

Tags: style class code C TAR extIn SQL Server, where fuzzy matching strings are often used, the simplest way is to use the LIKE keyword (like syntax http://msdn.microsoft.com/en-us/library/ms179859.aspx). But if we use the method of adding percent before and after, there is no way to use the index for fast query, so in many cases we use the left matching way. The most common example is in the search box, th

: abxxxfghixxx Stuff () function:Similar to replace. For more information, see instance.Syntax: stuff (Eg: select stuff ('000000', 123456789, 'aaa') Result: 1aaa56789 4. ltrim/rtrim: Delete spaces on both sides of the string. ltrim Delete left. rtrim Delete right.5. Reverse:Returns the reverse of the specified string. eg: Select reverse ('SQL

: DATALENGTH (expression) return value: If the expression data type is varchar (max), nvarchar (max), or varbinary (max) data type, the bigint is returned, otherwise int is returned. Example: Select Datalength (' I am a pawn ') --Output of the ten Select Len (' I am a soldier ') --Output 5 Select datalength (' ABCDE ') --Output 5 Select Len (' ABCDE ') --Output 5 　　22, SOUNDEX Returns a four-character code (SOUNDEX) that evaluates the similarity of two strings. Select SOUNDEX (' ABCD

. Resetting the connection string will reconfigure the values of all connection strings, including passwords. The default value is pseudo. Pooling (pool): Determines whether connection pooling is used. If the value is true, the connection is obtained from the appropriate connection pool, or, if necessary, the connection is created and then added to the appropriate connection pool. The default value is true. User ID (User ID): The name of the account

There is a news data table tb_news, which has the news_id int and news_type int fields. The former is the primary key and the latter is the ID of the news topic. The requirements are as follows: Given a string a_right, the string contains multiple news topic ID values, namely news_type, and the storage format is 'B' + news_type + 'V ', IDs are separated by commas, Example: b1v, b2v, b3v ...... Now we

corresponding to the ASCII code numberChar (integer_expression) integer_expression an integer between 0 and 255. If the integer expression is not within this range, a NULL value is returned.Select Char (72)Returns a Unicode character that returns a specified integer codeNCHAR (integer_expression) integer_expression a positive integer between 0 and 65535. If a value beyond this range is specified, NULL is returned.Select NCHAR (1000)Returns a Unicode string