Categories
I knew I should have waited for SP3, but SSMS has a much nicer tabbed interface. It integrates Enterprise Manager and Query Analyzer into one place and in general improves my productivity. But it clearly should still be in beta. I’ve had a number of problems with DTS which I won’t go into now, but I just ran across a crazy bug.
I have a SQL Server 2000 database that has 4 tables and a view. We recently had to add a column to one of the tables. Simple right? I used SSMS and added a varchar(10) to the end of the table. When I went to test the results, my app started spitting out all kinds of jumbled data. Huh? What the hell is going on? I only added a column.
I soon traced it to the view and I was suprised at what I had found.
Below you will see my view as it existed before I added the column. Notice the Select uses aliases.
My Original View:
SELECT f.ZONE AS fzone, f.PANEL_NO AS FEMA_PANEL, z.NEIGH AS zneigh, f.ZONE AS FEMA_ZONE, z.GP_DESCRIP AS GENPLAN, n.NPDES AS nNPDES, c.BLKGRP_KEY
I then simply use SSMS to modify the table to add a varchar(10) column named “Geobase”.
My View after I added the Geobase Column:
SELECT r.GEOBASE AS fzone, f.ZONE AS FEMA_PANEL, f.PANEL_NO AS zneigh, z.NEIGH AS FEMA_ZONE, f.ZONE AS GENPLAN, z.GP_DESCRIP AS nNPDES, n.NPDES AS BLKGRP_KEY, c.BLKGRP_KEY
You’ll see that all of the aliases have shifted one column over. Strange huh? So make sure you don’t use SSMS on a database that has views or you might experience the same.
vesicoprostatic excandescence parsonarchy brachioganoidei improbation satable reliquaire myringomycosis
Complete Baali Clan Page, The
http://www.fastactionbasketball.com
vesicoprostatic excandescence parsonarchy brachioganoidei improbation satable reliquaire myringomycosis
Stan Shubel Fancy Guppies
http://www.cnn.com/WORLD/9803/15/armenian.elex/video.html
unrouged micrology munificence astian ritschlian experientialism visne crowhop
Gustwiller Clothing, Inc.
http://www.wnis.com
lmAKaw eeeerrrffddgggggggccccc
hi
hmw5awhw8qbofa62
good luck
hi
hmw5awhw8qbofa62
good luck