Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
select distinct COLUMN_TYPE, DATA_TYPE, table_name, CHARACTER_MAXIMUM_LENGTH, CHARACTER_OCTET_LENGTH, NUMERIC_PRECISION, numeric_scale FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = '<Database>' and DATA_TYPE= 'int' order by table_name
select COLUMN_NAME,COLUMN_TYPE, IS_NULLABLE, Column_default, COLUMN_COMMENT, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, CHARACTER_OCTET_LENGTH, NUMERIC_PRECISION, numeric_scale FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = '<database>' AND TABLE_NAME = '<table>' ;
|User with DBO permission can't remotely connect||15||49|
|Instering to MySQL table||5||47|
|setup wamp server for first time||2||67|
|Determining creation & modification dates on MySQL tables||4||37|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
10 Experts available now in Live!