User bernd_k

9 votes

4 answers

47k views

How to drop SQL Server database currently in use and in Single user mode

asked Sep 6, 2013 at 9:17

3 votes

2 answers

792 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

1 vote

1 answer

2k views

What is the replacement for EXEC sp_dboption <dbname> in SQL Server 2012?

asked Mar 11, 2012 at 8:02

5 votes

2 answers

704 views

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

asked Mar 1, 2012 at 8:03

4 votes

1 answer

3k views

Has somebody got a function that will extend hashbytes to strings of arbitrary length?

asked Jan 4, 2012 at 9:38

1 vote

1 answer

2k views

Isn't a tab (char(9) ) whitespace in the ANSI/ISO SQL-92 specification (Section 8.2, , General rules #3)?

asked Dec 22, 2011 at 9:55

7 votes

1 answer

10k views

How to write a check constraint to disallow empty varchar fields?

asked Dec 21, 2011 at 15:25

18 votes

1 answer

7k views

Empty Strings: Why or when is '' equal to ' '?

asked Dec 20, 2011 at 12:08

23 votes

2 answers

74k views

How to catch and handle only specific Oracle exceptions?

asked Dec 20, 2011 at 6:56

3 votes

2 answers

18k views

How is localhost resolved by Oracle listener?

asked Dec 3, 2011 at 18:40

13 votes

2 answers

144k views

How to configure an Oracle Listener without SID_LIST_LISTENER in listener.ora?

asked Nov 27, 2011 at 9:21

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

4 votes

3 answers

3k views

Are there ways to only replace SQL Server stored procedures when the definition has changed?

asked Oct 31, 2011 at 13:21

6 votes

2 answers

2k views

Are there any reasons not enable SQLCMD-mode as default in SSMS?

asked Oct 31, 2011 at 7:42

3 votes

1 answer

8k views

How can I query the SQL Server Compatibility Level into a variable?

asked Oct 27, 2011 at 8:27

0 votes

1 answer

282 views

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

asked Oct 24, 2011 at 18:07

3 votes

3 answers

7k views

Login Problem as SYSDBA ORA-01031

asked Sep 29, 2011 at 10:26

7 votes

1 answer

40k views

How to query given grants on Oracle?

asked Sep 20, 2011 at 10:45

5 votes

3 answers

26k views

How to replace a CLOB column by a varchar2(4000) column?

asked Sep 19, 2011 at 13:48

5 votes

1 answer

3k views

Which workarounds exists to missing relative path feature of SQLCMD :r?

asked Sep 12, 2011 at 7:27

2 votes

1 answer

199 views

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

asked Sep 7, 2011 at 7:38

19 votes

2 answers

29k views

Can I enable SQLCMD mode from inside a script?

asked Sep 7, 2011 at 5:59

4 votes

2 answers

3k views

Has SELECT an INSERT clause?

asked Sep 7, 2011 at 5:32

2 votes

1 answer

261 views

What are hypothetical indexes?

asked Sep 6, 2011 at 12:31

7 votes

2 answers

24k views

What is the meaning of Microsoft Compatibility Level?

asked Aug 29, 2011 at 13:06

4 votes

4 answers

515 views

How implement a cancel attribute in a table?

asked Aug 22, 2011 at 15:54

2 votes

1 answer

374 views

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

asked Aug 20, 2011 at 8:31

5 votes

3 answers

558 views

Using DTA vs. evaluating DMVs?

asked Aug 7, 2011 at 10:24

24 votes

1 answer

16k views

How to use transactions with SQL Server DDL?

asked Aug 5, 2011 at 6:20

3 votes

2 answers

4k views

Is it possible with SQL Server 2008 to have a Partioned Tables with an Identity Column?

asked Jul 27, 2011 at 5:46

Stack Exchange Network

88 Questions

How to drop SQL Server database currently in use and in Single user mode

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

What is the replacement for EXEC sp_dboption <dbname> in SQL Server 2012?

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

Has somebody got a function that will extend hashbytes to strings of arbitrary length?

Isn't a tab (char(9) ) whitespace in the ANSI/ISO SQL-92 specification (Section 8.2, , General rules #3)?

How to write a check constraint to disallow empty varchar fields?

Empty Strings: Why or when is '' equal to ' '?

How to catch and handle only specific Oracle exceptions?

How is localhost resolved by Oracle listener?

How to configure an Oracle Listener without SID_LIST_LISTENER in listener.ora?

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

Are there ways to only replace SQL Server stored procedures when the definition has changed?

Are there any reasons not enable SQLCMD-mode as default in SSMS?

How can I query the SQL Server Compatibility Level into a variable?

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

Login Problem as SYSDBA ORA-01031

How to query given grants on Oracle?

How to replace a CLOB column by a varchar2(4000) column?

Which workarounds exists to missing relative path feature of SQLCMD :r?

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

Can I enable SQLCMD mode from inside a script?

Has SELECT an INSERT clause?

What are hypothetical indexes?

What is the meaning of Microsoft Compatibility Level?

How implement a cancel attribute in a table?

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

Using DTA vs. evaluating DMVs?

How to use transactions with SQL Server DDL?

Is it possible with SQL Server 2008 to have a Partioned Tables with an Identity Column?