MSSQL and TSQL Programming and TSQL Examples
Hello to everyone, In this article, I will give information about navigating the table without using Cursor in SQL Server. In most cases, most people prefer to use Cursor to navigate the table in SQL Server, but it is a very costly operation. Of course, Cursor is used where Cursor...
Hello to everyone, In this article, I will provide information about listing past year, current year and next year information in SQL Server. In SQL Server, in some cases, you may want to list information for the past year, current year, and next year. You can easily do this using...
Hello to everyone, In this article, I will try to give information about creating the table script in SQL Server. In SQL Server, in some cases, you may want to create a script of a selected table with code. You can easily do this using the code below. DECLARE @TableName...
Hello to everyone, In this article, I will try to give information about the use of the month name function in SQL Server. In SQL Server, in some cases, you may want to get the month name from the month number. There are other solutions to this, but let’s create...
Hello to everyone, In this article, I will talk about LinkedIn groups that you may want to join in SQL Server. I recommend joining these groups to access new articles about SQL Server or to follow SQL Server developments. 1.SQL Server Eğitimleri 2.Learn SQL Server 3.SQL Server, ORACLE, IBM DB2,...
Hello to everyone, In this article, I will give information about how to check temp table in SQL Server. You may need to perform operations by checking whether the temp table exists in SQL Server. You can provide temp table control using the code below. –Example temp table creation CREATE...
Hello to everyone, In this article, I will provide information about the detection and control of connected users in SQL Server. In SQL Server, in some cases, you may want to detect users connected to SQL Server. You can easily do this using the code below. SELECT program_name, SUBSTRING(CONVERT(NVARCHAR, MAX(login_time)),...
Hello to everyone, In this article, I will try to give information about how to control files and folders in SQL Server. In some cases in SQL Server, you may want to have your file or folder checked for existence and take action accordingly. Before SQL Server 2017, we were...