Timeline for SQL Server sp_describe_first_result_set: find user defined types
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 8, 2021 at 7:43 | history | edited | Peter Vandivier | CC BY-SA 4.0 |
add docs links, tidy formatting, refine phrasind
|
| Apr 8, 2021 at 6:37 | comment | added | Mark | @PeterVandivier feel free to improve up my question | |
| Apr 7, 2021 at 18:00 | history | tweeted | twitter.com/StackDBAs/status/1379856510940020741 | ||
| Apr 7, 2021 at 14:02 | answer | added | Paul White♦ | timeline score: 4 | |
| Apr 7, 2021 at 9:57 | comment | added | Peter Vandivier | Interesting question. Consider the differences between table variables, temp tables, and permanent tables (see dbfiddle.uk/…). Would you care to edit some of that detail into your question (or would you mind if I take the liberty of doing so)? Note also the availability of sys.dm_exec_describe_first_result_set for a narrower result set while rubber-ducking | |
| Apr 7, 2021 at 9:31 | history | edited | Mark | CC BY-SA 4.0 |
typo
|
| Apr 6, 2021 at 14:58 | comment | added | Dan Guzman | FWIW, I can repro with the table variable like your example but it works as expected with a permanent table. Maybe someone can explain why. | |
| Apr 6, 2021 at 14:13 | history | edited | Mark | CC BY-SA 4.0 |
added example
|
| Apr 6, 2021 at 11:20 | history | asked | Mark | CC BY-SA 4.0 |