Hello
Can anyone confirm that if I use SET DATEFORMAT that it
will only change the date format for the SQL session and
not permanently for the machine?
Thanks in advance
H
Hi -
The Transact-SQL programming language provides several SET statements that
alter the current session handling of specific information.
SET DATEFORMAT is one such SET Function which will chage the date format for
the SQL Session.
Thanks
-Surajit
"H" <anonymous@.discussions.microsoft.com> wrote in message
news:19fbb01c44da7$b42e8000$a101280a@.phx.gbl...
> Hello
> Can anyone confirm that if I use SET DATEFORMAT that it
> will only change the date format for the SQL session and
> not permanently for the machine?
> Thanks in advance
> H
|||Yes, Only for that specific session( not for everyone). And it applies ONLY
until that session ends.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"H" <anonymous@.discussions.microsoft.com> wrote in message
news:19fbb01c44da7$b42e8000$a101280a@.phx.gbl...
> Hello
> Can anyone confirm that if I use SET DATEFORMAT that it
> will only change the date format for the SQL session and
> not permanently for the machine?
> Thanks in advance
> H
No comments:
Post a Comment