RajKishore 
In this MariaDB tutorial, we are going to learn about MariaDB create user. we will see how to create users with passwords in MariaDB. If you are new to MariaDB, check out how to install MariaDB. How to Create a User in MariaDB Let us see, how to create a user in MariaDB, but before … Read more >>
This SQL Server tutorial will teach how to find stored procedure in SQL Server using table name. How to find stored procedure in SQL Server using table name To find stored procedure in SQL Server using table name, we can use the below three simple approaches. Approach-1: Using sys.procedure table The SQL Server SYS.PROCEDURES is a system table that … Read more >>
In this Oracle tutorial, we will learn how to change the name of the database in Oracle Database 21c, 19c, and 12c. Oracle change database name Oracle Database name can be changed using the NID tool, which is installed by default when installing Oracle Database 21c on the Windows operating system. Please note that the database … Read more >>
In this Oracle tutorial, we will learn about the rowid datatype in the oracle database. Also, we will illustrate how to use it to create rowid columns for a table in oracle. Oracle rowid Datatype The ROWID datatype in Oracle 21c stores the unique address of a row in a database table. It is 18 characters long … Read more >>
I recently worked on creating the table and encountered an error. Errors are common in a development project. Exception handling or Error handling is an essential concept in software development. Like other programming languages, namely C, C++, and Java, SQL Server also provides exception handling. TRY and CATCH can handle errors in SQL Server. This … Read more >>
In this MariaDB tutorial, we will discuss how to use the MariaDB Insert If Not Exists condition and look at several examples related to it. MariaDB Insert If Not Exists Here we will understand how to insert rows in the table if it does not exist in MariaDB. This is because when we have a … Read more >>
While creating the function, I encountered an error and was unable to find the exact line. After several checks, I found the line number in SQL Server Management Studio. In this SQL Server tutorial, we will learn how to view line numbers in SQL Server Management Studio. View Line Numbers in SQL Server Management Studio SQL … Read more >>
In this SQL Server tutorial, we will discuss how to return value from stored procedure and how to return some specific values from a stored procedure, etc. SQL Server stored procedure return value In SQL Server 2019, there are mainly 3 methods for returning some values from a SQL stored procedure to its caller. All three methods are … Read more >>
In this SQL Server tutorial, we will learn how to execute stored procedure in SQL Server. We will also discuss different examples related to the execution of stored procedures in SQL Server. Here is the complete list of topics that we are going to discuss. How to execute stored procedure in SQL Server Note:- Before starting this topic, … Read more >>
In this SQL Server tutorial, we will learn how to create a table from view in SQL Server. Here we will illustrate this implementation using an example. Moreover, we will also cover the following topics. Create table from view in SQL Server In this section, we will learn to create a table using a view in SQL … Read more >>
Free 40-page PDF
Download a free 40-page PDF with the top 200 SQL Server interview questions and answers, and prepare with confidence.
Your SQL Server interview questions PDF is on its way to . Can't find it in a few minutes? Look in your Promotions or Spam folder.