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
7 votes
1 answer
10k views

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

6 votes
2 answers
2k views

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

6 votes
1 answer
2k views

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

6 votes
1 answer
9k views

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

6 votes
1 answer
210 views

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

6 votes
2 answers
2k views

Can I call SMO from pure T-SQL?

6 votes
3 answers
4k views

Building Dynamic SQL-Server Where Clause

6 votes
1 answer
317 views

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

5 votes
2 answers
256 views

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

5 votes
4 answers
5k views

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

5 votes
1 answer
1k views

Which fillfactor is used by ALTER INDEX REBUILD?

5 votes
1 answer
2k views

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

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?

5 votes
3 answers
565 views

Using DTA vs. evaluating DMVs?

5 votes
1 answer
3k views

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

5 votes
3 answers
27k views

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

5 votes
2 answers
734 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?

4 votes
3 answers
3k views

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

4 votes
2 answers
3k views

Has SELECT an INSERT clause?

4 votes
2 answers
14k views

How to export a single huge table from SQL Server?

4 votes
4 answers
564 views

How implement a cancel attribute in a table?

4 votes
1 answer
7k views

What does TOAD do, when I terminate script execution?

4 votes
2 answers
1k views

How can I extract a lessequal char from SQL_Latin1_General_CP1_CI_AS?

4 votes
2 answers
4k views

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

4 votes
2 answers
2k views

How to query status changes in time series?

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?

4 votes
3 answers
17k views

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

4 votes
1 answer
212 views

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

4 votes
2 answers
39 views

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