Activity overview
Latest activity by JR_GER
Try this: SELECT cast(getDate() As Date) If this looks good for you, replace ''getDate()' with the name of column that holds the datetime data. JR / comments
Try this: SELECT cast(getDate() As Date) If this looks good for you, replace ''getDate()' with the name of column that holds the datetime data.JR
Hi, Works like a charm. Very simple solution. I should have tested this approach before asking. [image] Thanks a lot. JR / comments
Hi,Works like a charm. Very simple solution.I should have tested this approach before asking. Thanks a lot.JR
Formatting code with BulkInsert and CODEPAGE
Hi,In a stored procedure, I'm using "BULK INSERT" to import a CSV which is UTF-8 encoded.So the code looks like:--->8 SNIP ---
BULK INSERT tbl_XYZ<br>FROM 'D:\Imports\txt.csv'<br>WITH<br>(<br>&nbs...
Very good demos. Speakers all had a perfect mixture of professionality and humor. Looks like SQLDOC is worth a try. / comments
Very good demos.Speakers all had a perfect mixture of professionality and humor.Looks like SQLDOC is worth a try.