Concluído

4 MS SQL 2008 trigger scripts (EASY)

notes:

* This is sql server 2008 web edition

* You must design these triggers in a way that if new columns are added your code will not break

* below are the detailed requirements (scroll down)

* attached are 3 sql files. you should create 2 databases on your own system for testing. You will not have access to my sql server. You must DO ALL DEVELOPMENT AND TESTING on your MS SQL 2008 db.

1. Schema is the Schema for the template sites

2. Data - populates these tables for the template sites

3. [url removed, login to view] - Is the schema for the table: [Sites] the database name: [SimpleTickSites]

## Deliverables

Your task is to create 4 triggers scripts. Then create 1 sql scripts that can be run against a sql server 2008 database that will create the scripts.

notes:

* This is sql server 2008 web edition

* You must design these triggers in a way that if new columns are added your code will not break

* attached are the sql files

**

*One*** *table [aspnet_Users]*

On any change to the table: [aspnet_Users]

**Capture the total account of Count([UserId])** and save that to

[SimpleTickSites].[dbo].[<wbr />Sites]**.[UserCount]**

where [SimpleTickSites].[dbo].[<wbr />Sites].[DatabaseName] = [original database name]

On any change to the table: [aspnet_Users]

where [UserName] = "admin"

**Capture [LastActivityDate]** and save that to

[SimpleTickSites].[dbo].[<wbr />Sites].**[LastAdminLogin]**

where [SimpleTickSites].[dbo].[<wbr />Sites].[DatabaseName] = [original database name]

*

**Two** table [tb_Show]*

On any change to the table: [tb_Show]

**Capture the total account of Count([showId])** and save that to

[SimpleTickSites].[dbo].[<wbr />Sites]**.[EventCount]**

where [SimpleTickSites].[dbo].[<wbr />Sites].[DatabaseName] = [original database name]

***Three** tables [tb_ShowTime] and [tb_EventSectionTime]*

Any changes to either tables:

**Capture the total account of Count(** [tb_EventSectionTime].**[id])** + **Count(** [tb_ShowTime].showTimeId)

and save that to

[SimpleTickSites].[dbo].[<wbr />Sites]**.[EventTimeCount]**

where [SimpleTickSites].[dbo].[<wbr />Sites].[DatabaseName] = [original database name]

Habilidades: Engenharia, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software, SQL

Veja mais: my sql databases, my sql create database, ms access web development, ms access database development, easy way for web development, SQL Server Admin, ms access 2010, sql server scripts, SQl server DEVELOPMENT, MS SQL, sql server 2008 access, access 2010 web development, schema sql, sql server 2008 project, server 2008 access, trigger change, access 2010 database design, php change code easy, task management system design, create access project database 2010, create task access database, requirements management access database, server 2008 project, change access sql, easy php task

Acerca do Empregador:
( 74 comentários ) Prague , United States

ID do Projeto: #3259933

Concedido a:

sathyanus

See private message.

$17 USD em 4 dias
(83 Comentários)
5.2

3 freelancers estão ofertando em média $17 para esse trabalho

HITESHGOYAL0803

See private message.

$17 USD in 4 dias
(7 Comentários)
2.2
enghany

See private message.

$16.15 USD in 4 dias
(1 Comentário)
1.3