sql-server - SQL Server 未显示列规范
问题描述
使用命令
sp_columns 'DimDiagnosis'
给我现有表的列名和列规格dimDiagnosis
。
但是当我为我正在生成的临时表尝试相同的语法时,
sp_columns '#Diagnosis'
只给我列名;我没有得到列规格。解决办法是什么?
解决方案
临时表驻留在 tempdb 中。您应该可以使用:
use tempdb; exec sp_columns '#Diagnosis'
或者:
exec tempdb..sp_columns '#Diagnosis'
推荐阅读
- javascript - 有没有办法在 HTML 元素中获取 javascript 变量的值?
- php - DOMPDF takes time when it generates a PDF with Images
- c# - Getting error while decrypting data through AES/ECB/PKCS7 algorithm - "Specified key is not a valid size for this algorithm"
- flutter - Another exception was thrown: Error: Could not find the correct Provider
above this History Widget flutter - kotlin - 为什么我在 Kotlin 中出现块体错误的函数中需要“返回”表达式?
- react-native - How to send bearer token as parameter and retrieve it in another screen in React Native
- docker - Docker: Error response from daemon - why is it not showing in docker container ls?
- sql - How to import a JSON file into postgresql databse?
- javascript - JQuery Input Field clickable again after using the blur() method
- javascript - Scrollbar touch target