Trigger for Exporting Table to CSV file Formatt on Local System

  • I have talble name DNC201 which having only one field phonenumber (nvarchar(255)) and this table is in MMS database in SQL SERVER EXPRESS. User Name Is dbo.

    I need to of trigger which export is in csv formatt on local system.

    Is any one can help me?

    the structure of the table is

    USE [MMS]

    GO

    SET ANSI_NULLS ON

    GO

    SET QUOTED_IDENTIFIER ON

    GO

    CREATE TABLE [dbo].[DNC201](

    [phonenumber] [nvarchar](255) NULL

    ) ON [PRIMARY]

  • Triggers are generally used to perform some action when an event occurs. What event are you wanting to trigger off of? I.E., [Insert], [Upate], [Delete], etc.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply