snipt

Ctrl+h for KB shortcuts

SQL

To Uppercase

1
2
3
4
UPDATE
<TABLA> 
SET
<CAMPO> = UPPER(<CAMPO>)
https://snipt.net/embed/bcbe39b159135d7240ed26d5e848801c/
/raw/bcbe39b159135d7240ed26d5e848801c/
bcbe39b159135d7240ed26d5e848801c
sql
SQL
4
2019-05-29T02:45:23
True
False
False
/api/public/snipt/7162/
pasar-a-mayusculas
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a> <a href="#L-2">2</a> <a href="#L-3">3</a> <a href="#L-4">4</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="k">UPDATE</span> </span><span id="L-2"><a name="L-2"></a><span class="o">&lt;</span><span class="n">TABLA</span><span class="o">&gt;</span> </span><span id="L-3"><a name="L-3"></a><span class="k">SET</span> </span><span id="L-4"><a name="L-4"></a><span class="o">&lt;</span><span class="n">CAMPO</span><span class="o">&gt;</span> <span class="o">=</span> <span class="k">UPPER</span><span class="p">(</span><span class="o">&lt;</span><span class="n">CAMPO</span><span class="o">&gt;</span><span class="p">)</span> </span></pre></div> </td></tr></table>
sql

VB.net

Byte Array() to file

1
2
3
4
5
6
Dim oFileStream as System.IO.FileStream
Dim mArray() as Byte
 
oFileStream = New System.IO.FileStream("RUTA\Fichero.ext", System.IO.FileMode.Create)
oFileStream.Write(mArray(), 0, <objeto Array()>.Length)
oFileStream.Close()
https://snipt.net/embed/20d62c9bb730f8d6e6c0b0d2e3af876c/
/raw/20d62c9bb730f8d6e6c0b0d2e3af876c/
20d62c9bb730f8d6e6c0b0d2e3af876c
vb.net
VB.net
6
2019-05-27T23:04:29
True
False
False
/api/public/snipt/7159/
crear-ficheros-fisicos
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a> <a href="#L-2">2</a> <a href="#L-3">3</a> <a href="#L-4">4</a> <a href="#L-5">5</a> <a href="#L-6">6</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="k">Dim</span> <span class="n">oFileStream</span> <span class="ow">as</span> <span class="n">System</span><span class="p">.</span><span class="n">IO</span><span class="p">.</span><span class="n">FileStream</span> </span><span id="L-2"><a name="L-2"></a><span class="k">Dim</span> <span class="n">mArray</span><span class="p">()</span> <span class="ow">as</span> <span class="kt">Byte</span> </span><span id="L-3"><a name="L-3"></a> </span><span id="L-4"><a name="L-4"></a><span class="n">oFileStream</span> <span class="o">=</span> <span class="k">New</span> <span class="n">System</span><span class="p">.</span><span class="n">IO</span><span class="p">.</span><span class="n">FileStream</span><span class="p">(</span><span class="s">&quot;RUTA\Fichero.ext&quot;</span><span class="p">,</span> <span class="n">System</span><span class="p">.</span><span class="n">IO</span><span class="p">.</span><span class="n">FileMode</span><span class="p">.</span><span class="n">Create</span><span class="p">)</span> </span><span id="L-5"><a name="L-5"></a><span class="n">oFileStream</span><span class="p">.</span><span class="n">Write</span><span class="p">(</span><span class="n">mArray</span><span class="p">(),</span> <span class="mi">0</span><span class="p">,</span> <span class="o">&lt;</span><span class="n">objeto</span> <span class="n">Array</span><span class="p">()</span><span class="o">&gt;</span><span class="p">.</span><span class="n">Length</span><span class="p">)</span> </span><span id="L-6"><a name="L-6"></a><span class="n">oFileStream</span><span class="p">.</span><span class="n">Close</span><span class="p">()</span> </span></pre></div> </td></tr></table>
fichero, filestream