MSSQL and TSQL Programming and TSQL Examples
Hello everyone, In this article, I will try to give information about the conversion of month number to month name in SQL Server. You may want to convert month number to month name in SQL Server. You can easily do this using the code below. DECLARE @MonthNumber INT = 6;...
Hello to everyone, In this article, I will try to give information about the function that calculates the working days between two dates in SQL Server. If you are calculating the working days of the staff in SQL Server, you may need such a function. I wrote it simply. You...
Hello to everyone, In this article, I will share information about creating C Sharp classes from Tables in SQL Server. Using this kind of stuff in the programming world can get you up to speed. Some may not need such codes. He may think he’ll code quickly without SQL Server....
Hello to everyone, In this article, I will talk about how to learn detailed version information in SQL Server. In SQL Server, in some cases, you may want to know the version information in detail. You can easily do this using the code below. SELECT CASE WHEN CONVERT(VARCHAR(128), SERVERPROPERTY(‘productversion’)) LIKE...
Hello to everyone, In this article, I will give you information about the procedure that runs dynamic queries in SQL Server. I don’t know if there is a need for such a thing in SQL Server, but I tried to write it saying that maybe I will need it in...
Hello to everyone, In this article, I will tell you how to draw a triangle using the REPLICATE function in SQL Server. You can also do this using the code below. DECLARE @i INT = 20; WHILE (@i > 0) BEGIN PRINT REPLICATE(‘* ‘, @i); SET @i = @i -...
Hello to everyone, In this article, I will talk about how to find tables related to Procedures in SQL Server. You can also do this using the code below. SELECT obj.[name] AS ‘ProcedureName’, sed.referenced_entity_name AS ‘TableName’ FROM sys.objects AS obj INNER JOIN sys.sql_expression_dependencies AS sed ON obj.object_id = sed.referencing_id WHERE...
Hello to everyone, In this article, I will give you information about how to list the columns of the tables in the database in SQL Server. Query below lists all table columns in a SQL Server database. SELECT SCHEMA_NAME(tab.schema_id) AS schema_name, tab.name AS table_name, col.column_id, col.name AS column_name, t.name AS...