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

3 votes

1 answer

1k views

Casesensitive vs. Caseinsensitive Collatesequences?

asked Apr 24, 2011 at 9:45

5 votes

1 answer

1k views

Which fillfactor is used by ALTER INDEX REBUILD?

asked Mar 8, 2011 at 7:43

4 votes

2 answers

965 views

How can I extract a lessequal char from SQL_Latin1_General_CP1_CI_AS?

asked Apr 13, 2011 at 14:06

3 votes

2 answers

806 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

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

5 votes

2 answers

714 views

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

asked Mar 1, 2012 at 8:03

1 vote

1 answer

642 views

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

asked Jun 24, 2011 at 11:47

5 votes

3 answers

560 views

Using DTA vs. evaluating DMVs?

asked Aug 7, 2011 at 10:24

4 votes

2 answers

531 views

How to compare performance of two versions of a function?

asked Jan 11, 2011 at 10:09

4 votes

4 answers

519 views

How implement a cancel attribute in a table?

asked Aug 22, 2011 at 15:54

2 votes

1 answer

377 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

301 views

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

asked Jan 4, 2011 at 11:21

0 votes

1 answer

287 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

261 views

What are hypothetical indexes?

asked Sep 6, 2011 at 12:31

5 votes

2 answers

250 views

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

asked Mar 12, 2011 at 9:19

3 votes

1 answer

239 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

233 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

4 votes

1 answer

210 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

208 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

2 votes

1 answer

207 views

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

asked Sep 7, 2011 at 7:38

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

148 views

Can SQL profiles be deployed to other Oracle Databases?

asked May 16, 2011 at 10:48

4 votes

2 answers

38 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]

Casesensitive vs. Caseinsensitive Collatesequences?

Which fillfactor is used by ALTER INDEX REBUILD?

How can I extract a lessequal char from SQL_Latin1_General_CP1_CI_AS?

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

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

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

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

Using DTA vs. evaluating DMVs?

How to compare performance of two versions of a function?

How implement a cancel attribute in a table?

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?

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?

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

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?