In this SQL Server tutorial, we will learn about the SQL Server function return table. We will illustrate this topic using multiple examples. SQL Server function return table In this section, we will learn how to create a user-defined function in SQL Server that returns table-type data. For this task, first, we need to know about user-defined … Read more >>
In this SQL Server tutorial, we will learn how to resolve the “Error: 40 – could not open a connection to sql server” error. So, in this tutorial, we will discuss the root cause of this error and will also discuss how to solve this error. Error: 40 – could not open a connection to sql server … Read more >>
If you need an orders query to run from an app, a job and a teammate’s script, save it as a stored procedure. The SQL Server create stored procedure syntax is short: CREATE PROCEDURE dbo.usp_Name AS BEGIN … END;, alone in its batch. Most first tries break that batch rule or fail on the second … Read more >>
As a database developer, it is essential to know how to save and mange the stored procedure. In this article, I will guide you through the steps to save stored procedure in SQL server. How To Save Stored Procedure In SQL Server To save stored procedure in SQL Server, follow the below steps. 1. Log … Read more >>
Recently, I got the requirement to check one of the stored procedure execution times in my SQL server database. This article will help you check the stored procedure execution history in an SQL Server. How To Check Stored Procedure Execution History In SQL Server To check stored procedure execution history in SQL server, follow the … Read more >>
Before you rename a column or drop a table, you need every procedure that touches it. To find text in a stored procedure in SQL Server, search the definition column of sys.sql_modules with LIKE. The shortcuts people grab first let you down: INFORMATION_SCHEMA.ROUTINES only sees the first 4,000 characters, and a plain text match can’t … Read more >>
In this MariaDB tutorial, we will study the use of the MariaDB DateTime constraint and we will also cover some examples. There are lists of the topic that comes under discussion: MariaDB DateTime MariaDB DateTime vs timestamp MariaDB DateTime Default Now MariaDB DateTime to Date MariaDB DateTime with Timezone MariaDB DateTime Milliseconds MariaDB DateTime Default … Read more >>
In this MariaDB tutorial, we will learn about MariaDB Select Into statement by using multiple examples. Additionally, we will cover the following topics. MariaDB Select Into MariaDB Select Into Table MariaDB Select Into Outfile MariaDB Select Into Dumpfile MariaDB Select Into Temporary Table MariaDB Select Into Multiple Variables MariaDB Select Into CSV MariaDB Select Into … Read more >>
In this MariaDB tutorial, we will study the use of the MariaDB Set Variable statements and we will also cover some examples. There are lists of the topic that comes under discussion: MariaDB set variable MariaDB set variable from select MariaDB set global variable permanently MariaDB set environmental variable MariaDB set user variable MariaDB set … Read more >>
In this MariaDB tutorial, you will learn about MariaDB Vs SQLite. MariaDB Vs SQLite MariaDB is a fork of MySQL Database, which was created in 2009. In contrast, SQLite is a C library that runs a small, fast, standalone, highly reliable, full-featured SQLite database engine designed in 1995. Here are some of the differences between MariaDB … Read more >>