BazaReklamAktualizacja: version.sql
| Plik version.sql, 306 bytes (dodany przez marek, 17 years temu) |
|---|
| Line | |
|---|---|
| 1 | USE BAZA_REKLAM |
| 2 | |
| 3 | DECLARE @version varchar(10) |
| 4 | SET @version='1.1.28' |
| 5 | |
| 6 | UPDATE config2 |
| 7 | SET current_version=@version, data=getdate() |
| 8 | WHERE id=1 |
| 9 | |
| 10 | |
| 11 | UPDATE Applications.dbo.app |
| 12 | SET ver=@version, dateVer=getdate() |
| 13 | WHERE name='BazaReklam' |
| 14 | |
| 15 | SELECT * FROM config2 |
| 16 | |
| 17 | SELECT * FROM Applications.dbo.app |
