117 reputation
2
bio website stackoverflow.com/users/…
location Illinois
age
visits member for 1 year, 6 months
seen Aug 15 at 14:47

I don't subscribe to social media norms... have a nice day.


Mar
17
comment Automatically keep synchronized copy of database
msdn.microsoft.com/en-us/library/bb902818(SQL.110).aspx compare and contract sync w/ replication. Depending on needs replication may be more robust than the sync solution or technet.microsoft.com/en-us/library/ms151198.aspx as lead in to first link
Dec
14
comment Which queries are running and what tables are they accessing?
stackoverflow.com/questions/55899/… would show the tables.
May
30
comment Execute output from query
Yes it's called Dynamic SQL and RDBMS.Execute(string) can execute dynamic SQL; but caution is needed as this allows SQL injection
May
30
comment Using something better than UNION for combining multiple queries
A better database model? if you're pulling in Like information why the seperation in the first place? could a field have been added similar to the table name to denote difference and "poof" all the unions are gone..
May
30
awarded  Editor
May
30
revised A database trigger is an alternative for?
added 120 characters in body
Feb
27
awarded  Teacher
Feb
27
answered A database trigger is an alternative for?
Apr
13
answered Setting up database structure for Students, Managers, and Administrators
Dec
20
answered Compare two oracle .dmp files