Posts

Showing posts from April, 2018

Task

  CIMB Bank Berhad Address: Prima 5-A, Jalan Teknokrat 5, 63000 Cyberjaya, Selangor Tel: 1 300 880 900 Fax: +603-8318 3421 Email: callcentre@cimb.com Website: http://www.cimbbank.com.my BCP  https://www.youtube.com/watch?v=op_Hx4yelO4 https://www.youtube.com/watch?v=ELjUro80fWA https://www.youtube.com/watch?v=GFFjYRdTbtg https://www.careersatcoolblue.com/ bcp -h https://solutioncenter.apexsql.com/how-to-export-sql-server-data-to-a-csv-file/ https://www.excel-sql-server.com/sql-server-export-to-excel-using-bcp-sqlcmd-csv.htm declare @bcp_cmd varchar(2000); DECLARE @stmt_c VARCHAR(8000); DECLARE @dbname VarChar(100); DECLARE @bcp_passwd VarChar(100); DECLARE @bcp_user VarChar(100); DECLARE @tablename VarChar(100); DECLARE @data_start_dt Datetime = '2017-08-25 00:00:00.000'; DECLARE @data_end_dt Datetime = '2017-08-28 13:00:00.000'; declare @packet_size int set @dbname= 'TestDB'; set @tablename = 'tblTest'; set @bcp_user =&

NotePad++ Search File

^\[\{"column_name"       {"fields":[{"column_name" (?s-i)\A((?!fields).)+\z (?si)\A((?!fields).)+\z https://notepad-plus-plus.org/community/topic/12500/pfe-s-find-extend-selection/3 Video https://www.youtube.com/watch?v=lH8Gkyl1mfg