function COSEnumerateObjectFunctions(obj){
var emailStr = "<table>";
var objarray = new Array();
var counter = 0;
for(var propertyName in obj) {
objarray[counter] = new Array(2);
objarray[counter][0] = propertyName;
objarray[counter][1] = obj[propertyName];
counter = counter + 1;
}
objarray.sort(function(a,b){
return a < b ? -1 : a > b ? 1 : 0;
});
for(var i = 0; i < counter; i++) {
if(i % 3 == 0){
emailStr = emailStr + '<tr><td><u><b>' + objarray[i][0] + '</b></u></td><td><u><b>' + objarray[i][1] + '</b></u></td></tr>';
}else{
emailStr = emailStr + '<tr><td>' + objarray[i][0] + '</td><td>' + objarray[i][1] + '</td></tr>';
}
}
emailStr = emailStr + '</table>';
aa.sendMail("wadmin@springfieldcityhall.com","jmurgolo@springfieldcityhall.com","","enumerated object 2", emailStr);
return emailStr;
}
Monday, August 18, 2014
Wednesday, August 6, 2014
Add Identity, Change Column Types, Etc..
Alter Column
alter table [dbo].[GIS_311Registrations]
alter column [StreetNumber] varchar(MAX) null
Delete Column
alter table GIS_Primary drop column [Best Guess Vacancy Rank 3]
Add Identity
ALTER TABLE GIS_VPRVacant DROP COLUMN ID
ALTER TABLE GIS_VPRVacant ADD ID INT IDENTITY(1,1)
Insert Into
INSERT INTO Table
SELECT Something
FROM Someplace
Change Column Name
EXEC sp_rename 'GIS_Primary.City Owned Vacant', 'CtyOwnVac', 'COLUMN';
alter table [dbo].[GIS_311Registrations]
alter column [StreetNumber] varchar(MAX) null
Delete Column
alter table GIS_Primary drop column [Best Guess Vacancy Rank 3]
Add Identity
ALTER TABLE GIS_VPRVacant DROP COLUMN ID
ALTER TABLE GIS_VPRVacant ADD ID INT IDENTITY(1,1)
Insert Into
INSERT INTO Table
SELECT Something
FROM Someplace
Change Column Name
EXEC sp_rename 'GIS_Primary.City Owned Vacant', 'CtyOwnVac', 'COLUMN';
Subscribe to:
Posts (Atom)