MSSQL Query

MSSQL and TSQL Programming and TSQL Examples

MSSQL Query Blog

SQL Server / Stored Procedures

How to Rename a Table in SQL Server?

Hello to everyone, In this article, I will provide information on how to rename a table name in SQL Server. In SQL Server you may want to rename the table name in some cases. You can easily do this using the code below. exec sp_rename ‘dbo.Categories’, ‘NewCategoryName’ I made my...

SQL Server

Get the Month Name from a Date in SQL Server

Hello everyone, In this article I will try to give information about how to get the month name from a date in SQL Server. In SQL Server, in some cases, you may want to get the month information from the date information. You can easily do this using the code...

SQL Server

Calculating Number of Tables in SQL Server

Hello to everyone, In this article, I will try to give information about how to calculate the number of tables in the database in SQL Server. In SQL Server, in some cases you may want to know how many tables you have in the database. You can easily calculate this...

SQL Server

Converting Integer to String in SQL Server

Hello to everyone, In this article, I will try to give information about how to convert an Integer value to a String value in SQL Server. Conversion between types is the most used structures in SQL Server. You must have used it while coding. If you didn’t use it, you...

SQL Server

Converting Month Number to Month Name in SQL Server

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;...

Don`t copy text!