MSSQL and TSQL Programming and TSQL Examples
Hello everyone, In this article, I will provide information on how to remove all Foreign Keys in all tables in SQL Server. In SQL Server in some cases you may want to remove all Foreign Keys from all tables. You can easily do this using the code below. DECLARE @Command...
Hello everyone, In this article, I will provide information about the procedure that brings the previous week’s list of failed logins in SQL Server. It is also very important for security to track failed login attempts to SQL Server. With the help of the procedure below, you can also track...
Hello everyone, In this article, I will give information about data compression procedure for all tables in SQL Server. There are two types of data compression. Row Level Data Compression: A compression method that converts fixed-length data types to variable-length data types and frees up free space. It also saves...
Hello everyone, In this article, I will provide information on how to get the list of CLRs registered in the database in SQL Server. In some cases in SQL Server there may be a need to get the list of CLRs registered in the database. You can easily do this...
Hello everyone, In this article, I will try to give information about the version information and details of all databases in SQL Server. In SQL Server, in some cases, you may want to learn the version information and details of all databases. You can easily do this using the code...
Hello everyone, In this article, I will try to give information about creating the Property values of the table in SQL Server. You may want to see the Csharp or Java Property equivalents of the tables we have created in SQL Server. You can easily do this using the code...
Hello everyone, In this article, I will provide information on how to remove all procedures in SQL Server. In SQL Server we may want to remove all procedures in some cases. You can easily do this using the code below. DECLARE @procName VARCHAR(500); DECLARE cur CURSOR FOR SELECT [name] FROM...
Hello everyone, In this article, I will try to give information about removing all Foreign Keys in the database in SQL Server. In SQL Server, in some cases, you may need to Remove All Foreign Keys in the database. You can easily do this using the code below. DECLARE @SQL...