MSSQL and TSQL Programming and TSQL Examples
Hello everyone, In this article, I will try to give information about seeing which tables were processed last in SQL Server. In SQL Server, in some cases, you may want to see which tables were processed last. You can easily do this using the code below. SELECT DB_NAME(ius.[database_id]) AS [Database],...
Hello everyone, In this article, I will try to give information about the versions that need to be updated in SQL Server. There are some versions of SQL Server that are known to cause corruption in SQL Server in certain situations. These are versions of SQL Server 2012 and SQL...
Hello everyone, In this article, I will try to give information about separating table columns with commas and making them a list in SQL Server. In SQL Server, in some cases, the number of columns in your table may be high. Instead of typing the column names one by one...
Hello everyone, In this article, I will try to give information about checking when the database was last backed up in SQL Server. In SQL Server, in some cases, you may want to check when the database was last backed up. You can easily do this using the code below....
Hello everyone, In this article, I will try to give information about the MSSQL support termination dates in SQL Server. Below are Microsoft’s end of support dates for SQL Server versions. ↓SQL Server 2019 15.0.2000.5 Version: 15.0 Mainstream support end: Jan 14, 2025 Extended support end: Jan 8, 2030 ↓SQL...
Hello everyone, In this article, I will try to give information about how to check in which table the column name is kept in SQL Server. In SQL Server, in some cases, we may want to know in which table the column name is kept. You can easily do this...
Hello everyone, In this article, I will try to give information about querying whether there is a Stored Procedure in SQL Server. In SQL Server you may want to query if there is a Stored Procedure in some cases. You can easily do this using the code below. SELECT *...
Hello everyone, In this article, I will try to give information about seeing table sizes in SQL Server. In SQL Server you may want to see table sizes in some cases. You can easily do this using the code below. SELECT t.name AS TableName, s.name AS SchemaName, p.rows AS RowCounts,...