Sql

Search

how to check which sp is running in sql server

SELECT
  object_name(st.objectid) as ProcName
FROM
  sys.dm_exec_connections as qs 
CROSS APPLY sys.dm_exec_sql_text(qs.most_recent_sql_handle) st 
WHERE
  object_name(st.objectid) is not null

Comment

PREVIOUS	NEXT

Code Example
Sql :: from . import _mysql ImportError: libmariadb.so.3: cannot open shared object file: No such file or directory linux
Sql :: mysql sql select one day before
Sql :: sql rename column in select query
Sql :: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row:
Sql :: postgres delete by id
Sql :: sql order by with where
Sql :: rand mysql
Sql :: change from not null postgresql
Sql :: how to use timestampdiff in a table in sql
Sql :: sql output select
Sql :: oracle lock user
Sql :: how to find 2nd highest salary in a table
Sql :: copy column from one table to another without column duplicate postgres
Sql :: postgresql where and
Sql :: oracle get foreign keys on table
Sql :: oracle undo tablespace schema
Sql :: how to find max and min salary in sql
Sql :: sql default constraint
Sql :: Write SQL in ruby on rails
Sql :: how to move a column to different spot mysql
Sql :: mysql order by on condition
Sql :: sqlalchemy case insensitive like
Sql :: UNION ALL LEFT JOIN
Sql :: pl sql search saurce code
Sql :: sql get actual fiscal year
Sql :: delete and drop in sql
Sql :: sql server fn_dblog
Sql :: postgres drop all tables
Sql :: mysql dependency for spring boot
Sql :: plsql find location of procedure

Search

SQL

how to check which sp is running in sql server

ADD CONTENT