Stack Overflow
Stack Overflow

Questions tagged [shred]

Shredding refers to the decomposition of XML data structures into the columns of a relational database. It can also refer to overwriting the contents of a file in an attempt to prevent recovery of deleted data.

64 questions
0
votes
1 answer

Loop on XML data

In my SQL Server table one column has datatype as XML. It contains data as: I am fetching name1,…
richa verma
  • 247
  • 2
  • 13
0
votes
2 answers

MSSQL Number from XML (varchar) cells

Can you tell me how to parse XML not only correctly, but beautifully, considering that the cell in nvarchar(max) is the number between two tags? Example (XML): 9223372036854775807 …
malltaf
  • 11
  • 2
0
votes
0 answers

How do I access harddisk in ubuntu?

How do I access harddisk in ubuntu? "/ dev / sdb" is just a node. The code I added below was coded to replace zero with the data on the entire disk. but what I noticed later is that there is no "/ dev / sdb" dimension. import os def main(sektor): …
Muhammet Onur Aslan
  • 1
  • 5
0
votes
2 answers

Importing XML into SQL Server DB - getting blank results

I am trying to import a publicly available set of data into an SQL Server DB. I am a newbie, and am struggling with this - spent most of today on this problem... It returns no results, no matter how much tweaking I do. The examples available…
Matt
  • 1
0
votes
2 answers

get values from xml by sql query when several attributes

There is xml with several attributes "Num" DECLARE @XML XML = ' '; With this sql query only one attribute…
Tom Kev
  • 146
  • 10
0
votes
1 answer

Xml and MS SQL Server 2019, insert

I am connecting to a Tcp socket and a receive xml feeds. for an example lets say the xml is like the follow.
icinema gr
  • 310
  • 3
  • 14
0
votes
1 answer

Shredding XML column data into rows in SQL

I have an xml value 1John 5James I am able to shred the above xml into tables of ID and Name column using the below query Declare @X xml select…
user6462369
0
votes
3 answers

How to use tumbling window to group XML elements by content?

How do I group based on whether there's a match to [0-9] for digits with a tumbling window? desired output: ... joe phone1 phone2 ... current output, not grouped: …
Thufir
  • 8,216
  • 28
  • 125
  • 273
0
votes
2 answers

SET - EXECUTE in TSQL with passed variable

I'm working with an OPENROWSET (BULK...) insert where I'm inserting a small XML file into a table before ultimately shredding and transforming it. The following works just fine (many thanks to other posts). DECLARE @v_inputfile AS…
trying2figureitout
  • 3
  • 2
0
votes
1 answer

TSQL Shred XML - Is this right or is there a better way (newbie @ shredding XML)

Ok, I'm a C# ASP.NET dev following orders: The orders are to take a given dataset, shred the XML and return columns. I've argued that it's easier to do the shredding on the ASP.NET side where we already have access to things like deserializers, etc,…
jcolebrand
  • 15,889
  • 12
  • 75
  • 121
0
votes
2 answers

shred and remove files in linux from a C program

I want to shred some temp files produced by my C program before the files are removed. Currently I am using system("shred /tmp/datafile"); system("rm /tmp/datafile"); from within my program, but I think instead of calling the system function is…
upInCloud
  • 979
  • 2
  • 10
  • 29
0
votes
2 answers

Can't write over files

I am trying to code a file shredder in PHP, and I get these errors: Warning: fopen(calculate): failed to open stream: Permission denied in C:\XAMPP\htdocs\shred.php on line 9 Warning: fwrite() expects parameter 1 to be resource, string given in…
Hypothermia
  • 11
  • 1
0
votes
3 answers

Writing to free space

I was wondering if It is possible to write to freespace in C#? I mean something like FreeSpace.WriteAllBytes() or like what some shredder apps do? How can I do so?
user182513
0
votes
0 answers

How to shred a file from external storage beyond recovery, using java code?

How to shred a file from external storage beyond recovery, using java code in android?
user2435558
  • 31
  • 3
0
votes
1 answer

Shred Recycle Bin - Python

I am developing a file shredder for windows 32 using Python 2.7. One of the desired features is be able to shred all recycle bin contents. As for other files, outside of the recycle bin, we implemented a "shred" function, which overwrites the file…
Ababneh A
  • 1,104
  • 4
  • 15
  • 32
1 2 3
4
5