DEFINITIONS

Definitions More Info.
Definition ID3.027
TitleSQL
CategoryNOTES
DefinitionTablo icinde gecen ilgili kolon adini bulma
Definition DescriptionSELECT TOP 10 * FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE '%kimlik%'


SELECT 'SELECT '+ COLUMN_NAME+' FROM '+TABLE_NAME+' WITH(NOLOCK)
WHERE '+COLUMN_NAME+' IS NOT NULL AND '+COLUMN_NAME+' != '' '' '
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE '%kimlik%'
RecordBycunay
Record Date20-08-2020 16:04:00
Düzenle
Kopyala
Sil