MSSQL Query Blog
-
-
-
-
-
Viewing Stored Procedure Parameters in Detail in SQL Server
Hello everyone, In this article, I will try to give information about displaying Stored Procedure parameters in SQL Server in detail. In SQL Server, in some cases, you may want to view the Stored Procedure parameters in detail. You can easily do this using the code below. SELECT ‘Parameter_name’ =...
-
-
Listing System Administrators in SQL Server
Hello everyone, In this article, I will try to give information about listing System Administrators in SQL Server. In SQL Server you may want to list System Administrators in some cases. You can easily do this using the code below. SELECT name, type_desc, is_disabled FROM master.sys.server_principals WHERE IS_SRVROLEMEMBER(‘sysadmin’, name) =...
-
-
Seeing Procedure Execution Statistics in SQL Server
Hello to everyone, In this article, I will try to give information about seeing Procedure Execution Statistics in SQL Server. In SQL Server you may want to see Procedure Execution Statistics in some cases. One advantage of Stored Procedures is that performance can be tracked. There may be many Stored...
-
Getting the Millisecond Value in SQL Server
Hello to everyone, In this article, I will try to give information about obtaining the millisecond value in SQL Server. In SQL Server, you may want to get the Milliseconds value in some cases. You can easily do this using the code below. SELECT (DATEPART(MILLISECOND, GETDATE())); When you run the...
