MSSQL Query Blog
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...
Writing a LastIndexOf Function in SQL Server
Hello everyone, In this article, I will try to give information about writing the LastIndexOf function in SQL Server. First of all, there is no such function in SQL Server. Before writing the function, let’s get a brief overview of the CHARINDEX function. In SQL Server, the CHARINDEX function performs...
Shrinking Tempdb Database in SQL Server
Hello everyone, In this article, I will try to give information about shrinking the Tempdb database in SQL Server. In SQL Server, in some cases, you may want to shrink the Tempdb database. You can easily do this using the code below. CHECKPOINT; GO DBCC DROPCLEANBUFFERS; GO DBCC FREEPROCCACHE; GO...
Encryption Operations in SQL Server
Hello everyone, In this article, I will try to give information about encryption operations in SQL Server. In SQL Server, in some cases, you may want to encrypt the data you have. You can easily do this using the code below. DECLARE @TestData NVARCHAR(MAX) = N’Yavuz Selim Kart’; SELECT HASHBYTES(‘MD2’,...