Skip to content

Tag Archives: SQL-Server

Collations in SQL Server provide sorting rules, case, and accent sensitivity properties to data. A collation defines bit patterns that represent each character in metadata… Read More
Alter login statements can be used to changes the properties of a SQL Server login account. Syntax: ALTER LOGIN loginname; GO Enable a disabled login… Read More
The DROP LOGIN statement could be used to delete an user or login that used to connect to a SQL Server instance. Syntax – DROP… Read More
Global variables are pre-defined system variables. It starts with @@. It provides information about the present user environment for SQL Server. SQL Server provides multiple… Read More
A login is an user account that you can use to access the SQL server. Logins are attached to users by the security identifier (SID).… Read More
A database comprises tables and each table in case of RDBMS is called a relation. Let us consider a sample database named University and it… Read More
A schema is a collection of database objects like tables, triggers, stored procedures, etc. A schema is connected with a user which is known as… Read More
Prerequisite – Introduction of MS SQL Server 1. Self Join : Self-join allows us to join a table itself. It is useful when a user… Read More
A database contains many tables that have data stored in order. To delete the rows, the user needs to use a delete statement. 1. To… Read More
We know that a database can different datatypes. Consider an organization having various databases like Employees, Departments, Finance. The employee database has a table that… Read More
1. Fix() Function : In MS Access, the fix() function returns the integer part of a number. In this function, a number will be pass… Read More
1. Max() Function : max() function return the maximum value of given set. In the function a query is passed and in the eligible records… Read More
1. Rnd() Function : Rnd() function return the random number.if we want to generate a number between 0 to 1 then use only Rnd. Otherwise,… Read More
1. Sgn() Function : sgn() function returns sign of a number.if the number is positive then it returns 1 if number is equal to 0… Read More
1. Val() Function : val() function returns the number found in the string. In this function, it takes a string as a parameter and it… Read More