This script shows the way, how to remove a time from datetimes.Do not move this code to UDF, it would run at least 6 times slower.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-04-03

95 reads

Blogs

It is Friday, the queries are running, and nobody is watching the bill. That...

Annabel retired from Redgate Software this week. Across most of my career at Redgate,...

As a SQL Server DBA with years of experience tuning production environments, I’ve seen...

Forums

Tlp/Cs: 0817839777 Jl. Tarum Barat Blk. E No.5, RT.4/RW.10, Wil. Kota, Kec. Duren Sawit,...

WhatsApp: 0817839777 Jl. Diponegoro No.68, Palraman, Dawuhan, Kec. Situbondo, Kabupaten Situbondo, Jawa Timur 68311

WhatsApp: 0817839777 Jl. Panglima Sudirman No.35, Baturetno, Kec. Tuban, Kabupaten Tuban, Jawa Timur 62314

When running bcp on Linux, what is the field terminator?