Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more
bernd_k's user avatar
bernd_k's user avatar
bernd_k's user avatar
bernd_k
  • Member for 13 years, 4 months
  • Last seen more than 10 years ago
37 votes

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

28 votes

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

27 votes

How do you document your databases?

11 votes
Accepted

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

11 votes

Peculiar Oracle outer join syntax case

8 votes

Should I use SQL JOIN or IN Clause?

6 votes

Does NULL have a type?

6 votes
Accepted

MAX for each subset

6 votes
Accepted

Migrating from NTEXT to NVARCHAR(MAX)

5 votes

What standard should I follow when naming tables and views?

5 votes

Multidimensional indices in databases

5 votes

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

5 votes

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

5 votes

How to move data from big table

4 votes

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

4 votes
Accepted

Restore Database from Network Drive

4 votes

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

4 votes

create incremental number in oracle sql query

4 votes
Accepted

truncate table for all db in sql server 2000

4 votes

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

4 votes

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

4 votes

The Value of Certifications

4 votes

Group data by non-unique keys by distinct time range

4 votes

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

4 votes
Accepted

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

3 votes

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

3 votes

Passing array parameters to a stored procedure

3 votes

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

3 votes
Accepted

Implementing a PIVOT query

3 votes

What are the consequences of setting varchar(8000)?