Does SET DATEFORMAT only set the format for the session?

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

Does SET DATEFORMAT only set the format for the session?

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
HHi -
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

Does SET DATEFORMAT only set the format for the session?

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
HHi -
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

Does format file for bulk insert allow mix of native and character format?

I tried to place this question to the .Net framework Data Access and Storage forum and got no answer, so I am trying to move it on this forum.

So I have a module which require me to import big amount of data. I believe that the native format data files with format files will be the most efficient way of implementation. I am trying to programmatically produce a BCP like exported files of native format(it means without type conversion) from tables with nullable and nonnullable values.I prefere to be able to not produce computed or identity or rowguid fields,so I need format files.

I don't have problems producing different kinds of int or float( which are the majority of fields) or char or nchar fields.

Problems are emerging with the datetime or smalldatetime or decimal fields because I don't know how to convert to them from the strings or from the CLR types.

So I trying to find a way to find a native format of those fields or to find if a bulk insert will accept mixed format files with some of the fields in the native format without field terminators and some with field terminators or to use char format with field terminators only plus maybe format files.

So if the answer to above question is positive I can partially resolve the problem, if negative I will have to use the character format.

Unless you can educate me on the convertion to the SQL server internal formats of datetimes and decimals from the CLR types.

See SQL Server 2005 Books Online topics:

SQL Server Data Types and Their .NET Framework Equivalents
http://msdn2.microsoft.com/en-us/library/ms131092.aspx
Specifying File Storage Type by Using bcp
http://msdn2.microsoft.com/en-US/library/ms189110.aspx

Data Type Conversion (Database Engine)
http://msdn2.microsoft.com/en-us/library/ms191530.aspx

docx, xlsx, pptx, xps support in Full-text search (FTS)

Hello,

Are there any information about FTS support to Office 2007 new document format, like docx, xlsx, pptx, xps etc ?

Regards,

Hi,

we are currently using the new formats in our FTS system. Unfortunately right now, there is no shipping vehicle for them, which leaves you to the options to either install Office 2007 on the SQL Server and grab the filter from the registered system ones, or deploy the filters manually and change the registry to let fulltext service pull them for usage upon the next start. MS plans to publish a shipping vehicle "soon". XPS support is provided through the XPS Essentials pack. But you have to be carefull as this does not do a clear install. (Messed up registration).

Jens K. Suessmeyer.

http://www.sqlserver2005.de

documentation

hello everyone,
I have to document about four databases, has anyone got any specific format or tool for documenting a database?
Any inputs would be very helpful
regards,
Harshal.I've used this tool (http://www.sql-server-performance.com/total_sql_analyzer.asp) earlier.|||Originally posted by Satya
I've used this tool (http://www.sql-server-performance.com/total_sql_analyzer.asp) earlier.

thanks for the quick reply,
but I have to write in details about the use of the table and the logic used in the stored procs also.
I'll go thru the software, is there any specific format for documenting?

Regards,
Harshal.|||I think with the help of VISIO also you can accomplish the task.
As of I know there is no specific format as such, it depends how easy you document.|||Originally posted by Satya
As of I know there is no specific format as such, it depends how easy you document.

yeah i guess it is so.

but really, documentation is third grade torture. :mad:|||Shame is no compatible tools available to document the database, rather we should depend upon third party supplied tools.:o|||Originally posted by Satya
Shame is no compatible tools available to document the database, rather we should depend upon third party supplied tools.:o

I beg to god for an :D intellegent tool :D which would also document all my procedures and their logic :D|||You will have to wait for next version of SQL Server after Yukon .. they might add it by then :)|||Documentation, is documentation.

It is painful.

If the code's not clean, it's even more painful.

Sorry...been there, done that.

PROC NAME:

Purpose:

Inputs:

Outputs:

Process flow:

And that's just the sprocs...

Do you need to a data model as well?

What about an application process model?

And what did you do wrong to get this assignment?|||documentation is already there, basic, maybe even primitive, but is there, in diagrams. if one was too lazy to write it as the app was being developed, doing it when everything else is done is going to be a project in itself. when this is the situation, you can use something as simple as copy con from dos prompt, or as sophisticated as robohelp office or er/studio or visio. the tool does not make any difference for as long as features of the tool will adequately describe what you got.|||Originally posted by Brett Kaiser
Documentation, is documentation.

