15,345 reputation
44591
bio website sqlblog.com/blogs/paul_white/…
location New Zealand
age 44
visits member for 3 years, 1 month
seen 26 secs ago

Apr
14
reviewed Approve suggested edit on PostgreSQL DB size increasing after restoring the same database backup
Apr
14
reviewed No Action Needed Create previously created MySQL database without .sql file
Apr
14
reviewed No Action Needed MySQL schema for recurring events - Query by specific date
Apr
13
reviewed Close Can't connect SQL Server through firewall
Apr
13
reviewed No Action Needed Oracle edition-based redefinition
Apr
13
reviewed No Action Needed MySQL behaviour on connection failure
Apr
13
comment Variable numbers of parameters in a SqlClr UDF or Stored Proc
@JustinDearing "Pain" is far too small a world to describe the process. Even if you succeed, once you have an XP you've written yourself running inside the sqlserver.exe process space without managed code protections, you'll ascribe every future system weirdness to a bug in your XP (and you might well be right). I implore you not to go down this path. Find another solution, or change the design.
Apr
13
answered Variable numbers of parameters in a SqlClr UDF or Stored Proc
Apr
13
revised Variable numbers of parameters in a SqlClr UDF or Stored Proc
Removed code section horizontal scroll bars; fixed link markdown
Apr
12
reviewed Reviewed Microsoft Access database performance
Apr
12
reviewed Reviewed connection issue / Oracle Express 11g in windows7 32bit
Apr
12
answered SMS Suggesting covering all columns in an index?
Apr
12
reviewed Close Lost all my Postgres database tables?
Apr
12
reviewed Reviewed How do I change the DEFINER of a VIEW in Mysql?
Apr
12
reviewed Looks Good Modify DEFINER on Many Views
Apr
12
reviewed Approve suggested edit on How to access external DLL's static methods that incorporate output parameters in SQL Server
Apr
11
reviewed No Action Needed MS Access: ODBC Err 3146 - Timeout related?
Apr
11
reviewed Reviewed Basic Design Question about one to many in a table
Apr
11
revised Making a recursive CTE like query, but for many records
Renamed a column to be more realistic
Apr
11
revised Getting Visual Studio to deploy a UDF to Return NVARCHAR(MAX)
Added T-SQL script