Create table in trigger.

Question

0.00/5 (No votes)

See more:

SQL-Server

trigger

how to create table in trigger

Posted 9-Jan-14 21:09pm

Abhilask kumar

Add a Solution

Comments

thatraja 10-Jan-14 3:20am

why? That's not trigger's purpose

Abhilask kumar 10-Jan-14 3:49am

i mean can i create table in after trigger.

Thomas ktg 10-Jan-14 3:50am

Refer here,
http://forums.mysql.com/read.php?99,121849,122609#msg-122609
I think It is also applicable for SQL-Server.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 10-Jan-14 7:24am

What have you tried and where is the problem?

2 solutions

Solution 1

please check !!

XML

http://msdn.microsoft.com/en-us/library/ms189799.aspx
The following Transact-SQL statements are not allowed in a DML trigger:
ALTER DATABASE
CREATE DATABASE
DROP DATABASE
RESTORE DATABASE
RESTORE LOG
RECONFIGURE

Thanks

Posted 10-Jan-14 1:11am

Thakkar Vipul

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhilask kumar · Accepted Answer · 2014-01-10T01:18:00

Solution 2

it is simple

SQL

>create table tmp_tab([id] int,[name] varchar(20)).

Posted 10-Jan-14 1:18am

Abhilask kumar

Create table in trigger.

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Create table in trigger.

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us