Recent questions tagged sql - Knowledge Base

0 votes

1 answer 1.3K views

How to convert a 'Standard Query' to a 'Parameterized Query'?

asked Dec 3, 2016 by rich-c-2789 (16,240 points)

0 votes

1 answer 881 views

How can I quote or unquote a multi-line block of text?

asked Nov 29, 2016 by mike-r-7535 (13,830 points)

0 votes

1 answer 8.8K views

Error: "The conversion from UNKNOWN to UNKNOWN is unsupported." when using pQuery.setObject() with a java.util.Date

asked Nov 29, 2016 by rich-c-2789 (16,240 points)

0 votes

1 answer 661 views

Is it possible use a variable in a DB query?

asked Jun 24, 2015 by terrie-g-7436 (3,950 points)

0 votes

1 answer 363 views

I am getting an Admin Alert “It appears that MySQL or MariaDB is not configured properly..." What does this mean?

asked Jun 15, 2015 by amanda-w-3695 (4,840 points)

0 votes

1 answer 3.4K views

ORA-O6575: package or function _____ is in invalid state.

asked May 20, 2015 by rich-c-2789 (16,240 points)

0 votes

3 answers 3.0K views

How can I change the CLINICALDATE from Centricity document into a date?

asked Mar 24, 2015 by mike-r-7535 (13,830 points)

0 votes

1 answer 528 views

How to use QIE with TDE(Transparent Data Encryption) on MS SQL Server

asked Jun 26, 2014 by rich-c-2789 (16,240 points)

0 votes

1 answer 3.2K views

What does "Function created with compilation errors" mean when I try to install stored procedures in EMR

asked Mar 11, 2014 by rich-c-2789 (16,240 points)

0 votes

1 answer 618 views

How to find missing indexes in SQL Server

asked Nov 13, 2013 by rich-c-2789 (16,240 points)

0 votes

1 answer 2.2K views

Query table with multiple foreign keys to the same table

asked Oct 7, 2013 by rich-c-2789 (16,240 points)

0 votes

1 answer 451 views

Does Qvera support Microsoft SQL Server V8.0

asked Aug 12, 2013 by brandon-w-8204 (33,270 points)

0 votes

1 answer 7.0K views

Can I get the current date from the datebase?

asked Jul 19, 2013 by rich-c-2789 (16,240 points)

0 votes

1 answer 292 views

How can I check a column in a database to see if it contains unique data.

asked Jul 9, 2013 by rich-c-2789 (16,240 points)

+2 votes

1 answer 218.9K views

How to compare dates in an SQL query without the time (get all records for a date ignoring time)?

asked Jul 4, 2013 by rich-c-2789 (16,240 points)