This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Only gets the <loc> lines from: | |
```xml | |
<url> | |
<loc>https://asdf.net/55/s.i.v.-search</loc> | |
<lastmod>2020-06-15</lastmod> | |
<changefreq>weekly</changefreq> | |
<priority>0.5</priority> | |
</url> | |
<url> | |
<loc>https://asdf.net/catalogue/64/catalogue-pro</loc> |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE #LINKED | |
( | |
SRV_NAME nvarchar(100) | |
,SRV_PROVIDERNAME nvarchar(100) | |
,SRV_PRODUCT nvarchar(100) | |
,SRV_DATASOURCE nvarchar(100) | |
,SRV_PROVIDERSTRING nvarchar(100) | |
,SRV_LOCATION nvarchar(100) | |
,SRV_CAT nvarchar(100) | |
) |