[Qgis-user] Query a MS SQL database without loading entire database?

[Régis Haubourg]

Hi,
you can define a SQL filter before loading the dataset, that woudl help a
lot. You can inject a bbox filter for instance or any attribute where
clause. That should do the trick.
Régis

Le mar. 9 juil. 2019 à 18:03, magerlin <MAP at ramboll.dk> a écrit :

> I need to use a small part of a huge MS Sql database (data on *ALL*
> buildings
> in Denmark!).
>
> As far as I can see I can only try to load the whole database (using "add
> layer") before I do any querying?
>
> And this is a no go I can see.......
>
>
>
> -----
> Regards Morten
>
> Currently using Qgis 2.18.23 (OSGeo4) and Qgis 3.8.0 in parallel
> Windows 7, 64bit
> --
> Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20190709/fca1ac39/attachment.html>