Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Error al pagar agrupado domicilio SoftRestaurant 9.0PRO
- --Consulta 1
- ALTER TABLE tempcheques ADD cuentapagadaprocesada bit DEFAULT NULL
- --Consulta 2
- IF NOT EXISTS(SELECT * FROM syscolumns AS sc INNER JOIN sysobjects AS so ON sc.id=so.id AND sc.name='paymentmethod_id' AND so.name='tempcheques')
- BEGIN
- ALTER TABLE tempcheques ADD paymentmethod_id INT NOT NULL DEFAULT -1
- END
- IF NOT EXISTS(SELECT * FROM syscolumns AS sc INNER JOIN sysobjects AS so ON sc.id=so.id AND sc.name='paymentmethod_id' AND so.name='cheques')
- BEGIN
- ALTER TABLE cheques ADD paymentmethod_id INT NOT NULL DEFAULT -1
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement