Re: SQL SERVER

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Philippe [MS] (ptrotin_at_online.microsoft.com)
Date: 10/19/04 

Date: Tue, 19 Oct 2004 22:51:45 +0200

Sorry Aaron,

The only reason why I mentioned XML is because it's frequently opposed to
the relationnal model. What I just want to say is even if sometimes it's not
very easy to define a good modelisation on a relational way, you could
stored extra information (just the "not so relationnal" part :-)) in a
specific column and get benefits of accessing XML data thrue SQL Server
(much much better in SQL 2005 believe me I am still using it !!!)

If the whole package is not relationnal at all, I am totally agree with you
: you do not need SQL to store that !!! :-)

Phil.

"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:Ojoz7whtEHA.2808@TK2MSFTNGP14.phx.gbl...
> > If your web site is a static one maybe not using a database could be a
> good
> > choice for you but if you need to store information concerning users
where
> > are you going to store informations ???
>
> You brought up XML files specifically (still not sure why). Look back at
my
> first reply to the original poster... if he needs to store relational data
> (e.g. information concerning users), where did I suggest that he shouldn't
> use a database? My only objection was that suddenly we need to buy SQL
> Server so we have a place to put our XML files. And I still don't
> understand why XML files even entered the conversation.
>
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>

Relevant Pages

  • Re: Is there a way to convert ms sql 2008 tables to XML files?
    ... After looking at the code I made it work, since I removed 2 nVARCHARcolumns from the SQL statement where it is used as an RTF. ... I have the 2 XML files the bad and the good which are below: ... Verdana;}{\f1\fnil\fcharset0 Microsoft Sans ... Here is the actual string copied from the ms sql 2008 which works fine; ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: XML-Speicherung beim SQL Server 2005
    ... > also wenn die XML-Dokumente geparst werden, ... das der SQL Server dafür XQuery einsetzt. ... Struktur von XML. ...
    (microsoft.public.de.sqlserver)
  • Possible?? SQL Svr obtaining data via SOAP/XML from another SQL Sv
    ... SQL servers (one local, one remote through the internet). ... I used VBScript, MSXML, MSSOAP to connect, query, parse and insert data into ... XML" functionality provided in SELECT verb. ...
    (microsoft.public.sqlserver.xml)
  • Re: Implementation of boolean types.
    ... >> Marshall Spight wrote: ... I think of SQL as bringing the 3VL into popularity, ... world and XML will surely play I roll. ... XML doesn't address data management; ...
    (comp.databases.theory)
  • RE: Data Insertion
    ... Ilya ... fix for loading XML into the DataSet. ... > Are there any benchmarks for data insertion with SQL CE and ADO.net? ... Load ~1 MB XML file into the DataSet with schema preloaded (3 nested ...
    (microsoft.public.dotnet.framework.compactframework)