A SYNONYM provides another name for database object, referred to as original object, that may exist on a local or another server. A synonym belongs… Read More
Tag Archives: DBMS-SQL
Prerequisite – Introduction of MS SQL Server Databases are a collection of objects like tables, views, stored procedures, functions, etc. In MS SQL Server, two… Read More
1. LCase() Function : In MS Access the LCase() function converts the text to lowercase from uppercase. In this function, a string is passed as… Read More
1. InStr() Function : The InStr() Function returns the position of a string in another string. It always returns the first occurrence of the string.… Read More
There may be a situation where we want to query something that is not from a table. For example, getting the current date or querying… Read More
The UNION operator could be used to find the result-set or combination of two or more tables. Terms and Condition for using UNION : Each… Read More
REVERSE() : This function could be used to reverse a string and find the result. The REVERSE() function takes input parameter as string and results… Read More
SQL UPDATE JOIN could be used to update one table using another table and join condition. Syntax – UPDATE tablename INNER JOIN tablename ON tablename.columnname… Read More
1. CHR() Function : The Chr() function returns the character for the given ASCII number code. The Chr function takes an integer as a parameter… 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
Declare Local Temporary Table statement used to create a temporary table. A temporary table is where the rows in it are visible only to the… Read More
Let us consider the following table named “Geeks” : G_ID FIRSTNAME LASTNAME DEPARTMENT 1 Mohan Arora DBA 2 Nisha Verma Admin 3 Vishal Gupta DBA… 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
Atn() Function : In MS Access, The Atn() function returns the arctangent of a number. It takes a number as a parameter and it will… Read More
Below statement could be used to get data from multiple tables, so, we need to use join to get data from multiple tables. Syntax :… Read More
Courses
