User bernd_k

6 votes

Accepted

Migrating from NTEXT to NVARCHAR(MAX)

answered Feb 17, 2011 at 17:25

28 votes

When to use NULL and when to use an empty string?

answered Jan 4, 2011 at 9:00

5 votes

How to move data from big table

answered Oct 20, 2011 at 4:53

3 votes

How do I copy a table with SELECT INTO but ignore the IDENTITY property?

answered Feb 13, 2011 at 14:22

27 votes

How do you document your databases?

answered Mar 4, 2011 at 21:04

11 votes

Accepted

In Oracle how do I save a sequence.nextval in a variable to be reused in multiple inserts?

answered May 27, 2011 at 12:11

4 votes

create incremental number in oracle sql query

answered Jun 3, 2011 at 5:16

4 votes

Is there a concept of an "include file" in SQL Server?

answered Feb 25, 2012 at 10:40

0 votes

NULLs in a composite primary key - SQL Server

answered Dec 27, 2011 at 8:20

0 votes

Is Using Execute Immediate Bad Practice in Oracle?

answered Dec 19, 2011 at 17:14

37 votes

How do I copy a table with SELECT INTO but ignore the IDENTITY property?

answered Jan 27, 2011 at 6:41

1 vote

Oracle bitand inconsistent behaviour

answered Nov 14, 2011 at 18:49

8 votes

Should I use SQL JOIN or IN Clause?

answered Oct 29, 2011 at 9:15

4 votes

How do I create a database+tablespace+user in Oracle 11gR2?

answered Oct 11, 2011 at 5:13

3 votes

What are the minimum matching criteria recommended for reliable demographic based patient matching?

answered Oct 20, 2011 at 11:08

4 votes

Accepted

Restore Database from Network Drive

answered Oct 11, 2011 at 11:56

3 votes

Accepted

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

answered Aug 21, 2011 at 11:16

6 votes

Does NULL have a type?

answered Aug 6, 2011 at 12:56

3 votes

Accepted

Cartesian Product SQL / Inserts with multiple Values Clauses

answered Jun 23, 2011 at 14:51

3 votes

What are the consequences of setting varchar(8000)?

answered Jun 5, 2011 at 6:21

3 votes

SELECT statement with an explicit list of columns and then an asterisk (*)

answered May 30, 2011 at 11:58

0 votes

What could be the reason for disallowing a sub query in the values clause?

answered May 29, 2011 at 7:14

4 votes

Accepted

I get ORA-13605 when trying to run SQL Tuning Advisor from SQL Developer

answered May 16, 2011 at 9:56

4 votes

Alternatives to concatenating strings or going procedural to prevent SQL query code repetition?

answered May 15, 2011 at 11:11

2 votes

Accepted

Should SQL full text search match the value test2 when searching for test?

answered May 14, 2011 at 17:59

6 votes

Accepted

MAX for each subset

answered Apr 25, 2011 at 12:25

1 vote

How to convert a Top 1 subquery using outer table alias to Oracle?

answered Apr 20, 2011 at 17:22

2 votes

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

answered Mar 31, 2011 at 5:17

2 votes

How do long columns impact performance and disk usage?

answered Mar 16, 2011 at 14:16

5 votes

Multidimensional indices in databases

answered Mar 15, 2011 at 16:23

Stack Exchange Network

51 Answers

Migrating from NTEXT to NVARCHAR(MAX)

When to use NULL and when to use an empty string?

How to move data from big table

How do I copy a table with SELECT INTO but ignore the IDENTITY property?

How do you document your databases?

In Oracle how do I save a sequence.nextval in a variable to be reused in multiple inserts?

create incremental number in oracle sql query

Is there a concept of an "include file" in SQL Server?

NULLs in a composite primary key - SQL Server

Is Using Execute Immediate Bad Practice in Oracle?

How do I copy a table with SELECT INTO but ignore the IDENTITY property?

Oracle bitand inconsistent behaviour

Should I use SQL JOIN or IN Clause?

How do I create a database+tablespace+user in Oracle 11gR2?

What are the minimum matching criteria recommended for reliable demographic based patient matching?

Restore Database from Network Drive

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

Does NULL have a type?

Cartesian Product SQL / Inserts with multiple Values Clauses

What are the consequences of setting varchar(8000)?

SELECT statement with an explicit list of columns and then an asterisk (*)

What could be the reason for disallowing a sub query in the values clause?

I get ORA-13605 when trying to run SQL Tuning Advisor from SQL Developer

Alternatives to concatenating strings or going procedural to prevent SQL query code repetition?

Should SQL full text search match the value test2 when searching for test?

MAX for each subset

How to convert a Top 1 subquery using outer table alias to Oracle?

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

How do long columns impact performance and disk usage?

Multidimensional indices in databases