MSSQL and TSQL Programming and TSQL Examples
Hello to everyone, In this article, I will talk about the use of Common Table Expression, or CTE, in a basic sense. What is Common Table Expression? Expressions that allow one or more use of temporary results obtained at the time of execution of a query. Common Table Expression was...
Hello everyone, In this article, I will try to give information about how to get Month Information using DATENAME Function in SQL Server. In SQL Server, in some cases, you may want to get the month information from the date information by using the DATENAME function. You can easily do...
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...
Hello to everyone, In this article, I will give information about how to find the first and last day of the current month in SQL Server. In SQL Server in some cases we may want to get the first and last days of the month for the current day. You...
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...
Hello to everyone, In this article, I will try to give you information about calling a procedure from within a function in SQL Server. Many of you started reading the article saying that such a thing would not happen, or you started reading the article wondering how it really is....
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...
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...