Ok,
then you have an SQL console in which you should be able to repair this.
Marcel
Ok,
then you have an SQL console in which you should be able to repair this.
Marcel
How ?
i don't кnow the command
help me please
e.g.
delete * from DICOMImages where ImageDate>'20100101' and ImageDate<='20101231'
delete * from DICOMSeries where SeriesDate>'20100101' and SeriesDate<='20101231'
delete * from DICOMStudies where StudyDate>'20100101' and StudyDate<='20101231'
delete * from DICOMPatients where WHERE PatientID NOT IN (SELECT PatientID FROM DICOMStudies)
Untested and use with utmost care (backup first)
Marcel
Hi
ok
thank's
Hi !
need help
how open SQL console
i installed microsoft sql server manager studio
Hi !
need help
how open SQL console
It depends on your SGBD.
Each sgbd has your tools to execute sql.
Or use a third part program to do it.
Display Moree.g.
delete * from DICOMImages where ImageDate>'20100101' and ImageDate<='20101231'
delete * from DICOMSeries where SeriesDate>'20100101' and SeriesDate<='20101231'
delete * from DICOMStudies where StudyDate>'20100101' and StudyDate<='20101231'
delete * from DICOMPatients where WHERE PatientID NOT IN (SELECT PatientID FROM DICOMStudies)
Untested and use with utmost care (backup first)
Marcel
Hi, Marcel,
only a small correction, delete has no '*'
delete from DICOMImages where ImageDate>'20100101' and ImageDate<='20101231'
delete from DICOMSeries where SeriesDate>'20100101' and SeriesDate<='20101231'
delete from DICOMStudies where StudyDate>'20100101' and StudyDate<='20101231'
delete from DICOMPatients where WHERE PatientID NOT IN (SELECT PatientID FROM DICOMStudies)
Great, glad it worked.
my SQL is quite rusty!
Marcel
Hi!
haven't deleted it yet
I don't know which program to remove
You have to use the command line e.g.
dgate64 --deletestudies:datarange
Marcel
Hi
need help
how export and import db
my db in ODBC ms sql server 2019
You will have to google it.
Marcel
ок
Don’t have an account yet? Register yourself now and be a part of our community!