Extract table from another table<\/p>\n
SELECT * Bulk insert<\/p>\n BULK insert dbo<\/span><\/span>.<\/span><\/span>SFG_Event_21_22 Replace string value of a column<\/p>\n UPDATE dbo<\/span>.<\/span>SFG_Event_ResultFromApp <\/p>\n <\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" Extract table from another table SELECT * FROM dbo.SFG_Event_21_22 except SELECT * FROM dbo.SFG_Event_21 Bulk insert BULK insert dbo.SFG_Event_21_22 from ‘C:\\Users\\joemac\\Desktop\\final.csv’ WITH ( firstrow = 1, fieldterminator = ‘,’, rowterminator = ‘0x0a’ ); GO bulk insert cannot understand text qualifier bulk insert add NULL for blank data by default Replace string value of a column… Continue reading Useful command of MSSQL Query when comparing and manipulating text data<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[128],"tags":[],"class_list":["post-821","post","type-post","status-publish","format-standard","hentry","category-db","entry"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/moneystock.net\/wp_e\/wp-json\/wp\/v2\/posts\/821","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/moneystock.net\/wp_e\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/moneystock.net\/wp_e\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/moneystock.net\/wp_e\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/moneystock.net\/wp_e\/wp-json\/wp\/v2\/comments?post=821"}],"version-history":[{"count":3,"href":"https:\/\/moneystock.net\/wp_e\/wp-json\/wp\/v2\/posts\/821\/revisions"}],"predecessor-version":[{"id":823,"href":"https:\/\/moneystock.net\/wp_e\/wp-json\/wp\/v2\/posts\/821\/revisions\/823"}],"wp:attachment":[{"href":"https:\/\/moneystock.net\/wp_e\/wp-json\/wp\/v2\/media?parent=821"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/moneystock.net\/wp_e\/wp-json\/wp\/v2\/categories?post=821"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/moneystock.net\/wp_e\/wp-json\/wp\/v2\/tags?post=821"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nFROM dbo<\/span><\/span>.<\/span><\/span>SFG_Event_21_22
\nexcept<\/span><\/span>
\nSELECT *
\nFROM dbo<\/span><\/span>.<\/span><\/span>SFG_Event_21<\/p>\n
\nfrom<\/span><\/span> ‘C:\\Users\\joemac\\Desktop\\final.csv’
\nWITH
\n(
\nfirstrow<\/span><\/span> = 1,
\nfieldterminator<\/span><\/span> = ‘,’,
\nrowterminator<\/span><\/span> = ‘0x0a’
\n);
\nGO<\/p>\n\n
\nSET [17] = REPLACE(<\/span>[17], ‘;’, ‘,’)<\/p>\n