User bernd_k

7 votes

1 answer

10k views

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

asked Dec 21, 2011 at 15:25

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

6 votes

1 answer

2k views

Guarantee SQL Server Identity Columns that two consecutive values differ by constant increments?

asked Jul 19, 2011 at 12:45

6 votes

1 answer

9k views

How to combine date and time to datetime in SQL Server?

asked Feb 25, 2011 at 12:36

6 votes

1 answer

207 views

In a Trigger, can I determine if a column was explicitly set to a values or not mentioned in update statement?

asked Mar 7, 2011 at 19:08

6 votes

2 answers

2k views

Can I call SMO from pure T-SQL?

asked Mar 10, 2011 at 13:32

6 votes

3 answers

4k views

Building Dynamic SQL-Server Where Clause

asked Jan 22, 2011 at 13:33

6 votes

1 answer

294 views

Are there tools for SQL-Server helping to add the semicolons?

asked Jan 4, 2011 at 11:21

5 votes

2 answers

250 views

Are there other sites forbidding SQL developer to use c style comments?

asked Mar 12, 2011 at 9:19

5 votes

4 answers

5k views

Which problems arise, declaring the size of all varchar parameters as max in stored proc?

asked Mar 16, 2011 at 15:59

5 votes

1 answer

1k views

Which fillfactor is used by ALTER INDEX REBUILD?

asked Mar 8, 2011 at 7:43

5 votes

1 answer

2k views

Why is this rollback needed when using sp_addextendedproperty in a stored procedure?

asked Apr 10, 2011 at 6:59

5 votes

1 answer

720 views

Which is the most performant way to copy a number of SQL Server tables to a readonly SQLite database?

asked Apr 29, 2011 at 17:50

5 votes

3 answers

558 views

Using DTA vs. evaluating DMVs?

asked Aug 7, 2011 at 10:24

5 votes

1 answer

3k views

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

asked Sep 12, 2011 at 7:27

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

2 answers

701 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

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

4 votes

2 answers

3k views

Has SELECT an INSERT clause?

asked Sep 7, 2011 at 5:32

4 votes

2 answers

14k views

How to export a single huge table from SQL Server?

asked Jul 23, 2011 at 16:13

4 votes

4 answers

513 views

How implement a cancel attribute in a table?

asked Aug 22, 2011 at 15:54

4 votes

1 answer

7k views

What does TOAD do, when I terminate script execution?

asked May 2, 2011 at 9:40

4 votes

2 answers

927 views

How can I extract a lessequal char from SQL_Latin1_General_CP1_CI_AS?

asked Apr 13, 2011 at 14:06

4 votes

2 answers

4k views

What are the benefits of using a different tablespace for a new user schema?

asked May 7, 2011 at 7:38

4 votes

2 answers

2k views

How to query status changes in time series?

asked Jun 21, 2011 at 16:24

4 votes

3 answers

1k views

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

asked Mar 30, 2011 at 14:49

4 votes

3 answers

17k views

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

asked Mar 31, 2011 at 13:03

4 votes

1 answer

209 views

Can I determine if a stored procedure uses dynamic sql without parsing the definition?

asked Mar 13, 2011 at 12:27

4 votes

2 answers

36 views

What can I do to find out since which release a given DBMS supports a feature, function, etc?

asked Jan 7, 2011 at 14:33

Stack Exchange Network

88 Questions

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

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

Guarantee SQL Server Identity Columns that two consecutive values differ by constant increments?

How to combine date and time to datetime in SQL Server?

In a Trigger, can I determine if a column was explicitly set to a values or not mentioned in update statement?

Can I call SMO from pure T-SQL?

Building Dynamic SQL-Server Where Clause

Are there tools for SQL-Server helping to add the semicolons?

Are there other sites forbidding SQL developer to use c style comments?

Which problems arise, declaring the size of all varchar parameters as max in stored proc?

Which fillfactor is used by ALTER INDEX REBUILD?

Why is this rollback needed when using sp_addextendedproperty in a stored procedure?

Which is the most performant way to copy a number of SQL Server tables to a readonly SQLite database?

Using DTA vs. evaluating DMVs?

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

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

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?

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

Has SELECT an INSERT clause?

How to export a single huge table from SQL Server?

How implement a cancel attribute in a table?

What does TOAD do, when I terminate script execution?

How can I extract a lessequal char from SQL_Latin1_General_CP1_CI_AS?

What are the benefits of using a different tablespace for a new user schema?

How to query status changes in time series?

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

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

Can I determine if a stored procedure uses dynamic sql without parsing the definition?

What can I do to find out since which release a given DBMS supports a feature, function, etc?