User Profile

Collapse

Profile Sidebar

Collapse
pareshmr
pareshmr
Last Activity: Dec 5 '13, 12:04 PM
Joined: Oct 9 '13
Location: Rajkot
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • pareshmr
    replied to How to trigger execute to export csv file?
    in SQL Server
    How to use this code in triiger?
    --------------------------------

    Code:
    	DECLARE @FileName varchar(50),@bcpCommand varchar(8000)
	SET @FileName = 'D:\USER_SETUP' + replace(replace(CONVERT(varchar(10),GETDATE(),3)+' ' + CONVERT(varchar(10),GETDATE(),8),'/','_'),':','-') + '.csv'

	SET @bcpCommand = 'bcp "select * from CCMS.DBO.USER_SETUP" queryout "'
	SET @bcpCommand = @bcpCommand +
    ...
    See more | Go to post
    Last edited by Rabbit; Oct 10 '13, 03:14 PM. Reason: Please use [CODE] and [/CODE] tags when posting code or formatted data.

      Leave a comment:

    • pareshmr
      started a topic How to trigger execute to export csv file?
      in SQL Server

      How to trigger execute to export csv file?

      i have no idea for how to create trigger and how to execute trigger in sql server 2008 Please help How to trigger execute to export csv file? Select * from user_Registriti on; user_Registriti on table to create trigger and trigger excute to all user_Registriti on data export in csv file
      See more | Go to post
      No activity results to display
      Show More
      Working...