MSSQL Query Blog

Capturing High Resource Queries in SQL Server

Hello everyone, In this article, I will try to give information about capturing high resource queries in SQL Server. In SQL Server, in some cases, you may want to capture your high resource queries. You can easily do this using the code below. SELECT TOP 10 SUBSTRING( qt.text, (qs.statement_start_offset /...

Getting Next Identity Value in SQL Server

Hello everyone, In this article, I will try to give information about getting the next Identity value in SQL Server. In SQL Server, in some cases you may want to get the next Identity value. You can easily do this using the code below. SELECT IDENT_CURRENT(‘Categories’) + IDENT_INCR(‘Categories’) AS Identity_Sonraki_Deger;...

Searching for a View on a Database in SQL Server

Hello everyone, In this article, I will try to give information about searching for View on the database in SQL Server. In SQL Server, in some cases, you may want to call View on the database. You can easily do this using the code below. DECLARE @Views TABLE (ViewName NVARCHAR(4000))...

Validating Date in SQL Server

Hello everyone, In this article, I will try to give information about validating dates in SQL Server. In SQL Server, in some cases, you may want to know that the entered date is a valid date. Namely; The date 31092022 (a date expression without a period in between) normally does...

Finding Increment Amount of Table in SQL Server

Hello everyone, In this article, I will try to give information about finding the increase amount of the table in SQL Server. In SQL Server you may want to find the increment amount of the table in some cases. You can easily do this using the code below. SELECT IDENT_INCR(‘Categories’)...

Writing an Oracle INITCAP Function in SQL Server

Hello everyone, In this article, I will give information about writing the Oracle INITCAP function in SQL Server. In SQL Server, in some cases, we may want to see and use functions that exist in other databases. What is the INITCAP function? While the INITCAP function converts the first character...

Don`t copy text!