get substring in sql server 2008

SQL advanced (9) functions, SQL FunctionsSQL advanced (9) function syntax built-in SQL function syntax is: SELECT function (column) FROM tableIn SQL, there are several basic function types and types. The basic types of functions are: Aggregate

Recently read a SQL SERVER2010 textbook, by the Way note (PS: This book is not read, so temporarily updated content)! The content for myself to organize, if there are errors, please point out lest affect others ' study.1. Create a table TestDBDROP

Introduction Sp_who2 is a well known utility that shows what spids are currently executing. however the information it shows is relatively limited. for example, it only shows the type of command executing as select, delete etc, with no reference to

With the development of B/S application development, more and more programmers are writing applications using this mode. However, due to the low entry threshold in this industry, the programmer's level and experience are also uneven. A considerable

Since the use of EF rarely write SQL and stored procedures, today need to write a more complex report, turned out the previous notes as a reference, feel this note is still very useful, so sent to share with the park friends.1, Case...end (the

SQL injection attacks and defensesWhat is SQL injection?Simple example, for a shopping site, can be allowed to search, price less than a certain value of goodsThis value can be entered by the user, for example, 100But for the user, if input, 1 ' OR '

Partial finishing ... What is SQL injection?Simple example, for a shopping site, can be allowed to search, price less than a certain value of goods This value can be entered by the user, for example, 100 But for the user, if input, 1 ' OR ' = ' 1

SQL injection attacks and defensesPartial finishing ...What is SQL injection?Simple example, for a shopping site, can be allowed to search, price less than a certain value of goodsThis value can be entered by the user, for example, 100But for the

The index allocation Map,iam page tracks the extents used by an allocation unit in a 4 GB interval. An allocation unit is a set of pages that belong to a single partition of a datasheet or index. It consists of one of the following three types of

Check the code first. You can first read the SQL statement to remove duplicate records and obtain duplicate records.Copy codeThe Code is as follows:ALTER procedure [dbo]. [PROC_ITEMMASTER_GETUNIQUE] @ pageindex int, @ uid int, @ itemnumber varchar (5