SQL Server
Find duplicate records from a table in SQL Server database
In this article, we learn about find duplicate records from a table in the SQL Server database SQL Query for finding duplicate records: Method 1: SE…
Read more
SQL Server
Get numeric value from string in SQL Server Database
In this article, we learn about SQL Server database functions, and using these functions gets the numeric value from a string value. Most useful…
Read more
SQL Server
Calculate holidays or days between two dates in SQL Server
In this article, we learn about SQL Server dates functions and using these functions calculate the day's difference between two dates. Most u…
Read more
SQL Server
While Loop in SQL Server Database (Database Programming)
While Loop: Description: Repetition of statement under a specific condition is called while loop. All loops …
Read more
SQL Server
Date formats in MySQL, SQL Server and Oracle (Comparisons)
Date formats comparisons in three databases: MySQL SQL Server Oracle Formats example date: 13 Mar , 2018 Example …
Read more
SQL Server
What's the main difference between database and schema?
Database: A database is the main container, it contains the data and log files, and all the schema's within it. You always back up a dat…
Read more
Videos
Get all table names and column names of database in SQL Server database
Live Video: Get all table names and column names of database in SQL Server database -----------Get Table names------------ SELECT TABLE_…
Read more
Videos
TRUNCATE TABLE Statement in SQL Server database
Live video: TRUNCATE TABLE Statement TRUNCATE statement in SQL like delete statement but that use for delete all records from table.The …
Read more
SQL Server
List names of all tables in a SQL Server schema
List names of all tables in a SQL Server schema 1. First Select the Database and press New Query Icon 2. Show you New Query Window 3. Use that…
Read more
Follow Us