Saturday , 1 October 2016

Function that converts characters from Latin to Cyrillic

Function that converts characters from Latin to Cyrillic in SQL Server Image you have a text which is written in Latin characters but you need them to be in Cyrillic characters. What will you do? Are you going to write that again from the beginning with Cyrillic characters? Of course not. Why loose all the precious time by typing again?! ... Read More »

SERVERPROPERTY in SQL Server

SERVERPROPERTY in SQL Server First of all let me explain what is serverproperty in sql server. Serverproperty in sql server is built in system function. This system function is important because you get a lot of useful information regarding to your SQL Server. This article will show you how to get all information you need about your SQL Server. For ... Read More »

How to hash a text in SQL Server

How to hash a text in SQL Server In this article I am going to show you how to hash a text in SQL Server. First let me explain what is hashing or hash function? “A hash function is any function that can be used to map digital data of arbitrary size to digital data of fixed size, with slight differences in input ... Read More »

Rad Studio XE7 (Delphi and C++)

Rad Studio XE7 (Delphi and C++) The complete solution to build connected apps for Windows, Mac, iOS, Android, Gadgets and Wearables Embarcadero® RAD Studio XE7 is the complete software development solution for rapidly building native applications for Windows, Mac, iOS and Android from a single codebase. Modernize existing Windows applications and create highly connected apps for gadgets and wearables. Deliver ... Read More »

Creating triggers in SQL Server

Creating triggers in SQL Server Creating triggers in SQL Server in SQL Server is similar to create a stored procedure. You can create triggers only when certain actions are fired. Triggers can be fired only before (insert, update, delete) and after (insert, update, delete). Creating triggers in SQL Server is very easy. In this article you are going to create a trigger ... Read More »

Searching all tables in sql server

Searching all tables in sql server Imagine a case where you want to see on which table there is a value or string of  ‘Barlet’ and you have 50+ tables on your database. Searching all tables in sql server one by one will be a huge pain and a waste of time. In this article you will see how to search all tables in ... Read More »