no that did't solved my problem.equivalent problem is solved in oracle through the query that i have initially posted .Then how to solve it in SqlServer?

Hi,

this query is giving error :

this query is fine ,but i have to select each...

Hi,

actually concept behind this type of problem is new for me..i am confused how to start my query...

Thanks a lot

create table emp1(id int);

create table emp2(id int);

values in both emp1 emp2 are inserted via "insert into table values(value)" command.

data are 10,11,12,13,14,15

Hi,

really i was confused with the example, as i am new to trigger in SqlServer .Thanks for information.

hi,

thanks for your valuable post.the command is working fine without any modification.

can u give me any link that deals with all the available commands in sqlcmd..like how to see in...

hi,

'sqlcmd /?' command gives the commands that are available in sqlcmd,but there is no any listing of 'backup' command or 'restore' command and its parameters.so how can i get all...

hi,

yes,backup is successfully created.

now can u help me how to retrieve (or restore) by database to another sql server database?i.e if i send the backup file to another system and...

thanks.

the link you provided is not so fruitful.it did'nt solved my problem.Also ,you gave the commands for backup:

backup database databasename to disk='C:\db.bak'.

But it too gave errors:

Cannot open backup device 'C:\db.bak'...

the link you provided is not so fruitful.it did'nt solved my problem.Also ,you gave the commands for backup:

backup database databasename to disk='C:\db.bak'.

But it too gave errors:

Cannot open backup device 'C:\db.bak'...

yes,its sql express edition