MSSQL and TSQL Programming and TSQL Examples
Hello everyone, In this article, I will provide information about performing the update process by checking if there is data in SQL Server. In SQL Server, in some cases, it is possible to check whether the data exists and to perform the update process. You can easily do this with...
Hello everyone, In this article, I will give information about converting the rows of a column in a table into a single row in SQL Server. In SQL Server, in some cases, we may want to combine the rows of a column in a table into a single row. You...
Hello everyone, In this article, I will provide information about finding filenames by version in SQL Server. In SQL Server, in some cases we may want to know which version of SQL Server is installed based on the file name. With the help of the information below, you can easily...
Hello everyone, In this article, I will give information about finding the number of table columns in SQL Server. In SQL Server, in some cases, we may want to find the number of columns in a table. You can easily do this with the help of the code below. I...
Hello everyone, In this article, I will provide information about listing log file sizes of all databases in SQL Server. In SQL Server, in some cases we may want to list the log file sizes of all databases. You can easily do this with the help of the code below....
Hello everyone, In this article, I will give information about the use of dynamic where query in SQL Server. In SQL Server, in some cases, you may want to use two or more where conditions dynamically. I created the following code based on the Northwind database. You can use it...
Hello everyone, In this article, I will provide information about learning the file size information of MDF and LDF’s in SQL Server. With the help of the code below, you can learn the file size information of all databases in SQL Server. SELECT DB_NAME(mf.database_id) AS DatabaseName, mf.physical_name AS PhysicalPath, size_on_disk_bytes...
Hello everyone, In this article, I will give information about the function that clears non-numeric characters in SQL Server. In SQL Server, in some cases, we may want to remove parentheses, dashes, etc. on a numeric text. You can easily do this with the help of the function below. ...