SQL Server provides some SQL Functions to manipulate the table result data. SQL Server Min() Function allows to retrieve the table result set based on the condition of smallest / low value SQL Server Max() Function allows to retrieve the

SELECT SQL Query is used to retrieved the result data from the SQL Server Database Table stored in the form of rows and columns. Lets see the different usage of SELECT SQL Query for data retrieval. Consider the below table

We have learnt about the UNIQUE and Primary Key values for the columns in our previous blogs. http://oracleappshelp.com/2020/04/22/sql-server-unique-not-null-constraint-in-table/ http://oracleappshelp.com/2020/04/23/sql-server-primary-key-foreign-key-constraints-in-the-table/ The Primary Key which is a UNIQUE field value needs to be inserted everytime when a record is inserted into the

We have gone through the blogs to understand the Creation of Tables , Constraints to be applied, data to be inserted but it is also important to understand how the data retrieval will happen when you have thousands of lakhs

The SQL Server Table might contain multiple fields but for the data Retrieval we need to consider an UNIQUE key through which the complete record row(s) can be fetched. The SQL Server RDBMS provides the concept of Primary Key (Unique

We have covered the overview related to SQL Server Constraint in the blog – http://oracleappshelp.com/2020/04/22/sql-server-constraints-in-the-table/ Lets discuss each constraint in Detail SQL Server NOT NULL Constraint The SQL Server NOT NULL Constraint is applied on the Column level in the

A SQL Server Database could have multiple tables and each table that has to be stored based on some rules. These rules are the possible checks & conditions which allows you to ensure the data validations before it is being

We have learnt How to Create SQL Server Database in previous blog –http:// http://oracleappshelp.com/2020/04/21/sql-server-database-operations/ Now , lets see how we can CREATE TABLE in our user defined database oracleappshelpDB. Lets consider we need to store the online users for the

The Single user mode could be enabled for the user defined database. Lets see what could be the available options for you as a DBA Administrator for enabling single user mode. While enabling this feature ensure that multiple users are

There could be a requirement where as a DBA Adminitrator you have been asked to increase the size for the existing SQL Server Database. The below options can be used for increasing SQL Server Database size. Increase SQL Server Database

The blog provides the how to Create SQL Server Database, how to Select Database, How to Drop created Database in the MS SQL Server. SQL Server Create Database MS SQL Server provides various Database operations for which a SQL Server

The SQL Server also known as MS SQL Server is a Relational Database Management System, developed by Microsoft. The tutorial provides the conceptual level details from basic to advanced SQL Server. Microsoft SQL Server is a software which can be