MSSQL Query

MSSQL and TSQL Programming and TSQL Examples

MSSQL Query Blog

SQL Server

Using Python MSSQL-CLI in SQL Server

Hello to everyone, In this article, I will try to give information about using Python MSSQL-CLI in SQL Server. First, let me talk about what MSSQL-CLI is. MSSQL-CLI is an interactive command line query tool for SQL Server. It is open source and built with Python. It can be used...

Functions / SQL Server

Listing All Functions in SQL Server

Hello to everyone, In this article, I will give information about how to list all functions in SQL Server. In SQL Server you may want to list all functions in some cases. You can do this easily with the help of the code below. SELECT name, definition, type_desc FROM sys.sql_modules...

SQL Server / Stored Procedures

Listing All Procedures in SQL Server

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

SQL Server

Islamic Calendar Dates in SQL Server

Hello to everyone, In this article, I will talk about changing the date format to Islamic calendar date format in SQL Server. You may need Islamic calendar date in SQL Server. You can use the codes below to change your date in Islamic calendar date format. 130 SELECT CONVERT(NVARCHAR, GETDATE(),...

Functions / SQL Server

SQL Server Date Formats

Hello to everyone, In this article, I will talk about Date format change operations in SQL Server. Date format change is often used in SQL Server. You can use the codes below to change the date format. 1 SELECT CONVERT(VARCHAR, GETDATE(), 1); mm/dd/yy 12/30/06 2 SELECT CONVERT(VARCHAR, GETDATE(), 2); yy.mm.dd...

Functions / SQL Server

SQL Server Time Formats

Hello to everyone, In this article, I will talk about time format changing operations in SQL Server. Time format change is often used in SQL Server. You can use the codes below to change the time format. 8 SELECT CONVERT(VARCHAR, GETDATE(), 8); hh:mm:ss 00:38:54 14 SELECT CONVERT(VARCHAR, GETDATE(), 14); hh:mm:ss:nnn...

Don`t copy text!