User bernd_k

37 votes

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

answered Jan 27, 2011 at 6:41

28 votes

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

answered Jan 4, 2011 at 9:00

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

11 votes

Peculiar Oracle outer join syntax case

answered Jan 8, 2011 at 16:13

8 votes

Should I use SQL JOIN or IN Clause?

answered Oct 29, 2011 at 9:15

6 votes

Accepted

MAX for each subset

answered Apr 25, 2011 at 12:25

6 votes

Accepted

Migrating from NTEXT to NVARCHAR(MAX)

answered Feb 17, 2011 at 17:25

5 votes

What standard should I follow when naming tables and views?

answered Mar 8, 2011 at 21:32

5 votes

Multidimensional indices in databases

answered Mar 15, 2011 at 16:23

5 votes

What is an effective way of labeling columns in a database?

answered Jan 4, 2011 at 9:33

5 votes

How to get rid of ORA-28002 message the password will expire within 6 days?

answered Jan 17, 2011 at 18:22

5 votes

Does NULL have a type?

answered Aug 6, 2011 at 12:56

5 votes

How to move data from big table

answered Oct 20, 2011 at 4:53

4 votes

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

answered Oct 11, 2011 at 5:13

4 votes

Accepted

Restore Database from Network Drive

answered Oct 11, 2011 at 11:56

4 votes

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

answered Feb 25, 2012 at 10:40

4 votes

create incremental number in oracle sql query

answered Jun 3, 2011 at 5:16

4 votes

Accepted

truncate table for all db in sql server 2000

answered Feb 13, 2011 at 13:10

4 votes

Moving tables to another SQL2008 database (including indexes, triggers, etc.)

answered Feb 13, 2011 at 15:48

4 votes

What is the difference between an INNER JOIN and an OUTER JOIN ?

answered Jan 4, 2011 at 14:14

4 votes

The Value of Certifications

answered Jan 5, 2011 at 10:49

4 votes

Group data by non-unique keys by distinct time range

answered Feb 19, 2011 at 12:36

4 votes

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

answered May 15, 2011 at 11:11

4 votes

Accepted

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

answered May 16, 2011 at 9:56

3 votes

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

answered May 30, 2011 at 11:58

3 votes

Passing array parameters to a stored procedure

answered Jan 16, 2011 at 17:02

3 votes

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

answered Feb 13, 2011 at 14:22

3 votes

Accepted

Implementing a PIVOT query

answered Feb 12, 2011 at 15:50

3 votes

What are the consequences of setting varchar(8000)?

answered Jun 5, 2011 at 6:21

Stack Exchange Network

51 Answers

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

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

How do you document your databases?

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

Peculiar Oracle outer join syntax case

Should I use SQL JOIN or IN Clause?

MAX for each subset

Migrating from NTEXT to NVARCHAR(MAX)

What standard should I follow when naming tables and views?

Multidimensional indices in databases

What is an effective way of labeling columns in a database?

How to get rid of ORA-28002 message the password will expire within 6 days?

Does NULL have a type?

How to move data from big table

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

Restore Database from Network Drive

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

create incremental number in oracle sql query

truncate table for all db in sql server 2000

Moving tables to another SQL2008 database (including indexes, triggers, etc.)

What is the difference between an INNER JOIN and an OUTER JOIN ?

The Value of Certifications

Group data by non-unique keys by distinct time range

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

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

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

Passing array parameters to a stored procedure

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

Implementing a PIVOT query

What are the consequences of setting varchar(8000)?