Skip to main content
bernd_k's user avatar
bernd_k's user avatar
bernd_k's user avatar
bernd_k
  • Member for 13 years, 6 months
  • Last seen more than 10 years ago
9 votes
4 answers
48k views

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

3 votes
2 answers
836 views

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

1 vote
1 answer
2k views

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

5 votes
2 answers
735 views

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

4 votes
1 answer
3k views

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

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)?

7 votes
1 answer
10k views

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

19 votes
1 answer
8k views

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

24 votes
2 answers
77k views

How to catch and handle only specific Oracle exceptions?

3 votes
2 answers
18k views

How is localhost resolved by Oracle listener?

13 votes
2 answers
145k views

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

0 votes
1 answer
150 views

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

4 votes
3 answers
3k views

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

6 votes
2 answers
2k views

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

3 votes
1 answer
8k views

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

0 votes
1 answer
296 views

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

3 votes
3 answers
7k views

Login Problem as SYSDBA ORA-01031

7 votes
1 answer
41k views

How to query given grants on Oracle?

5 votes
3 answers
27k views

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

5 votes
1 answer
3k views

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

2 votes
1 answer
220 views

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

19 votes
2 answers
30k views

Can I enable SQLCMD mode from inside a script?

4 votes
2 answers
3k views

Has SELECT an INSERT clause?

2 votes
1 answer
269 views

What are hypothetical indexes?

7 votes
2 answers
24k views

What is the meaning of Microsoft Compatibility Level?

4 votes
4 answers
565 views

How implement a cancel attribute in a table?

2 votes
1 answer
383 views

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

5 votes
3 answers
565 views

Using DTA vs. evaluating DMVs?

25 votes
1 answer
17k views

How to use transactions with SQL Server DDL?

3 votes
2 answers
4k views

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