User bernd_k

0 votes

2 answers

1k views

Is where x = 0 or x is null to be replaced by where isnull(x, 0) = 0 resp. where NVL(x, 0) = 0

asked Feb 25, 2011 at 9:03

4 votes

3 answers

1k views

How can I fix the Oracle syntax of this update by the result of a select in Oracle 10g?

asked Mar 30, 2011 at 14:49

8 votes

2 answers

1k views

Is this a new common pattern in Oracle Where exists ( Select NULL FROM...)?

asked Jan 5, 2011 at 16:11

12 votes

6 answers

1k views

Did anybody use sqlcmd mode in practice? [closed]

asked Jan 9, 2011 at 13:54

4 votes

2 answers

1k views

How can I extract a lessequal char from SQL_Latin1_General_CP1_CI_AS?

asked Apr 13, 2011 at 14:06

5 votes

1 answer

1k views

Which fillfactor is used by ALTER INDEX REBUILD?

asked Mar 8, 2011 at 7:43

3 votes

1 answer

1k views

Casesensitive vs. Caseinsensitive Collatesequences?

asked Apr 24, 2011 at 9:45

3 votes

2 answers

844 views

How can I test sql scripts intended to run with sqlcmd -v in Sql Server Management Studio

asked Aug 24, 2012 at 10:33

5 votes

2 answers

736 views

Is there a setting to force an error when asigning a varchar longer than a variable?

asked Mar 1, 2012 at 8:03

5 votes

1 answer

720 views

Which is the most performant way to copy a number of SQL Server tables to a readonly SQLite database?

asked Apr 29, 2011 at 17:50

1 vote

1 answer

643 views

Performance problem caused by joining with the result of a scalar function?

asked Jun 24, 2011 at 11:47

4 votes

2 answers

576 views

How to compare performance of two versions of a function?

asked Jan 11, 2011 at 10:09

4 votes

4 answers

571 views

How implement a cancel attribute in a table?

asked Aug 22, 2011 at 15:54

5 votes

3 answers

566 views

Using DTA vs. evaluating DMVs?

asked Aug 7, 2011 at 10:24

2 votes

1 answer

386 views

Where to put glogon.sql in 32-bit ODAC (11.2.0.2.1)?

asked Aug 20, 2011 at 8:31

3 votes

2 answers

377 views

Is there a setting to suppress C-Style comments appearing as DOC in Oracle Output?

asked Jun 22, 2011 at 6:33

6 votes

1 answer

321 views

Are there tools for SQL-Server helping to add the semicolons?

asked Jan 4, 2011 at 11:21

0 votes

1 answer

297 views

How to find "outer join in the where" syntax in SQL 2005 using cmptlevel 80?

asked Oct 24, 2011 at 18:07

2 votes

1 answer

270 views

What are hypothetical indexes?

asked Sep 6, 2011 at 12:31

5 votes

2 answers

256 views

Are there other sites forbidding SQL developer to use c style comments?

asked Mar 12, 2011 at 9:19

3 votes

1 answer

249 views

Is there a way to load a sql script with a specified encoding into a running SQL Server Management Studio (SSMS)?

asked May 3, 2011 at 6:15

11 votes

2 answers

234 views

Is there anybody using the SQL Server feature to create groups of stored procedures differentiated by number?

asked Jan 7, 2011 at 15:36

2 votes

1 answer

222 views

SQLCMDMODE from SSMS. Can I set -b mode when using :r to include files?

asked Sep 7, 2011 at 7:38

4 votes

1 answer

212 views

Can I determine if a stored procedure uses dynamic sql without parsing the definition?

asked Mar 13, 2011 at 12:27

6 votes

1 answer

212 views

In a Trigger, can I determine if a column was explicitly set to a values or not mentioned in update statement?

asked Mar 7, 2011 at 19:08

0 votes

1 answer

150 views

What is the rationale for requiring a column list when inserting into a table with identity column?

asked Nov 21, 2011 at 12:44

2 votes

1 answer

149 views

Can SQL profiles be deployed to other Oracle Databases?

asked May 16, 2011 at 10:48

4 votes

2 answers

39 views

What can I do to find out since which release a given DBMS supports a feature, function, etc?

asked Jan 7, 2011 at 14:33

Stack Exchange Network

88 Questions

Is where x = 0 or x is null to be replaced by where isnull(x, 0) = 0 resp. where NVL(x, 0) = 0

How can I fix the Oracle syntax of this update by the result of a select in Oracle 10g?

Is this a new common pattern in Oracle Where exists ( Select NULL FROM...)?

Did anybody use sqlcmd mode in practice? [closed]

How can I extract a lessequal char from SQL_Latin1_General_CP1_CI_AS?

Which fillfactor is used by ALTER INDEX REBUILD?

Casesensitive vs. Caseinsensitive Collatesequences?

How can I test sql scripts intended to run with sqlcmd -v in Sql Server Management Studio

Is there a setting to force an error when asigning a varchar longer than a variable?

Which is the most performant way to copy a number of SQL Server tables to a readonly SQLite database?

Performance problem caused by joining with the result of a scalar function?

How to compare performance of two versions of a function?

How implement a cancel attribute in a table?

Using DTA vs. evaluating DMVs?

Where to put glogon.sql in 32-bit ODAC (11.2.0.2.1)?

Is there a setting to suppress C-Style comments appearing as DOC in Oracle Output?

Are there tools for SQL-Server helping to add the semicolons?

How to find "outer join in the where" syntax in SQL 2005 using cmptlevel 80?

What are hypothetical indexes?

Are there other sites forbidding SQL developer to use c style comments?

Is there a way to load a sql script with a specified encoding into a running SQL Server Management Studio (SSMS)?

Is there anybody using the SQL Server feature to create groups of stored procedures differentiated by number?

SQLCMDMODE from SSMS. Can I set -b mode when using :r to include files?

Can I determine if a stored procedure uses dynamic sql without parsing the definition?

In a Trigger, can I determine if a column was explicitly set to a values or not mentioned in update statement?

What is the rationale for requiring a column list when inserting into a table with identity column?

Can SQL profiles be deployed to other Oracle Databases?

What can I do to find out since which release a given DBMS supports a feature, function, etc?