Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Transact-SQL (2005)  OPENROWSET question

Author  Topic  jblah Starting Member 11 Posts Posted - 2008-06-30 : 16:00:41 i'm trying to upload data into a database using openrowset to load the data directly from a file into the database. I would like to know if there is a way for me use a shorter syntax for the open rowset location since i am storing it in the same file as the saved sql statement. If anyone can help me out with this i would highly appreciate it..thank you. DECLARE @bankdata xml SET @bankdata = (SELECT CAST(BulkColumn AS XML) FROM openrowset(bulk N'C:\xxxxx\xxxxx\xxxxx\xxxxxxxxxx\xxxxx\xxxxx.xml', single_blob) AS X) basically i am using the entire path in my openrowset. I would like to use just part of the path since it is part of the same folder. i would like to replace C:\xxxxx\xxxxx\xxxxx\xxxxxxxxxx\xxxxx\xxxxx.xml with something like \xxxxx.xml. Any help would be highly appreciated. Thank you.