How to fix Recovery Pending State in SQL Server Database?
2022-06-22 SQL Server
How to fix Recovery Pending State in SQL Server Database?
Read More...How to fix Recovery Pending State in SQL Server Database?
How to fix Recovery Pending State in SQL Server Database?
Read More...Add DBMS data type as an available type in sql server
Add DBMS data type as an available type in sql server
Read More...Pagination with the stored procedure in SQL Server
Pagination with the stored procedure in SQL Server
Read More...Select 12 months number and name from sql server
Select 12 months number and name from sql server
Read More...How to rollback or commit a transaction in SQL Server?
How to rollback or commit a transaction in SQL Server?
Read More...Parse and Transform JSON Data with OPENJSON
Sql Server Json Array To Rows, Parse and Transform JSON Data with OPENJSON
Read More...How to convert an integer to year month and days in SQL?
How to convert an integer to year month and days in SQL server?
Read More...How to find find second highest salary in SQL Server?
How to find find second highest salary in SQL Server- To find the 2nd highest salary is a very common interview question if you are going for the role at the junior level. Also, understand how this SQL query works.
Read More...How to convert "dd/mm/yyyy" string to datetime in SQL
How to convert "dd/mm/yyyy" string to datetime in SQL
Read More...How to Convert Datetime to Date in SQL Server
Convert Datetime to Date, SQL Server CONVERT(datetime to date)
Read More...How to get year from date in sql server?
How to get year from date in sql server-
Read More...SQL INNER JOIN - Joining Two or More Tables
SQL INNER JOIN - Joining Two or More Tables:- Inner join returns the rows that match in both tables. Left join returns all rows from the left table. Right join returns all rows from the right table. Full join returns whole rows from both tables.
Read More...Date and Time Conversions Using SQL Server
Date and Time Conversions Using SQL Server - In this article, how will convert date and time in SQL, first considerations is the actual date/time needed. The most common is the current date/time using getdate(). This provides the current date and time according to the server providing the date and time. If a universal date/time is needed, then getutcdate() should be used.
Read More...How convert varchar to int in sql?
How convert varchar to int in sql?
Read More...where condition in SQL server- The SQL WHERE Clause The WHERE condition is used to filter records. The WHERE condition is used to extract only those records that fulfill a specified condition.
Read More...Convert an integer to year month and days in SQL server
Convert an integer to year month and days in SQL server
Read More...NULL VALUES and NULL FUNCTIONS in SQL
NULL VALUES and NULL FUNCTIONS in SQL:- In this article, If we do not fill any data in any field if it is not required or we can say that if that field is optional then by default, a table column hold NULL value. You know that NULL value means 0 (Zero), Empty cell, empty, missing, or unknown data.
Read More...Find the number of columns in a table in sql server
Find the number of columns in a table in sql server, how to count column in sql
Read More...Cursor in SQL may be a set of rows along side a pointer that identifies a current row. it's a database object to retrieve data from a result set one row at a time. it's useful once we want to control the record of a table during a singleton method, in other words one row at a time. use of a cursor in SQL, types of the cursor in SQL, cursor in SQL example with a stored procedure, sql server cursor example multiple columns, sql server cursor for update, trigger and cursor in sql, cursor in pl/sql, types of cursor in SQL, cursor in SQL minify code, cursor in SQLserver, cursor in SQL, nested cursor in SQLserver.
Read More...SQL ALTER TABLE statement is used to modify the table structure, you can modify column(s), add column(s), drop column(s) or work on constraints. Here we will use tbl_employee table for practice. In this table we will add Address column, so we can write below query.
Read More...CASE statement in SQL, The CASE statement goes through conditions and returns a value when the first condition is ( IF-THEN-ELSE statement). So, once a condition is true, it will stop reading and return the result. If no conditions are true, it returns the value in the ELSE clause.
Read More...SQL Group By Clause. Group by clause is used to group the results of a SELECT query based on one or more columns. It is also used with SQL functions to group the result from one or more tables.
Read More...The SQL UNION operator is employed to mix the result sets of two or more SELECT statements. It removes duplicate rows between the varied SELECT statements. Each SELECT statement within the UNION must have an equivalent number of fields within the result sets with similar data types.
Read More...SQL Data Type Conversion Methods and performance comparison
SQL Server Data Type Conversion Methods and performance comparison
Read More...How to convert numeric to nvarchar in SQL Server?
How to convert numeric to nvarchar in SQL Server?
Read More...Cast or convert a float to nvarchar in SQL
cast or convert a float to nvarchar in SQL
Read More...How to convert Nvarchar column to INT in sql
How to convert Nvarchar column to INT in sql
Read More...Concatenating int and nvarchar column in sql
Concatenating int and nvarchar column in sql
Read More...SQL Aliases, It is used when the name of a column or table is used other than their original names, but the modified name is only temporary, Aliases are the temporary names given to the table or column for the purpose of a particular SQL query.
Read More...SQL Server IN operator, IN operator is a logical operator that allows you to test whether a detailed value matches any value in a list.
Read More...SQL Wildcard, They are used just as LIKE operator, and also WHERE clause to search for a mere pattern in a column, The wildcard in SQL is used in a string to substitute characters.
Read More...SQL WHERE LIKE SELECT WHERE LIKE Wildcard OR Examples
The SQL Server LIKE is a logical operator that determines if a character string matches a specified pattern. The LIKE operator is used in the WHERE clause of the SELECT, UPDATE, and DELETE statements to filter rows based on pattern matching. A pattern may include regular characters and wildcard characters.
Read More...FULL OUTER JOIN Keyword In SQL Server
FULL OUTER JOIN Keyword In SQL Server,
Read More...RIGHT JOIN Keyword in SQL Server
The RIGHT JOIN keyword returns all records from the right table (table2), and the matched records from the left table (table1). The result is NULL from the left side table, when there is no match.
Read More...LEFT JOIN Keyword in SQL Server
The SQL LEFT JOIN keyword returns all records from the left table (table1), and the matched records from the right table (table2). The result is NULL from the right side table, if there is no match
Read More...how to use the distinct keyword in sql server
how to use the distinct keyword in sql server
Read More...The SQL ASC keyword specifies an ascending sort order for a column within in the ORDER BY clause. This means the values are sorted in 0 to 9 or A to Z order.
Read More...sql server constraint keyword, Constraints can be column level or table level. Column level constraints apply to a column, and table level constraints apply to the whole table.
Read More...SQL DROP TABLE statement is used to remove table in a database. When you use the SQL DROP TABLE statement to remove a table, the database engine deletes all objects associated schema to that table including data, indexes, constraints, table structure, triggers
Read More...WHERE Keyword in SQL Server, In this post, The SQL WHERE keyword is used to select data conditionally, by adding it to already existing SQL SELECT query. The WHERE keyword can be used to select, update and delete data from table, but for now we will stick with conditionally retrieving data, as we already know how to use the SELECT keyword
Read More...Functions SQL Aggregate Functions COUNT(), AVG(), SUM() SQL
Functions SQL Aggregate Functions | COUNT(), AVG(), SUM() In SQL Server, SQL aggregate functions are inbuilt functions that are used for performing various operations in data.
Read More...SQL Drop DataBase: The DROP DATABASE Statement is used to drop or delete a database. Dropping of the database will drop all database objects (tables, procedures, views, function etc.) inside it. The user should have admin privileges for deleting a database.
Read More...SQL INNER JOIN: INNER JOIN keyword selects all rows from both tables as long as there is a match between the columns in both tables
Read More...Create Table with SQL FOREIGN KEY Constraint
Create Table with SQL FOREIGN KEY Constraint: when you create two tables that are related to each other, they are often related by a column in one table referencing the primary key of the each other table, that column is called the foreign key.
Read More...EXISTS Keyword in SQL Server: The SQL EXISTS condition is used to test for a subquery and is considered to be met, if the subquery returns at least one row. It can be used in a SELECT, INSERT, UPDATE, or DELETE statement.
Read More...LEFT, RIGHT, INNER and FULL JOIN in SQL Server
LEFT, RIGHT, INNER and FULL JOIN in SQL Server
Read More...SQL Server CREATE VIEW Statement
SQL Server CREATE VIEW Statement
Read More...MAX() and MIN() Functions in SQL Server
MAX() and MIN() Functions in SQL Server
Read More...What does SELECT top 1 do in SQL?
SQL SELECT TOP clause is used to specify the number of records to return
Read More...How to find for NULL Values in SQL Server?
How to find for NULL Values in SQL Server?
Read More...AND, OR and NOT Operators in SQL Server
AND, OR and NOT Operators in SQL Server
Read More...SELECT DISTINCT Examples in SQL Server
SELECT DISTINCT Examples in SQL Server
Read More...SQL query to find second highest salary
SQL query to find second highest salary
Read More...Find the Nth Highest Salary in a Table
Find the Nth Highest Salary in a Table
Read More...SQL Query to Find Nth Highest Salary
SQL Query to Find Nth Highest Salary
Read More...Find The 3rd Or Nth Highest Salary Via SubQuery in sql
Find The 3rd Or Nth Highest Salary In A Table Via SubQuery in sql server
Read More...Find the 2nd or 3rd or Nth highest salary in sql server
Find the 2nd or 3rd or Nth highest salary in sql server
Read More...How to find 3rd or nth maximum salary in sql
How to find third or nth maximum salary from salary table in sql server
Read More...How to find Nth highest salary from a table in sql server
How to find Nth highest salary from a table in sql server
Read More...SELECT DISTINCT Statement in SQL Server
SELECT DISTINCT Statement in SQL Server, the SELECT DISTINCT statement is used to return only distinct (different) output.
Read More...Find Total Number of days between two specific dates in SQL
How to Calculate Total Number of days between two specific dates in SQL Server
Read More...How to find only Saturday and Sunday dates of month in SQL
How to find only Saturday and Sunday dates of month in SQL Server
Read More...Second Highest Salary in SQL Server
Second Highest Salary in SQL Server
Read More...Single sp for insert update delete and select in sql
single stored procedure for insert update and delete and select in sql server
Read More...