In this tutorial, we are going to learn Case Sensitive Search in SQL Server. Many applications need the functional requirement that they need to make a Case Sensitive Search for example UserName and password. Introduction: The default collation for SQL Server is not case sensitive however it is possible to collation of any column of…
Constraints in SQL Server
Hello Friends, In this tutorial, I am going to explain you about Constraints in SQL Server.Maintaining Data Integrity and accuracy is a big challenge in SQL Server. Here I am going to cover different types of Constraints in SQL Server. After completing this tutorial you will be able to understand following points: Constraints in SQL…
Check Constraint in SQL Server to allow only Alphabates in Column
Hello readers, Here are going to create a Check Constraint in SQL Server to allow only Alphabets in Column. Check Constraint in SQL Server to in the column: Sometimes you face a situation to allow alphabets in columns. This is the real-world scenario. Here I am going to create a Check Constraint that will prevent any…
Create Table Statement in SQL Server
In this tutorial, I am going to explain you about how to use Create Table Statement for creating Database Table in SQL Server. After completing this tutorial you will be able to understand: How to create a table in SQL Server. Create Table if not Exists in SQL Server. Introduction: A Table in a Relational…
Difference between @@IDENTITY, IDENT_CURRENT and SCOPE_IDENTITY
Hello friends, In this tutorial, we are going to see the IDENTITY column in SQL Server. what is the difference between @@IDENTITY, IDENT_CURRENT, and SCOPE_IDENTITY? …