Loading
Stored Procedures Vs Functions In SQL - Types, Differences, And Best Practices
This article provides a comprehensive guide to stored procedures and functions in SQL, including their types and differences. It explains how these powerful tools can simplify database management, enhance security, and improve performance. The article also provides examples of different types of stored procedures and functions, such as simple stored procedures, input and output parameters, scalar functions, and table-valued functions. Furthermore, it highlights the differences between stored procedures and functions in terms of their usage, purpose, and return values. Finally, it includes best practices for using these tools in SQL programming.
What is SQL? Learn SQL and Download Free SQL Book
SQL stands for Structured Query Language. This article teaches you the basics of SQL and how to write SQL queries.
How To Pass JSON As Parameter To Store Procedure
In this article, you will learn how to pass json as parameter to store procedure.
How to Use Constraints in SQL Server Like a Pro
Constraints are an important tool for maintaining data integrity in SQL Server. In this article, you'll learn how to use constraints like a pro to ensure your data is accurate and reliable. We'll cover the different types of constraints, how to create and modify constraints, and best practices.
Table Value Parameter Use With C#
In this article, we learn how use a Table Valued Parameter with a C# application.
SQL Constraints
In this article, we are going to learn about the importance of SQL and its Constraints.
SQL Functions
In this article, you will learn how to learn SQL functions and types of functions.
SQL's Choose Function
This article explores the SQL's CHOOSE function, syntax, and parameters. A couple of examples of its usage.
SQL Cross Join
This article will explore the SQL Server CROSS JOIN to join unrelated tables.
SQL Security Tips - Dynamic Data Masking To Secure Data Access
There are various aspects of security, and Dynamic Data Masking is one of the important concepts to know. We will describe here what is Dynamic masking and how to implement it with step-by-step examples.
How to Create a New User in SQL Server?
In this article, you will learn how to create a new user in SQL Server.
How to Schedule a Job in SQL Server
In this article, you will learn how to schedule a new job that runs on a specific day and time.
Handling SQL Queries Using XAMPP Server
XAMPP is a Free full-fledged development environment that lets you install the Apache web server, MariaDB database, Perl, and PHP scripting languages in one installation. It is a free solution stack for website developers that includes a web server, database server, and scripting engines. production environments.
Backup and Restore Using Command Prompt - SQLCMD and T-SQL
In this article I am explaining how to do backup and restore using a SQLCMD and T-SQL command prompt.
Database Backup Using SQL Queries And Its Type
How to make a backup of database using SQL queries in compressed and uncompressed condition or restoring database from backup using SQL queries and Difference between Compressed and Uncompressed Backup.
Using For XML Clause In SQL Queries
For XML clause is used to convert the SQL result set into XML format. It is a very much helpful clause when we need XML data from the SQL result set. The FOR XML clause can be used in top-level queries and in subqueries. The top-level FOR XML clause can be used only in the SELECT statement. In sub queries, FOR XML can be used in the INSERT, UPDATE, and DELETE statements.
SQL Tips - Everywhere JSON So Why Not In SQL Server - New Feature In SQL Server
In this article, you will learn how to work with JSON in SQL Server in easy way.
How To Execute SQL Statements From Command Prompt
Here we discuss SQL and how to execute SQL statements in a command prompt.
SQL Tips - A Simple Way To Check Vulnerability Status Of Your SQL Server Database
In this article, you will learn about the simple way to check SQL Vulnerability to avoid any issue.
SQL Security Tips - Implement Row Level Security Quickly
RLS (row-level security) is one of the important concepts we need to understand to secure data access at a different role.
SQL's STRING_AGG Function
The STRING_AGG function arranges all expression and then puts it together in these rows' expressions to obtain a single string, separated by a specified separator.
SQL IS NULL And IS NOT NULL Operators
This explores the SQL's NULL and IS NOT NULL operators to test for a NULL and non-NULL value.
Select ½ in Mathematical Approach SQL Server Approach
The main purose of this article is is to show how to get non-integer values in SQL Server.
SQL Server Primary Keys
Discusses what's a primary key, entity integrity, primary key constraint, composite keys, and the benefits of a primary key.
Conversion Functions Using SQL Query in SQL Server
In this article you will see how to use conversion functions using SQL Query in SQL Server.
SQL Server INFORMATION_SCHEMA Views
Learning what's INFORMATION_SCHEMA is and showing its common basic usages.
SQL Security Functions: Part 3
In this article I describe the Transact-SQL security functions SUSER_ID, SUSER_NAME, SESSION_USER and SESSIONPROPERTY.
Put SQL Server’s Query Execution Engine on Hold
Here you will see how to put your SQL Server’s Query Execution Engine on hold for a while.
A Basic Walkthrough Of SQL Schema
This article shows you the basics of SQL Schema using the DDL statements.
