sp_select
sp_select copied to clipboard
FilipDeVos
SQL Server TSQL Stored Procedures which enable you to query table data through the data pages directly. This enables you to see the contents of temp tables created on other threads.
Hi, Thank you very much for this awesome tool ! Could you please add a licence file to the repo ? I can't officialy use this without knowing the licence...
When I set a breakpoint, wait it to be hit it during debugging and then execute the below statements in another tab, it causes SSMS to hang, exec sp_select_get_rowcount 'tempdb..#MyTempTable'...
Currently all the results are returned as `varchar(6000)` columns. A mapping should be made with `sys.columns` so the data can be casted to the native type.
When using a `varchar(max)` or `varchar(max)` column a `NULL` value is returned Repro script: ``` create table #longstrings (id int, name varchar(max)) insert into #longstrings values (1, cast(REPLICATE('X', 4000) as...
The minimum required permissions for executing the stored procedure should be checked. - Potentially deploying with execute as self & a check if the code is deployed with a sysadmin...
Metadata
Owner
Metadata
SQL Server TSQL Stored Procedures which enable you to query table data through the data pages directly. This enables you to see the contents of temp tables created on other threads.