SQL Server Skill Table Query

💛ต้องการแก้ไขและแทนค่าบางค่าใน Column💛

UPDATE dbo._YourTable_
SET _ColumnName_ = REPLACE(_ColumnName_, '_OldValue_', '_NewValue_')
WHERE FilterSQL LIKE '%_SomeValue_%' //บรรทัดนี้มีหรือไม่มีก็ได้
------------------------------------------------------------------
💙[Add column Table]💙 ALTER TABLE dbo._YourTable_ ADD _ColumnName1_ VARCHAR(20) NULL ,_ColumnName2_ INT NULL ; ------------------------------------------------------------------ 💚[Modify type column of table ]💚 ALTER TABLE _YourTable_ ALTER COLUMN _ColumnName_ VARCHAR(MAX); ------------------------------------------------------------------ 💗[Select ALL Table and Stored on DB]💗 SELECT * FROM SYSOBJECTS --WHERE -- xtype = 'U' ORDER BY crdate desc; GO ------------------------------------------------------------------