SQL - salmanbaig8/imp GitHub Wiki

ALTER TABLE t1 ALTER COLUMN c VARCHAR (2); alter table tablename add/drop column columnname

SELECT * FROM tablename where value = 'S' and code IS NOT NULL and storeID not in (1000, 1001)

update table tablename set columna = 'value' where id = 10