I am very new to SQL Anywhere. I have been working with SQL Server for a long time.
In SQL Server, if we need to see the list of database under server, we can see that under Server Explorer.
How can I do same in SQL Anywhere?
I have just installed SQL Anywhere 16 and have no idea how to find S...
I have followed the link and others link from this site to solve my problem but I still have not solved the problem. All I get is the following:
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Windows\system32>sqlplus /nolog
SQL*Plus: Rel...
I have an insert statement that is being generated by the .NET Entity Framework. In most cases, this particular insert will execute in 0ms according SQL Server Profiler. One out of every 30 or so inserts will jump to as high as 12 seconds duration, causing the .NET client on the other end to sh...
but, yes, deleted questions are removed from this room after they've been deleted.
so anything you see here is "to be deleted", if you agree the question has no merit and should be deleted.
@McNets luckily, clicking a one-boxed question in here results in a new tab being opened in your browser - if you see you've already voted to delete or whatever, you can just close the tab and move on. I tend to start at the bottom of the room (the most recent messages), and work upwards until I see a question I've already voted on.
cheers! Also, we tend to be pretty aggressive about moving chatty messages into the trash; don't be alarmed, we just like to keep the "fluff" to a minimum.
This question is related to the following 2 SQL errors (line breaks added by me)
MySql.Data.MySqlClient.MySqlException (0x80004005):
Expression #2 of ORDER BY clause is not in SELECT list, references column 'auitool2014.a.prog' which is not in SELECT list;
this is incompatible with DISTINCT
My...
@ypercubeᵀᴹ is there a possibility of a good answer?
seems to me that the only answer would be "write your group-by clauses correctly." which probably isn't much help, since ostensibly you'd already know that you should do that if you see the error.
I am very new to SQL Anywhere. I have been working with SQL Server for a long time.
In SQL Server, if we need to see the list of database under server, we can see that under Server Explorer.
How can I do same in SQL Anywhere?
I have just installed SQL Anywhere 16 and have no idea how to find S...
I have followed the link and others link from this site to solve my problem but I still have not solved the problem. All I get is the following:
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Windows\system32>sqlplus /nolog
SQL*Plus: Rel...
I have an insert statement that is being generated by the .NET Entity Framework. In most cases, this particular insert will execute in 0ms according SQL Server Profiler. One out of every 30 or so inserts will jump to as high as 12 seconds duration, causing the .NET client on the other end to sh...
