|
Run an INSERT...VALUES query to insert a new row of data into a table in your second database.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
i need to write trigger for this
|
|
|
|
|
Good for you.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
You want to look at syntax like this:
create trigger dbo.MyTrigger
on dbo.MyTable
for insert
as
insert into database2.dbo.table2 (col1, col2)
select col1, col2 from inserted
end
|
|
|
|
|
i am having one database and the data will be comming through a device and i need to copy the newly generated row to another database how is it possible
i need to insert new row into another database this to be done in sql express
can anybody give solution for this
padma
padma
|
|
|
|
|
IS that Database on same server?
Hardik Panchal
|
|
|
|
|
in sql express How we know that user has inserted new row or update old row, is there any keyword to find out.
regards
padma
|
|
|
|
|
You can use Query Notifications[^] but I'm not sure whether it is included in express addition or not
|
|
|
|
|
hi friends...
is there any replacement for the following query
select 0/0 from dual;
if i execute the query i am getting error ORA-01476.
can any body helps me in
bye
mahen
|
|
|
|
|
hi
Its a mathematical error..in a division divisor cannnot be Zero.
Regards
Joe
|
|
|
|
|
thanks jo
instead of error if it gives some value.. i can assign that to variable and get the value..
i working with one programme..say variable a and b.
some time variable b might be zero..
when i run the query.. say select a/b then it gives the error if thats values become 0..
please help.. me
thanks
mahen
|
|
|
|
|
hi
you can use DECODE function with which you can replace 0 with some other value.
Regards
Joe
|
|
|
|
|
hi
i havae to insert data from one record to another for that i created a trigger
CREATE TRIGGER trigInsertion on master
AFTER insert as
INSERT into child
SELECT Convert(varchar(50),master_date,105) FROM inserted
in this i need to convert varchar to datetime and insert these values into child table but it is not working
padma
|
|
|
|
|
hi
for converting varchar to date use
convert(datetime,FIELD)
try to include the error message..so that we can identify the problem
Regards
Joe
|
|
|
|
|
in sql express How we know that user has inserted new row or update old row, is there any keyword to find out.
padma
|
|
|
|
|
In what format dates are stored in "master_date"
As you are using 105 (style) it should be in "dd-mm-yy" format
Regards
KP
|
|
|
|
|
I WILL TRY TO HELP YOU SOON
THANKS
MAHEN
|
|
|
|
|
Hi
can anybody give solution for my req
i had a mastertable and i need to copy generated recordsd to my child table my code follows in this way:
CREATE TRIGGER trigInsertion on GlobalScan
AFTER insert as
INSERT into GlobalScanNew
SELECT * FROM inserted
end
but here in my mastertable coloums data type is different from child table
now i need to convert this and place it in my new table
plz can anybody give solution for this
Regards
padma
padma
|
|
|
|
|
hi
you can use convert() function for converting data type and insert it in to the child Table.
eg: INSERT INTO CHILD
SELECT CONVERT(VARCHAR,FIELD1) FROM INSERTED
Regards
Joe
|
|
|
|
|
thanks for reply
but in my master table i had 10 coloums and in that i need to check three coloums so how can i do it
padma
padma
|
|
|
|
|
hi
if you needs only 3 columns specify that columns in your select qry
eg: INSERT INTO CHILDTABLE
SELECT CONVERT(FIELD1),CONVERT(FIELD2),FIELD3
FROM INSERTED
Regards
Joe
|
|
|
|
|
|
I can do a select within a dataset to search for a string. This works great.
When I try to do the select to search for a number I get a 'does not evaluate to a Boolean term'.
For example- matchingRows() = ds.Tables("Generations").Select("id = 3")
I get a simular error when I try to create a dataview that keys off of a number.
How do you search a dataset for a numeric value?
Thanks in advance!
kermit88
|
|
|
|
|
Hi Dear
I am getting a error called "rsReportParameterProcessingError" from a report i deployed in sql sever reporting services (Sharepoint 3.0) in a sever A. the parameter which cause this error is 'EndDate' which set to returin the value of one day before report generation day, code as: =CDate(Format(Dateadd("d",-1,now()),"dd/MM/yyyy"))
The report is running fine and returning no error in either Visual Studio or other severs.
Could you please advise what setting in the sever might cause this error and how do i change the configration in Sever A to fix that?
Thank you very much,
Candy
|
|
|
|
|
Have you checked the report server logs? You should be able to get more descriptive error details from there.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
