ASP Free Forums - Microsoft SQL Server

Making trigger

Swirl_ — Sun, 19 May 2013 23:12:47 GMT

Hello,

Im new with database and I have a question about a table with triggers or maybe a check constraint. Im using SQL Server Management studio.

I have the following create tables:

create table bid(
seller char(10) not null,
item_nummer numeric(3) not null,
)

create table Item(
startprice char(5) not null,
description char(22) not null,
start_date char(10) not null,
end_date char(10) not null,
seller char(10) not null,
item_nummer numeric(3) not null,
)

What i'm trying to make is this trigger/constraint:
colomn "seller" from table Item will get NULL as long as systemdate is > start_date and end_date, then it will get the value from seller from table bid on the same item_nummer in both table).

I hope i explained correctly what i mean.

problem with connecting to mySQL

zubair_sait — Sat, 18 May 2013 19:05:08 GMT

Hi..i have a hosting space and database taken from net4india..when i try to connect to the database using the following codes i get a internal server error 500..i am not able to understand what exactly is the problem with the codes

i have contacted the hosting company a number of times thy say its all fine check ur coading

plz help!

Untitled Document

<%
Dim sConnection
Dim oConnection
Dim oRS

sConnection = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=00.00.000.00; DATABASE=xxxxxx; UID=xxxxxx;PASSWORD=xxxx; OPTION=3"

Set oConnection = Server.CreateObject("ADODB.Connection")

oConnection.Open sConnection

Set oRS = oConnection.Execute("SELECT * FROM Table")

While Not oRS.EOF
Response.Write oRS("Name")
oRS.MoveNext
Wend

oRS.Close
Set oRS = Nothing

oConnection.Close
Set oConnection = Nothing
%>

How to create a trigger to update data in another database

jennypretty — Thu, 16 May 2013 13:21:35 GMT

Hello,

I am new to creating a trigger in sql server so I need your help.

I have 2 sites, 2 databases (same name) on 2 different servers, S1 & S2. These database are the same name, tables, data, 100% the same.

I am using ASP to code. Currently, I have to enter data for each website, which is 2 times.

How can I create a trigger so that everytime there is an update in database in Server1, then the database in Server2 gets updated.

Thank you very much!