former_SQLA_member1694900
Participant
Member since ‎2012 May 25

User Statistics

  • 33 Posts
  • 0 Solutions
  • 161 Kudos given
  • 29 Kudos received

User Activity

Why is DESCRIPTION colored as if it were a reserved word in Interactive SQL

2020 Feb 06
Hi, I thought DESCRIPTION is a reserved word. That would explain why it is colored in Interactive SQL to indicate that it is a keyword. However, it looks that it is not a reserved keyword because the following only returns 'desc': select * from sa...

Odbc driver issue with SQLA17

2018 Sep 05
Hi, I have a client app using ODBC to connect to an SQLA17 database. The client calls a procedure that performs an INSERT on a table. There is one column on that table defined as UNIQUEIDENTIFIER. For that column, the client passes in a COALESCE('A ...

Cast to DECIMAL with a variable scale

2016 Mar 17
Here is a simple example: BEGIN DECLARE three INTEGER; SET three = 3; -- Working SELECT CAST(32.3369 as DECIMAL(30, 3)); -- Not working --SELECT CAST(32.3369 as DECIMAL(30, three)); END Is there a way to cast a decimal to a var...

ADO .NET Provider MissingMethodException

2016 Feb 18
Hello, I built a Windows Service that tries to connect to a SA 16 database server (64bit) running on a 64bit Windows Server 2008 R2 (with full .Net framework 4.5) and it fails to open a connection: *Connect : System.MissingMethodException: Method n...

Format SQL in Interactive SQL

2015 Oct 09
Is it possible to auto-format the sql code when copy-pasted into Interactive SQL?
View more