MSSQL and TSQL Programming and TSQL Examples
Hello everyone, In this article, I will talk about how to dynamically generate code for removing all procedures in SQL Server. In SQL Server, in some cases, instead of removing the procedures by manually writing the code, we can remove the relevant procedures by dynamically generating code. You can see...
The process we will do is to create the script of the key fields of a table, namely the Primary Key, Foreign Key and Index Key fields. Even though I don’t use it much, in SQL Server, in some cases, we may only need to create a script for the...
Hello everyone, In this article, I will try to share information about searching words in all tables in SQL Server. In SQL Server, in some cases, we may want to find a word we want in all tables. You can easily do this using the procedure below. Note: It may...
Hello everyone, In this article, I will give information about the prime number checking procedure in SQL Server. You can constantly improve yourself by making such examples in SQL Server. You can easily do this with the help of the code below. CREATE PROC IsNumberPrime @Number INT AS DECLARE @Counter...
Hello everyone, In this article, I will give information about listing the files in the hard disk in SQL Server. In SQL Server, in some cases, it may be necessary to list the files in the hard disk. By using the code below, you can perform the listing of the...
Hello to everyone, In this article, I will provide information about finding which Stored Procedures a table is used in in SQL Server. In SQL Server in some cases you may want to find out which Stored Procedures a table is used in. You can easily do this using the...
Hello to everyone, In this article, I will try to give you information about running the function like a procedure in SQL Server. There are those among us who know, but since they do not tell such a subject, I will tell. You can do this easily using the code...
Hello to everyone, In this article, I will give information about how to list All Procedures in SQL Server. In SQL Server you may want to list all procedures in some cases. You can do this easily with the help of the code below. SELECT SPECIFIC_CATALOG, SPECIFIC_SCHEMA, SPECIFIC_NAME FROM INFORMATION_SCHEMA.ROUTINES...