sql — RSS

I've been asked by my manager to come up with a script to run before and after an upgrade of SQL server to verify that basic statements within SQL work before and after an upgrade. Here's what I came up with. Anyone else ever do something like this?

/*
SQL Standard Health Check
DBA : Amy Boyd
Date: 10/5/2006

This is a script that can be run prior to and after the upgrade of
SQL server components to verify basic functionality.

*/

set nocount on
select 'Server Name: ' + @@servername + ' at version: ' + @@version

use admin -- or any other test database you might have
select 'Testing a select of a few sysobjects from admin db...'
select * from sysobjects where id < 5
if @@error = 0
begin
select 'Select of sysobjects successful'
select ''
end

select 'Testing table creation'
create table test_upgrade ( message varchar(100))
if @@error = 0
begin
select 'Table creation successful'
select ''
end

select 'Testing Insert into Table'
insert into test_upgrade values ('Table Insert Works')
if @@error = 0
begin
select 'Insert successful'
select ''
end

select 'Testing Update of Table'
update test_upgrade set message ='Table Update Works'
if @@error = 0
begin
select 'Update of table Successful'
select ''
end

select 'Testing Delete from Table'
delete from test_upgrade
if @@error = 0
begin
select 'Delete from table successful'
select ''
end

select 'Testing Drop table command'
drop table test_upgrade
if @@error = 0
begin
select 'Drop of table successful'
select ''
end

use msdb
select 'Testing a select of a few sysobjects from msdb db...'
select * from sysobjects where id < 5
if @@error = 0
begin
select 'Select of sysobjects successful'
select ''
end

use master
select 'Testing a select of a few sysobjects from master db...'
select * from sysobjects where id < 5
if @@error = 0
begin
select 'Select of sysobjects successful'
select ''
end

select 'Retreiving list of databases from ' + @@servername
select * from sysdatabases
select ''

if @@error = 0
begin
select 'Getting disk space stats for ' + @@servername
exec xp_fixeddrives
select ''
end

select 'Basic SQL Operations are working. Do not forget to test start/stop of SQL Server and Agent.'
select ''

if @@error > 0
select 'There was an error executing the health check please verify output for resolution.'

class banner_class extends mysql_class { function test() { .... .... } } $result = new banner_class; $template = $result->test(); готовый код, в функции конструкции вида if ($_POST['foo'] == 'bar') { ... } ... { }

private void cboName_SelectedIndexChanged(object sender, EventArgs e) { try { bsRate.Filter = "prov_id = " + txtProvNo.Text; bsRate.Sort = "mexp desc"; bsRate.ResetBindings(false); MessageBox.Show("Filter = " + bsRate.Filter.ToString() + " Sort = " + bsRate.Sort.ToString()); } catch (Exception ex) { } finally { } }

private string ConnectionString; private DataViewManager dsView; private DataViewManager dsViewHospitals; private DataSet ds; public TestHospitalFormGrid() { InitializeComponent(); ConnectionString = "data source=edison;uid=sa;password=nothing;database=hospratestest"; SqlConnection cn = new SqlConnection(ConnectionString); //Create the DataSet ds = new DataSet("HospRates"); //Fill the dataset with hospitals SqlDataAdapter da1 = new SqlDataAdapter("select * from hospitals", cn); da1.TableMappings.Add("Table", "Hospitals"); da1.Fill(ds, "Hospitals"); //Fill the dataset with rates SqlDataAdapter da2 = new SqlDataAdapter("select * from CombinedRateData", cn); da2.TableMappings.Add("Table", "Rates"); da2.Fill(ds, "Rates"); //tables father back will go here later //Establish relatinship between hospitals and rates DataRelation relHospRates; DataColumn MasterColumn; DataColumn DetailColumn; MasterColumn = ds.Tables["Hospitals"].Columns["ID"]; DetailColumn = ds.Tables["Rates"].Columns["prov_id"]; relHospRates = new DataRelation("HospRatesRelation", MasterColumn, DetailColumn); ds.Relations.Add(relHospRates); dsView = ds.DefaultViewManager; dsViewHospitals = ???; dgDetail.DataSource = dsView; dgDetail.DataMember = "Rates.HospRatesRelation"; //dgDetail.DataSource = "Rates.HospRatesRelation"; cboName.DataSource = dsView; cboName.DisplayMember = "Hospitals.Name"; cboName.ValueMember = "Hospitals.ID"; } }