MSSQL and TSQL Programming and TSQL Examples
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))...
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...
Hello everyone, In this article, I will try to give information about getting detailed information about all tables with Identity columns in SQL Server. In SQL Server, in some cases, you may want to get detailed information about all tables with an Identity column. You can easily do this using...
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’)...
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...
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...
Hello everyone, In this article, I will try to give information about the function that checks mail in SQL Server. In some cases, you may want to check the e-mail address you have in SQL Server. You can easily do this using the function below. CREATE FUNCTION fn_eMailKontrol ( @EmailAddr...
Hello everyone, In this article, I will give information about the equivalent of the Oracle LAST_DAY() function in SQL Server. In SQL Server, in some cases, we may want to see and use functions that are in other databases. What is the LAST_DAY() function? The LAST_DAY() function returns the date...