I'm not sure what's happening in your environment - maybe some other process "resets" your data and sets the fields to NULL? Can you be more specific?

Try to use the "nodes" method of the xml datatype (see BOL). You can also use an "xml schema collection" for the xml data.

See for example BOL --->CONTAINS (Transact-SQL) ---> Using CONTAINS with variables. Starting from this example, you can build your stored procedure.

As far as I can see at this moment, there is no problem with the "0" value if you take care to update the field according to your needs or...

Indeed the "small" tables won't be "touched" - in most of the cases.

See http://sqlserverpedia.com/blog/sql-server-bloggers/index-fragmentation-findings-part-2-size-matters/ for some relevant numbers.

See also SQL 2005 BOL ---> Reorganizing and Rebuilding Indexes -...

As far as I know there is no "default schema" for a session. But you can set a default schema for your user in every database it has access to.

Another valuable resource is

http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/

Besides what GilaMonster had already mentioned - directly changing data in the system tables (sql 2000).

Tom.Thomson (3/20/2009)

This is slightly wrong - it makes no difference whether the index is clustered or not. What's required for the query to run instead of waiting for the lock...

kevin.l.williams (3/20/2009)

---

I am not sure but I think that since there is no index or key defined on the table the select statement will cause a table scan and because...

Unfortunately the import/export wizard will not help you...

Do you use " as a text qualifier?

This is a rather long story, and BOL...

Try to skip the empty columns using a format file with bcp, or creating a SSIS package and editing the column mappings.

Another solution may be creating a string parser -...

halifaxdal (3/19/2009)

---

I used " (double quote), which you can see in the text file, as the column delimiter, the problem is it creates empty column for every real column for...