Skip to content

Tag Archives: SQL-Server

Microsoft SQL Server is a relational database management system (RDBMS) that supports a broad range of transaction processing, business intelligence, and analytics applications. Along with… Read More
Introduction : Working with triggers can be difficult and time-consuming at times. Triggers can slow down the server’s output and place additional pressure on the… Read More
In this article, we will discuss the overview of Storing a Non-English String in Table, Unicode Strings in SQL SERVER with the help of an… Read More
In this article, we will cover bulk insert data from csv file using the T-SQL command in the SQL server. And will also cover the… Read More
In this, we will focus on how tables will be converted in T-SQL into XML in SQL server. And you will be able to understand… Read More
Imagine we need to select all the data from any given list. We could use multiple queries to combine rows in SQL Server to form… Read More
SQL Server has multiple data types e.g. integers, char, varchar, doubles, strings, etc. which are used for keeping specific values. Although built-in data types could… Read More
Whenever any value is passed to the variable or column of character data type, the string value has single quotes(”) around them otherwise it will… Read More
While inserting data in tables, sometimes we need to capture insert timestamp in the table. There is a very simple way that we could use… Read More
CURRENT_USER() function :This function in SQL Server is used to return the current user’s name in the database of SQL Server in use. Features :… Read More
There are various databases that have huge collections of data, and we know that the data is arranged in an organized manner. The data present… Read More
AVG() : This function in SQL Server is used to return the average value of the specified expression. Features : This function is used to… Read More
GETUTCDATE() : This function in SQL Server is used to return the UTC date and time of the present database system in a ‘YYYY-MM-DD hh:mm:ss.mmm’… Read More
SYSTEM_USER() function :This function in SQL Server is used to return the current user’s login name. Features : This function is used to find the… Read More
USER_NAME() : This function in SQL Server is used to return the username of the database that is based on the id stated. Features :… Read More