SQL Server

Locking, Blocking and Deadlocking in sql server

Lock vs Block vs Deadlock Have you ever asked to differentiate lock, block and deadlock in sql server during your interview session? In this article we are going to differentiate these frequently confused terms – Lock, Block and Deadlock. So lets have a look on “Lock vs Block vs Deadlock” These terms sound the same

Locking, Blocking and Deadlocking in sql server Read More »

Allow only alphanumeric characters in a column

One of my colleague asked me a question that how to “allow only alphanumeric characters” in a column. Below is the exact question: How can i stop accepting any non-alphanumeric characters during DML operations in a column of a table? To achieve this, we can follow below steps. There may be more different ways other than

Allow only alphanumeric characters in a column Read More »