SQL SERVER : SET Collate by Columns Name

Post by Goborijung at 2020-07-10 08:25:38 | ID: 661

Select top 1 
cusDB1.Code,cusDB1.Name 
,cusDB2.Code as navCusCode,cusDB2.ShortName,cusDB2.Name 
From GSSv2_Prod.dbo.Customer /*gss*/cusDB1 inner join ERP2020.dbo.Customer /*erp*/cusDB2 on cusDB1.Code = cusDB2.ShortName collate SQL_Latin1_General_CP1_CI_AS

/* เงื่อนไข */
GSSv2_Prod.dbo.Customer.Code = ERP2020.dbo.Customer.ShortName

SQL SERVER : SET IDENTITY_INSERT

Post by Goborijung at 2025-05-19 09:37:11 | ID: 2045

SET IDENTITY_INSERT tblName  ON

Insert into tblName(A,b,C)

SET IDENTITY_INSERT tblName  OFF

SQL SERVER : Show Server List

Post by Goborijung at 2020-08-13 13:39:03 | ID: 719

SELECT * FROM [sys].[servers]

SQL SERVER : SQL Show All Databases in Serverการขอดูรายละเอียดของฐานข้อมูล

Post by Goborijung at 2019-12-06 09:24:01 | ID: 209

USE Database_Name

ตัวอย่าง
USE GSSv2_Prod
GO
SELECT * FROM sysdatabases

หรือ

EXEC sp_helpdb

-- คำสั่งทั้งสองข้างต้น จะให้ผลลัพธ์ต่างกัน แต่สิ่งที่เหมือนกันคือ จะเป็นการแสดงรายชื่อฐานข้อมูลทั้งหมดที่เก็บอยู่ใน SQL SERVER นั้นๆ

SQL SERVER : SQL Show All Tables in Database

Post by Goborijung at 2019-10-11 08:44:06 | ID: 154

USE database_name
SELECT * FROM sys.Tables ORDER BY name ASC

SQL SERVER : SQL Show TABLE Description

Post by Goborijung at 2019-12-06 10:44:11 | ID: 216

EXEC sp_help table_name

Ex.
EXEC sp_help test

SQL SERVER : SQL CMD (How to use)

Post by Goborijung at 2020-05-13 09:26:04 | ID: 544

sqlcmd -S 192.168.1.194 -U sa -P sql4572030
sqlcmd -S 172.16.0.28 -U sa -P TPiCS40S

> Select name From sys.databases
> go

> Use GSSv2_Prod
> go

> Select * From TableName
> go

SQL SERVER : SQL DataType

Post by Goborijung at 2020-07-01 15:45:17 | ID: 648

https://www.w3schools.com/sql/sql_datatypes.asp

SQL SERVER : Sql get time , sql gettime , sql convert time

Post by Goborijung at 2025-10-17 11:29:40 | ID: 2071

SELECT CONVERT(time, GETDATE()); -- Returns time in hh:mm:ss format ex. 11:29:13.6900000
SELECT CONVERT(VARCHAR, GETDATE(), 108); -- Returns time in hh:mm:ss format ex.11:29:13

SQL SERVER : SQL Management Studio Word Wrap

Post by Goborijung at 2022-04-26 18:24:09 | ID: 1475

-- MSSQL
Menu : Tools > Text Editor > All Languages > Word wrap

-- VSCode
Alt + Z