SQL Server-Common Concurrency Problem


Problem Everywhere.. Solution Everywhere..

If two or more transaction is accessing the same resource at same time. There is a problem of concurrency. Lets discuss what are the common problem arises in SQL Server.
1) Dirty Read
2) Lost Update
3) Non-repeatable Reads
4) Phantom Reads

Common Concurrency Problem | Lost update | Academy4Code.com
Common Concurrency Problem |

SQL In-built Functions Part-3


SQL Functions | Academy4Code.com
  • What is SQL NCHAR Function?

NCHAR function returns the Unicode character based on the number_code in the Unicode standard.

Syntax: NCHAR(Number code)

Example:

NCHAR | SQL Function - Academy4Code
NCHAR | SQL Function – Academy4Code

The above query returns the Z character which code is 90 in ASCII.

  • What is SQL PATINDEX Function?

The PATINDEX functions

SQL In-built Functions Part-2


SQL Functions | Academy4Code.com
  • What is SQL Left() Function?

LEFT function allows you to extract a substring from a string, starting from the left-most character.

In simple word left function will be return the string started from left side an Syntax or a string,

Syntax: LEFT (String, Number of characters)

Example:

Left SQL Function- Academy4Code
Left SQL Function-