Convert an integer to year month and days in SQL server
2020-08-24 SQL Server
Convert an integer to year month and days in SQL server
Read More...Convert an integer to year month and days in SQL server
Read More...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, 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 Server Data Type Conversion Methods and performance comparison
Read More...How to convert numeric to nvarchar in SQL Server?
Read More...cast or convert a float to nvarchar in SQL
Read More...How to convert Nvarchar column to INT in sql
Read More...Concatenating int and nvarchar column in
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...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,
Read More...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...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
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() 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: 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
Read More...SQL Server CREATE VIEW Statement
Read More...MAX() and MIN() Functions in SQL Server
Read More...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?
Read More...AND, OR and NOT Operators in SQL Server
Read More...SELECT DISTINCT Examples in SQL Server
Read More...SQL query to find second highest salary
Read More...Find the Nth Highest Salary in a Table
Read More...SQL Query to Find Nth Highest Salary
Read More...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
Read More...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
Read More...SELECT DISTINCT Statement in SQL Server, the SELECT DISTINCT statement is used to return only distinct (different) output.
Read More...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 Server
Read More...Second Highest Salary in SQL Server
Read More...single stored procedure for insert update and delete and select in sql server
Read More...