Skills Showing posts with label SQL Functions. Show all posts
September 28, 2022
Database Concepts, Database Management System, RDBMS, SQL Functions, SQL Joins, SQL Queries, SQL Server, SQL Server Indexes, SQL Server Interview Questions, SQL Server Tutorials, Stored Procedures
250 SQL Server Interview Questions – Basic to Advanced
SQL Server is a Relational Database Management System (RDBMS) developed by Microsoft. It is widely used to store, manage, retrieve, and mani...
Read more →
August 10, 2022
CAST Function, CONVERT Function, Data Type Conversion, SQL Functions, SQL Queries, SQL Server, SQL Server Interview Questions, SQL Server Tutorials
Difference Between CAST() and CONVERT() Functions in SQL Server
The CAST() and CONVERT() functions are both used to convert data from one data type to another in SQL Server. Example SELECT CAST('10...
Read more →
August 10, 2022
@@IDENTITY, IDENT_CURRENT, IDENTITY Column, SCOPE_IDENTITY, SQL Functions, SQL Server, SQL Server Interview Questions, SQL Server Tutorials
Difference Between SCOPE_IDENTITY(), IDENT_CURRENT() and @@IDENTITY in SQL Server
SCOPE_IDENTITY() , IDENT_CURRENT() , and @@IDENTITY are similar SQL Server functions because they return the last identity values generated...
Read more →
August 10, 2022
COALESCE, ISNULL, NULL Handling, SQL Functions, SQL Queries, SQL Server, SQL Server Interview Questions, SQL Server Tutorials
Difference Between ISNULL() and COALESCE() in SQL Server
In SQL Server, ISNULL() and COALESCE() are used to handle NULL values by returning an alternative value when an expression evaluates to NU...
Read more →