Stack Exchange

Cade Roux

New Orleans, LA, United States

http://www.caderoux.com

Stack Overflow CV

top accounts reputation activity favorites subscriptions
Top Questions
201 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

145 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

65 votes

Which SD cards are compatible?

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

43 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

38 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

23 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

23 votes

Portable system for syncing files (like DropBox)?

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

20 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

17 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
235
Create a date from day month and year with T-SQL
stackoverflow.com

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

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

141
SQL join: where clause vs. on clause
stackoverflow.com

139
Condition within JOIN or WHERE
stackoverflow.com

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

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

75
C# SQL Top as parameter
stackoverflow.com

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

71
Multiple Indexes vs Multi-Column Indexes
stackoverflow.com

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

60
INNER JOIN ON vs WHERE clause
stackoverflow.com

58
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

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

52
Worst UI You've Ever Used
stackoverflow.com

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

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

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

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

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

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

38
Rename SQL Server Schema
stackoverflow.com

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

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

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

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

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

31
Pivot Table and Concatenate Columns
stackoverflow.com

30
Can I use WITH in TSQL twice to filter a result set like my example?
stackoverflow.com

1 2 3 4 5 … 10