Stack Exchange

Cade Roux

New Orleans, LA, United States

http://www.caderoux.com

Stack Overflow CV

top accounts reputation activity bookmarks subscriptions
Top Questions
213 votes

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

sql sql-server tsql asked Sep 23, 2008 at 15:46
stackoverflow.com

184 votes

Better techniques for trimming leading zeros in SQL Server?

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

72 votes

Is bribing children with cash incentives a good idea?

behavior discipline money reward asked Mar 29, 2011 at 21:40
parenting.stackexchange.com

69 votes

Which SD cards are compatible?

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

65 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, 2011 at 15:08
stackoverflow.com

65 votes

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

sql-server formatting ssms asked Apr 20, 2010 at 23:53
stackoverflow.com

32 votes

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

c# .net .net-3.5 asked Mar 3, 2011 at 20:52
stackoverflow.com

27 votes

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

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

25 votes

Portable system for syncing files (like DropBox)?

file-sharing asked Jul 14, 2012 at 5:43
raspberrypi.stackexchange.com

20 votes

Efficient ISNUMERIC() replacements on SQL Server?

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

1 2 3 4 5 … 7

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

181
Condition within JOIN or WHERE
stackoverflow.com

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

157
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

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

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

87
Multiple Indexes vs Multi-Column Indexes
stackoverflow.com

86
C# SQL Top as parameter
stackoverflow.com

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

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

70
INNER JOIN ON vs WHERE clause
stackoverflow.com

63
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

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

57
Is there a way to suppress "x rows affected" in SQLCMD from the command line?
stackoverflow.com

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

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

52
Worst UI You've Ever Used
stackoverflow.com

49
Rename SQL Server Schema
stackoverflow.com

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

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

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

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

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

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

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

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

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

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

1 2 3 4 5 … 10