MSSQL and TSQL Programming and TSQL Examples
Hello to everyone, In this article, I will try to give information about row and size control by table name in SQL Server. In SQL Server, in some cases, we may want to check rows and sizes according to the table name. You can easily do this using the code...
Hello to everyone, In this article, I will try to give information about finding the last day of the year in SQL Server. In SQL Server you may want to find the last day of the year in some cases. You can easily do this using the code below. declare...
Hello to everyone, In this article, I will try to give information about listing the last three months in SQL Server. In SQL Server you may want to list the last three months in some cases. You can easily do this using the code below. WITH R (N) AS (SELECT...
Hello to everyone, In this article, I will try to give information about monitoring blocking in SQL Server. You may want to watch blocking and waits in SQL Server in some cases. You can easily do this using the code below. SET NOCOUNT ON; GO SELECT spid, blocked, REPLACE(REPLACE(T.text, CHAR(10),...
Hello to everyone, In this article, I will talk about the difference between stored procedures and functions in SQL Server. Stored procedures are sql statements that are stored by the database and do not need to be recompiled after the first compilation. Functions are sql codes that can return any...
Hello to everyone, In this article, I will talk about the differences between Cross Apply and Outer Apply in SQL Server. In SQL Server, such questions may come up as an interview question in recruitment as a database specialist. Similar to using CROSS APPLY -> INNER JOIN. Considers the intersection...
Hello to everyone, In this article, I will talk about the difference between temporary tables and global temporary tables in SQL Server. Temporary tables use the odd # sign, while global temporary tables use the double ## sign. In SQL Server, temporary tables can only be accessed from their environment....
Hello to everyone, In this article, I will try to give information about finding the first and last days of the year, month and week in SQL Server. In SQL Server, in some cases you may want to find the first and last days of the year, month, and week....