Dinesh's Blog :::: Being Compiled ::::

SQL Server handles locks efficiently and it places relevant locks based on the way we access records. If you perform an action such as INS...

Declaration variables and assigning values in different ways is something we see as a very common code in modules like stored procedures a...

Column aliases are commonly used for relabeling columns for increasing the readability of SQL statements. However aliases cannot be referred...