This is a follow-on to info's script to strip the time portion of a datetime or smalldatetime, leaving only the date. I found info's script interesting! When I had to do this I converted the date to varchar and back again instead of to float. Seems to work fine for me.
2003-04-03
116 reads
By Arun Sirpal
I do believe most people know about the ability to backup your SQL server...
As AI continues to evolve, many of us are looking for ways to leverage...
By Steve Jones
I was chatting with a customer recently and they wanted to know which host...
Quick one I hope in case I'm heading off in entirely the wrong direction!...
Hi everyone I am looking at the size of my db on disk (ie...
Comments posted to this topic are about the item Getting the TEXTSIZE
How can I check what value I used for TEXTSIZE? I ran this code:
SET TEXTSIZE 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers