zhangshuai.wordpress.com

CONTENT

PAGE TITLE

龙堂 | zhangshuai.wordpress.com Reviews

<META>
DESCRIPTION

Get table or view name by search column name keyword. Asymp; Leave a comment. Here is the script:. SELECT c.object id, CASE WHEN OBJECTPROPERTY(c.object id, 'isTable') = 1 THEN 'Yes' ELSE 'No' END AS IsTable, CASE WHEN OBJECTPROPERTY(c.object id, 'isView') = 1 THEN 'Yes' ELSE 'No' END AS IsView, OBJECT SCHEMA NAME(c.object id) AS SchemaName, OBJECT NAME(c.object id) AS TableName, c.name AS ColumnName FROM sys.columns c WHERE c.name LIKE '%MyColumnName%'. TSQL: Search keyword in XML Column. AS DBName, SCH...

<META>
KEYWORDS

1 friday

2 posted by zs

3 in 技术笔记

4 tags

5 sql query

6 thursday

7 in database

8 技术笔记

9 microsoft sql server

10 tsql

CONTENT

Page content here

KEYWORDS ON
PAGE

friday,posted by zs,in 技术笔记,tags,sql query,thursday,in database,技术笔记,microsoft sql server,tsql,sp msforeachdb,github tips,wednesday,in automation,github,putty,git show 1,git log 1,tuesday,windows shortcuts,run commands,management consoles,microsoft,pict

SERVER

nginx

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

龙堂 | zhangshuai.wordpress.com Reviews

https://zhangshuai.wordpress.com

Get table or view name by search column name keyword. Asymp; Leave a comment. Here is the script:. SELECT c.object id, CASE WHEN OBJECTPROPERTY(c.object id, 'isTable') = 1 THEN 'Yes' ELSE 'No' END AS IsTable, CASE WHEN OBJECTPROPERTY(c.object id, 'isView') = 1 THEN 'Yes' ELSE 'No' END AS IsView, OBJECT SCHEMA NAME(c.object id) AS SchemaName, OBJECT NAME(c.object id) AS TableName, c.name AS ColumnName FROM sys.columns c WHERE c.name LIKE '%MyColumnName%'. TSQL: Search keyword in XML Column. AS DBName, SCH...