posting correctly formatted works fine for me

/*
drop table dbo.TestData; create table dbo.TestData ( Column1 varchar(50));
insert into dbo.TestData (Column1) values ('13.4.'),('16.8.7'),('13.4'),('134'),('45.67'),('123');
*/select * from TestData
select try_cast(column1 as numeric(10,2))
from TestData
where...

• This reply was modified 3 days, 18 hours ago by frederico_fonseca.

my post had 4 links when I created it.

I have now edited it and added another 3 links (which also failed before if we added a second link to any...

seems to be sorted.

Limit was 1 link - as soon as it had 2 links it would get removed.

I would still have that spam link validation - but increase the...

• This reply was modified 1 weeks, 2 days ago by frederico_fonseca.

we could go to latest bad os from MS at https://www.microsoft.com/en-ie/windows/?r=1

or we could go to another database at https://www.postgresql.org/, not forgetting https://www.mysql.com/

lots of good info at https://european-union.europa.eu/index_en

and 3 more added...

• This reply was modified 1 weeks, 2 days ago by frederico_fonseca.

one way to do it is to have 3 steps.

1.  (powershell  (saves output to file) or tsql (saves output to DBA database)) scripts all required users and permissions.
2. restore from...

well then - if doing a quick google isn't good for you or your company enough why should we here do it for you? I found a few hits when...

although removing (or not using) compression on tables is likely hindering space requirements and performance - table compression does help in majority of cases with performance.

Partitioning is also no longer...

try and install an older version of access runtime

https://www.microsoft.com/en-us/download/details.aspx?id=39358

and if on your own PC don't install neither standard or enterprise - install developer instead.

• This reply was modified 3 weeks, 3 days ago by frederico_fonseca.

and which ones did you research so far and what are your own comments on them? or questions about them.

Naumon doesn't care about that - only trying to show "something" even if it is details already repeated or not suitable for the thread.

all documentation is pretty clear - upgrade is possible, downgrade isn't (going from standard to express, even if newer version of sql, is a downgrade).

Downgrade an edition

To downgrade the edition...

I typed up a large reply but then I hit submit and it was gone. So I'll be brief. I created 4 large projects this year. No, my skills...

and its possible that someone did a insert with a high value and used identity insert - that would set the identity value to that of the insert

without knowing the code of Function2 we can't help there. it may or not be possible/easy - but if function2 returns more than 1 row (first 1 returns a single...

the correct answer was hidden from us!!!