Tag: sql server

dbForge Edge: Your Best Universal Tool for Multidatabase Challenges

MySQL, Oracle, PostgreSQL, SQL Server, Tools & technologies

Handling several database management systems simultaneously is inevitable in working on multiple...
Read More

31 Must-Know SQL Server DBA Interview Questions – Are You Prepared?

SQL Server

This article will help you to prepare for SQL Server interviews. I have explained various popular SQL Server interview questions and...
Read More

SQL Aggregate Functions: Easy Tips for Newbies

Database development, Statements

SQL Aggregate Functions are functions that perform calculations and return a summarized result. With these, it’s easy to do these...
Read More

User-Defined Data Types In SQL Server

SQL Server

SQL Server platform comes with many data types, but there are cases when they are not sufficient....
Read More

SUBSTRING Command in SQL: A Primer

SQL Server

Similar to my article regarding the SQL Server STUFF command, today we will be examining the SUBSTRING SQL server command. It is similar to...
Read More

Getting Started with the SQL Server T-SQL CASE Expression Statement

T-SQL

SQL Server CASE expression is very useful in returning an output based on some conditional matching criteria. We can state multiple...
Read More

SQL Server Primary Key

SQL Server

Across all major RDBMS products, Primary Key in SQL constraints has a vital role. They identify the...
Read More

SQL Server Triggers – Part 2 DDL & LOGON Triggers

Database development, Triggers

In SQL Server, triggers are database objects which will get executed whenever a triggering event happens on the database or server....
Read More

SQL Server Triggers: DML Triggers

Database development, Triggers

In SQL Server, triggers are database objects which get executed whenever a triggering event happens on the database or server. Triggers...
Read More

Drop Temp Table in SQL Server and PostgreSQL

Database development, PostgreSQL, SQL Server, Statements, Tables

This article explains different ways to drop the temp table in SQL Server and PostgreSQL. As the...
Read More
Close