Stack Exchange

Cade Roux

New Orleans, LA, United States

http://www.caderoux.com

Stack Overflow CV

top accounts reputation activity bookmarks subscriptions
Top Questions
207 votes

Most efficient T-SQL way to pad a varchar on the left to a certain length?

sql sql-server tsql asked Sep 23 '08 at 15:46
stackoverflow.com

166 votes

Better techniques for trimming leading zeros in SQL Server?

sql sql-server sql-server-2005 tsql string asked Mar 19 '09 at 14:16
stackoverflow.com

69 votes

Is bribing children with cash incentives a good idea?

behavior discipline money reward asked Mar 29 '11 at 21:40
parenting.stackexchange.com

69 votes

Which SD cards are compatible?

sd-card compatibility asked Jun 12 '12 at 19:55
raspberrypi.stackexchange.com

54 votes

Best way to reset an Oracle sequence to the next value in an existing column?

sql oracle oracle10g primary-key sequence asked May 23 '11 at 15:08
stackoverflow.com

53 votes

SSMS Results to Grid - CRLF not preserved in copy/paste - any better techniques?

sql-server formatting ssms asked Apr 20 '10 at 23:53
stackoverflow.com

29 votes

Using conditional (?:) operator for method selection in C# (3.0)?

c# .net .net-3.5 asked Mar 3 '11 at 20:52
stackoverflow.com

25 votes

How to build RUNAS /NETONLY functionality into a (C#/.NET/WinForms) program?

.net sql-server security authentication runas asked Apr 16 '09 at 20:11
stackoverflow.com

25 votes

Portable system for syncing files (like DropBox)?

file-sharing asked Jul 14 '12 at 5:43
raspberrypi.stackexchange.com

18 votes

Efficient ISNUMERIC() replacements on SQL Server?

sql-server user-defined-functions isnumeric asked Nov 23 '08 at 2:54
stackoverflow.com

1 2 3 4 5 … 7

Top Answers
251
Create a date from day month and year with T-SQL
stackoverflow.com

178
Create a date from day month and year with T-SQL
stackoverflow.com

164
Condition within JOIN or WHERE
stackoverflow.com

149
SQL JOIN - WHERE clause vs. ON clause
stackoverflow.com

148
T-SQL: Opposite to string concatenation - how to split string into multiple records
stackoverflow.com

117
When must we use NVARCHAR/NCHAR instead of VARCHAR/CHAR in SQL Server?
stackoverflow.com

84
How to update one table based on another table's values on the fly?
dba.stackexchange.com

84
Multiple Indexes vs Multi-Column Indexes
stackoverflow.com

84
C# SQL Top as parameter
stackoverflow.com

82
Is Big O(logn) log base e?
stackoverflow.com

81
How do you document your databases?
dba.stackexchange.com

68
INNER JOIN ON vs WHERE clause
stackoverflow.com

60
How to insert one column into other column within the same table in SQL Server
stackoverflow.com

60
Is there a way to disable a SQL Server trigger for just a particular scope of execution?
stackoverflow.com

57
OR is not supported with CASE Statement in SQL Server
stackoverflow.com

52
Execute table-valued function on multiple rows?
stackoverflow.com

52
Worst UI You've Ever Used
stackoverflow.com

50
Is there a way to suppress “x rows affected” in SQLCMD from the command line?
stackoverflow.com

50
When is a good situation to use a full outer join?
stackoverflow.com

46
Foreign key restrictions -> yes or no?
softwareengineering.stackexchange.com

45
What are the main performance differences between varchar and nvarchar SQL Server data types?
stackoverflow.com

45
Rename SQL Server Schema
stackoverflow.com

41
How to return only the Date from a SQL Server DateTime datatype
stackoverflow.com

37
SQL Server: Is it possible to insert into two tables at the same time?
stackoverflow.com

37
Why does select SCOPE_IDENTITY() return a decimal instead of an integer?
stackoverflow.com

36
How many significant digits should I store in my database for a GPS coordinate?
stackoverflow.com

36
Mark answer as favorite/star
meta.stackexchange.com

34
United States Banking Institution Account Number Regular Expression?
stackoverflow.com

34
WHERE clause better execute before IN and JOIN or after
stackoverflow.com

34
When to build a separate reporting database?
stackoverflow.com

1 2 3 4 5 … 10