mwinckler

up_generate_data_dictionary

To use this sproc, after creating it in the database you want to document, execute it in SQL Management Studio and view the "Messages" tab. Copy the contents of the "message" tab out into a text file, save it with a .html extension, and open it in a web browser.

mwinckler

(function() {
	var boName = prompt('What do you want to name this build order?');
	var supply = 6;
	var orders = $('<ol></ol>').css({'list-style-type':'none'});

	// For the duration this window is displayed, suspend the
	// document events trapping selection/mousedown/etc so that
	// the user can select/copy/paste the build order. See the
	// click handler on the close buttons for event restoration.
	var docEvents = jQuery.extend(true, {}, $(document).data('events')); 

mwinckler

declare @s varchar(4000);
set @s = null;
select @s = coalesce(@s + ', ' + column_name, column_name)
from information_schema.COLUMNS
where TABLE_NAME = 'sb_tmpSamplePAList';
select @s;

mwinckler

/* 
  Find all tables having more than X rows
  -----
  Prints table name if the table has more than @minRows rows
  Replace #{DBNAME} with database name
  Edit (or remove) where clause as desired
*/

select 'declare @name varchar(50), @ct int, @minRows int;
set @minRows = 0;'

mwinckler

		MapEditMode _mapEditMode = MapEditMode.normal;

		private void wpfMap1_MapClick(object sender, ThinkGeo.MapSuite.WpfDesktopEdition.MapClickWpfMapEventArgs e) {

					if (_mapEditMode == MapEditMode.add_text) {
				_mapEditMode = MapEditMode.adding_text;
				wpfMap1.Cursor = Cursors.Arrow;

				var canvas = new Canvas();
				TextEditor editor = null;