SSMS 17 (Or Higher) Grid Columns width is not auto sizing - high resolution screen

 

เพิ่มความเร็ว Load SSMS 

ไปที่เมนู Tools > Options > Environment > Startup และเลือก At startup เป็น Open empty environment

DV-Enable the ClickOnce trust prompt

When attempting to install a Microsoft-signed ClickOnce application, an error appears stating "Your administrator has blocked this application because it potentially poses a security risk to your computer" and "Your security settings do not allow this application to be installed on your computer".

To enable the ClickOnce trust prompt by using the registry editor Open the registry editor:
Click Start, and then click Run.

In the Open box, type regedit, and then click OK.
Find the following registry key:

\HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\.NETFramework\Security\TrustManager\PromptingLevel

If the key does not exist, create it.

Add the following subkeys as String Value, if they do not already exist, with the associated values shown in the following table.

DV-SQL Server 2016 Retain CR/LF on Copy

DV-พื้นฐาน SQL Statement

คำสั่งพื้นฐาน
INSERT INTO <table> (field, field,...) VALUES (data, data,...)
เช่น 
INSERT INTO Emp VALUES (001,"Surapun")
INSERT INTO Emp(name) VALUES ("Surapun")

INSERT INTO <table> SELECT <field, field,...> FROM <table> WHERE <condition>
เช่น 
INSERT INTO faculty 
  SELECT facultyID,facultyName FROM faculty_tab 
  WHERE facultyID NOT IN (SELECT facultyID FROM faculty_test)
INSERT INTO faculty  (facultyName)
  SELECT facultyName FROM faculty_tab 
  WHERE facultyID NOT IN (SELECT facultyID FROM faculty_test)