In Azure SQL the dateformat is yyyy-mm-dd hh:mm:ss[.fff] (milliseconds)
In SQL Anywhere we can use also microseconds : yyyy-mm-dd hh:mm:ss[.ffffff]

What is your argument for SQL Anywhere being an enterprise DB?

asked 28 Apr, 05:20

Martin's gravatar image

Martin
8.8k122158246
accept rate: 14%

2

Please note that Azure does have support for microseconds to 7 digits using DATETIME2. See https://docs.microsoft.com/en-us/sql/t-sql/data-types/datetime2-transact-sql?view=sql-server-ver15.

(28 Apr, 10:16) Chris Keating
Replies hidden
2

That over-cooked Microsoft article https://docs.microsoft.com/en-us/sql/t-sql/data-types/datetime2-transact-sql?view=sql-server-ver15 is a perfect example of why it's important to get things right in the first place :)

(yesterday) Breck Carter

Of course SQL Anywhere isn't entirely in the clear on this subject: remember the proposal for a data type of Date_and_we_really_mean_it_this_time to deal with the problem of Dates storing DateTimes and so breaking comparisons! Fixed a long time ago though :)

(yesterday) Justin Willey

Hm, I don't remember, was that BC?

(yesterday) Volker Barth

Not necessarily an enterprise feature: I always forget that MS SQL Server does not allow aliases in the SELECT list to be reused further in the SELECT list, in WHERE, GROUP BY, something that I'm almost always using with SQL Anywhere. In MS SQL, you do have to repeat the expressions or use derived tables to be able to use aliases in different query clauses.

Something like

select Col1, Col1 + Col2 as Sum, SomeFunctionUsedOn(Col3) as MyCalcValue
from MyTable
where MyCalcValue > 100
order by Sum;

I could name many more samples but one of the biggest topics is the help: In that respect SQL Anywhere seems waaaaay more informative, focussed and clear than the MS counterpart.

permanent link

answered 28 Apr, 05:33

Volker%20Barth's gravatar image

Volker Barth
37.4k343510776
accept rate: 34%

Some more examples include

  • the builtin support to read and write files,
  • web client functions/procedures and web services,
  • or being able to run OpenXML against arbitrary values/columns whereas MS SQL requires a particulary prepared XML doc here (although MS SQL offers several XML functions to access XML nodes and values, to be fair).
(29 Apr, 10:17) Volker Barth

Easy to admin. We don't have a large IT unit. Has everything we need and more.
Proxy tables / interface to other dbs.
They used to have the best conferences ever.
This forum!
When I came to the university over 20 years ago, there was no real enterprise dbms. I made the case for SQL Anywhere, after using it at my previous employer, a gas and electric utility. (I believe it was WATCOM 4 that was packaged with Powerbuilder back then.) We jumped in and never looked back. Former MS SQL developers catch on quicky and love it.

permanent link

answered 29 Apr, 08:48

rsnyder's gravatar image

rsnyder
39191025
accept rate: 0%

1

They used to have the best conferences ever. - Seconded

(01 May, 07:45) Justin Willey

I've been using SQL Anywhere since version 7. Our company has 100+ installs across the US (PB 2019 and SA 11 or 16). Our largest account has 100+ users and 60 sales reps that use a app with Mobilink. Anytime we can't figure out a bug, we get a copy of the customer's database and log file, fire it up on a developer's PC, using dbengXX.exe, and run through the PB debugger. Generally, it takes more time to download a copy of the DB from the customers server, than to find the bug.

Installing SA 16, setting up a server (dbsrv16.exe) with a blank database, back up events, Mobilin, etc. takes less then 15 minutes.

Using MS SQL takes 2 strokes and a heart attack to do the same things.
No contest between databases.

permanent link
This answer is marked "community wiki".

answered 29 Apr, 08:58

Tom%20Mangano's gravatar image

Tom Mangano
672242738
accept rate: 8%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×36
×2

question asked: 28 Apr, 05:20

question was seen: 138 times

last updated: yesterday