SQL SERVER : Select Update From

Post by Goborijung at 2026-02-12 11:50:45 | ID: 2087

Select a.BARCODE_PALLET , b.BARCODE_PALLET , * 
-- Update A set A.BARCODE_PALLET = B.BARCODE_PALLET
From [191.20.2.90].productwms.dbo.PDWMS_M_ASRS_FLOOR A inner join PDWMS_M_ASRS_FLOOR B on A.BRN_CODE = B.BRN_CODE and A.Rec_Type = B.Rec_Type and A.FACTORY_ID = B.FACTORY_ID and A.SHELFID = B.SHELFID  
Where 1=1 
and A.BRN_CODE = 'CY'
and A.Rec_Type ='02'
and A.FACTORY_ID = 'c' 
and A.SHELFID = '0C0010101'

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