It is painful.

If the code's not clean, it's even more painful.

Sorry...been there, done that.

PROC NAME:

Purpose:

Inputs:

Outputs:

Process flow:

And that's just the sprocs...

Do you need to a data model as well?

What about an application process model?

And what did you do wrong to get this assignment?

:rolleyes:

yeah the format is jsut similar to what i am currently using.
The real thing is in the process flow:mad: at places the code is worst this part is driving me crazy.
The application process model is to be documented by another guy :D
but yeah i do have to have the data flow diagrams :(

what i do wrong?
well that is a question i am been thinking of since yesterday
:D :p|||Well, in all honesty, walking in to a piece of sh-t system with no dco, is what a hired gun is all about.

If you can figure the sh-t out, you can do anything.

And yes, I always start with a data flow digram...

Gives a very clear picture of what's going on...

It's a higher level, but it gives you everything you need to then focus on the details...

Make sure that the diagram identifies the data, a process and the output of that process

There is no need to define the process in detail, just a descriptive name for a process...

It's a good way to define a road map to attack the details...

The devil is, as they say, in the details

That will come soon enough

But until you get a picture, it's a forect through the trees kinda thing

oh, and a big MOO|||Brett does diagrams...

Document Map format

Is is possible to format the text of a field used in Document Map. I'm using
a date field and can format the field on the report, but not in the Document
Map. I couldn't find any expression function that can format a data value.Try the Format function: =Format(Fields!MyDate.Value,"d")
--
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"Elmer Miller" <millere@.empireco.nospam> wrote in message
news:ewP5tzcZEHA.3228@.TK2MSFTNGP12.phx.gbl...
> Is is possible to format the text of a field used in Document Map. I'm
using
> a date field and can format the field on the report, but not in the
Document
> Map. I couldn't find any expression function that can format a data value.
>

Do you recommend storing images directly into the DB?

The images each are in Jpeg format (black and white, with some grey scale). File size wise, wouldnt be huge < 50 KB.

There wont be too many people using the system.

Would it be tedious to maintain? Many people recommend storing the path to the graphic instead.

Please advise. Thanks.98% of all articles or opinions I've seen reccomend storing them outside the DB. SQL is not a good storage mechanism for files.

HTH|||Originally posted by fused
The images each are in Jpeg format (black and white, with some grey scale). File size wise, wouldnt be huge < 50 KB.

There wont be too many people using the system.

Would it be tedious to maintain? Many people recommend storing the path to the graphic instead.

Please advise. Thanks.

We have a proffesianally built imaging system that stores all the images on the disk and just references them from the database.

I agree that they should be left outside the DB.|||Originally posted by jimpen
We have a proffesianally built imaging system that stores all the images on the disk and just references them from the database.

I agree that they should be left outside the DB.

Right now, we are planning a project to store some images. What's the scripting language that you use? Any advice? Thanks.

So you guys have a file server that has permission given to everyone? And when you upload the pic, the picture is moved to the shared file server? And a path is inserted into the sql server?

Please advise.|||I have an ASP app that does this sort of thing. I read through the directories, and display the file names as hyperlinks without even using a db connection. This method works really well if you can get the user to name the files in such a way that the links on the page look ok...which is normally not an easy task, but it's worked pretty well for me...But this is an IntrAnet app. , not a web app..|||We use ASP.Net with C# on Windows IIS. You know the IP of the computer, create a sub directory (eg /Images) and use a component that looks in this directory (we use Borland C# Builder but Visual Studio will have this probably as well). To let users upload their images, you can use ASPUpload (www.aspupload.com)|||Originally posted by fused
Right now, we are planning a project to store some images. What's the scripting language that you use? Any advice? Thanks.

So you guys have a file server that has permission given to everyone? And when you upload the pic, the picture is moved to the shared file server? And a path is inserted into the sql server?

Please advise.

Ours is provided by a VAR of http://www.imagesoft.com/.

Read permissions are given by group as well as write. We have different sections that are available to different groups depending on what they need/are allowed to see.