<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-3529340304316648370</id><updated>2026-07-23T23:02:35.608-07:00</updated><category term="SQL"/><category term="ASP"/><category term="LinqSQL"/><category term="Vb.net"/><category term="Ajax"/><category term="GPS"/><category term="Javascript"/><category term="Avante"/><category term="Cachuelos"/><category term="LinqDataSet"/><category term="LinqObjetos"/><category term="Otros"/><category term="WebService"/><title type='text'>Carlos Vallejo</title><subtitle type='html'>Consultoria en desarrollo de software.</subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://vallejocarlos.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://vallejocarlos.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><link rel='next' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default?start-index=26&amp;max-results=25&amp;redirect=false'/><author><name>Carlos Vallejo</name><uri>http://www.blogger.com/profile/00677841853099549076</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>42</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-3529340304316648370.post-8355726818445508913</id><published>2019-11-26T05:42:00.002-08:00</published><updated>2019-11-26T06:08:51.370-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="SQL"/><title type='text'>Elimina una columna y su dependencia de default value</title><content type='html'>&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;Create procedure DropDefaultConstraint&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;@Tabla varchar(100),&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;@Campo varchar(100)&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;as&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;Declare @Constrain varchar(250)&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;Declare @dato&amp;nbsp;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp;varchar(250)&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;begin&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;if Exists(SELECT&amp;nbsp; &amp;nbsp; d.name&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt;      &lt;/span&gt;FROM&amp;nbsp; &amp;nbsp;sys.default_constraints AS d&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt;         &lt;/span&gt;&amp;nbsp; INNER JOIN sys.columns AS c&amp;nbsp; ON d.parent_object_id = c.object_id AND d.parent_column_id = c.column_id&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt;      &lt;/span&gt;WHERE d.parent_object_id = OBJECT_ID(@Tabla, N&#39;U&#39;) AND c.name = @Campo)&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;begin&amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt;   &lt;/span&gt;select &#39;S&#39;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt;  &lt;/span&gt;&amp;nbsp; &amp;nbsp;--Si existe recupera el nombre del constrain&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt;  &lt;/span&gt;&amp;nbsp; &amp;nbsp;SELECT&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; @Constrain = d.name&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt;  &lt;/span&gt;&amp;nbsp; &amp;nbsp;FROM&amp;nbsp; &amp;nbsp;sys.default_constraints AS d&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt;      &lt;/span&gt;INNER JOIN sys.columns AS c&amp;nbsp; ON d.parent_object_id = c.object_id AND d.parent_column_id = c.column_id&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt;  &lt;/span&gt;&amp;nbsp; &amp;nbsp;WHERE d.parent_object_id = OBJECT_ID(@Tabla, N&#39;U&#39;) AND c.name = @Campo&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt;  &lt;/span&gt;&amp;nbsp; &amp;nbsp;--Scryp dinámico para eliminar el constrain recuperado&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt;  &lt;/span&gt;&amp;nbsp; &amp;nbsp;set @dato = &#39;Alter table &#39; + @Tabla + &#39; drop constraint &#39; + @Constrain&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt;  &lt;/span&gt;&amp;nbsp; &amp;nbsp;--Ejecuta la sentencia de eliminación del constrain&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt;  &lt;/span&gt;&amp;nbsp; &amp;nbsp;exec(@dato)&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt;  &lt;/span&gt;&amp;nbsp; &amp;nbsp;--Elimina la columna&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt;  &lt;/span&gt;&amp;nbsp; &amp;nbsp;set @dato = &#39;Alter table &#39; + @Tabla + &#39; drop column &#39; + @Campo&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt;  &lt;/span&gt;&amp;nbsp; &amp;nbsp;exec(@dato)&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;end&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;end&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black; color: white;&quot;&gt;--Para usarlo&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;DropDefaultConstraint &#39;Tutabla&#39;,&#39;TuColumna&#39;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://vallejocarlos.blogspot.com/feeds/8355726818445508913/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://vallejocarlos.blogspot.com/2019/11/elimina-una-columna-y-su-dependencia-de.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/8355726818445508913'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/8355726818445508913'/><link rel='alternate' type='text/html' href='http://vallejocarlos.blogspot.com/2019/11/elimina-una-columna-y-su-dependencia-de.html' title='Elimina una columna y su dependencia de default value'/><author><name>Carlos Vallejo</name><uri>http://www.blogger.com/profile/00677841853099549076</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3529340304316648370.post-2149340285406113797</id><published>2019-11-26T05:41:00.003-08:00</published><updated>2019-11-26T06:09:16.185-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="SQL"/><title type='text'>Eliminar procedimiento en caso de existir</title><content type='html'>&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;IF OBJECT_ID (N&#39;dbo.MiProcedimiento&#39;, N&#39;P&#39;) IS NOT NULL&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;&amp;nbsp; &amp;nbsp; DROP PROCEDURE MiProcedimiento&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;GO&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://vallejocarlos.blogspot.com/feeds/2149340285406113797/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://vallejocarlos.blogspot.com/2019/11/eliminar-procedimiento-en-caso-de.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/2149340285406113797'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/2149340285406113797'/><link rel='alternate' type='text/html' href='http://vallejocarlos.blogspot.com/2019/11/eliminar-procedimiento-en-caso-de.html' title='Eliminar procedimiento en caso de existir'/><author><name>Carlos Vallejo</name><uri>http://www.blogger.com/profile/00677841853099549076</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3529340304316648370.post-1981213011608814448</id><published>2019-11-26T05:41:00.000-08:00</published><updated>2019-11-26T06:09:53.343-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="SQL"/><title type='text'>Insertar registro en caso de no existir</title><content type='html'>&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;if Not exists (select * from MiTabla&amp;nbsp;where id =9)&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;insert into MiTabla&amp;nbsp;values(1,&#39;Datos&#39;)&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://vallejocarlos.blogspot.com/feeds/1981213011608814448/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://vallejocarlos.blogspot.com/2019/11/insertar-registro-en-caso-de-no-existir.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/1981213011608814448'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/1981213011608814448'/><link rel='alternate' type='text/html' href='http://vallejocarlos.blogspot.com/2019/11/insertar-registro-en-caso-de-no-existir.html' title='Insertar registro en caso de no existir'/><author><name>Carlos Vallejo</name><uri>http://www.blogger.com/profile/00677841853099549076</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3529340304316648370.post-7039134221771752837</id><published>2019-11-26T05:40:00.002-08:00</published><updated>2019-11-26T06:10:33.281-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="SQL"/><title type='text'>Crear un campo en caso de no existir</title><content type='html'>&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;If Not Exists(Select * from INFORMATION_SCHEMA.COLUMNS Where COLUMN_NAME = &#39;MiCampo&#39; AND TABLE_NAME = &#39;MiTabla&#39;)&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;Alter Table MiTabla Add MiCampo smallint&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://vallejocarlos.blogspot.com/feeds/7039134221771752837/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://vallejocarlos.blogspot.com/2019/11/crear-un-campo-en-caso-de-no-existir.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/7039134221771752837'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/7039134221771752837'/><link rel='alternate' type='text/html' href='http://vallejocarlos.blogspot.com/2019/11/crear-un-campo-en-caso-de-no-existir.html' title='Crear un campo en caso de no existir'/><author><name>Carlos Vallejo</name><uri>http://www.blogger.com/profile/00677841853099549076</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3529340304316648370.post-6381663074174574814</id><published>2019-11-26T05:39:00.002-08:00</published><updated>2019-11-26T06:10:50.612-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="SQL"/><title type='text'>Eliminar una tabla en caso de exiistir</title><content type='html'>&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;If Exists(Select 1 From sys.objects Where OBJECT_ID = OBJECT_ID(&#39;MiTabla&#39;) AND type = (&#39;U&#39;))&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;font-family: verdana, arial, helvetica, sans-serif; font-size: 11px; text-align: justify;&quot;&gt;
&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;color: white;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;DROP TABLE MiTabla&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://vallejocarlos.blogspot.com/feeds/6381663074174574814/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://vallejocarlos.blogspot.com/2019/11/eliminar-una-tabla-en-caso-de-exiistir.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/6381663074174574814'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/6381663074174574814'/><link rel='alternate' type='text/html' href='http://vallejocarlos.blogspot.com/2019/11/eliminar-una-tabla-en-caso-de-exiistir.html' title='Eliminar una tabla en caso de exiistir'/><author><name>Carlos Vallejo</name><uri>http://www.blogger.com/profile/00677841853099549076</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3529340304316648370.post-2752945304390222056</id><published>2015-05-29T15:13:00.004-07:00</published><updated>2015-05-29T15:13:46.072-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="SQL"/><title type='text'>Modificar Collate a una columna de una tabla en SQLserver</title><content type='html'>&lt;span style=&quot;color: blue; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: blue; font-size: x-small;&quot;&gt;ALTER&lt;/span&gt;&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: blue; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: blue; font-size: x-small;&quot;&gt;TABLE&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt; Borrar &lt;/span&gt;&lt;span style=&quot;color: blue; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: blue; font-size: x-small;&quot;&gt;ALTER&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: blue; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: blue; font-size: x-small;&quot;&gt;COLUMN&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt; Canal &lt;/span&gt;&lt;span style=&quot;color: blue; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: blue; font-size: x-small;&quot;&gt;varchar &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: grey; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: grey; font-size: x-small;&quot;&gt;(&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;2&lt;/span&gt;&lt;span style=&quot;color: grey; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: grey; font-size: x-small;&quot;&gt;)&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: blue; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: blue; font-size: x-small;&quot;&gt;COLLATE&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt; Modern_Spanish_CI_AS &lt;/span&gt;&lt;span style=&quot;color: grey; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: grey; font-size: x-small;&quot;&gt;NOT&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: grey; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: grey; font-size: x-small;&quot;&gt;NULL&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: grey; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: grey; font-size: x-small;&quot;&gt;&lt;/span&gt;&lt;/span&gt;</content><link rel='replies' type='application/atom+xml' href='http://vallejocarlos.blogspot.com/feeds/2752945304390222056/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://vallejocarlos.blogspot.com/2015/05/modificar-collate-una-columna-de-una.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/2752945304390222056'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/2752945304390222056'/><link rel='alternate' type='text/html' href='http://vallejocarlos.blogspot.com/2015/05/modificar-collate-una-columna-de-una.html' title='Modificar Collate a una columna de una tabla en SQLserver'/><author><name>Carlos Vallejo</name><uri>http://www.blogger.com/profile/00677841853099549076</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3529340304316648370.post-2361179761833317246</id><published>2014-12-04T12:23:00.002-08:00</published><updated>2014-12-04T12:23:23.806-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="SQL"/><title type='text'>Porcentaje por cantidad en SQL</title><content type='html'>&lt;span style=&quot;font-size: x-small;&quot;&gt;Declare @DATOS table(nombre varchar(30),valor int )&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: x-small;&quot;&gt;Insert Into @DATOS Values(&#39;Brasil&#39;,10),(&#39;Ecuador&#39;,5),(&#39;Argentina&#39;,5)&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: x-small;&quot;&gt;Select * , (valor*100.0)/(SUM( valor ) OVER()) as porcen&lt;br /&gt;From @DATOS &lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;/span&gt;</content><link rel='replies' type='application/atom+xml' href='http://vallejocarlos.blogspot.com/feeds/2361179761833317246/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://vallejocarlos.blogspot.com/2014/12/porcentaje-por-cantidad-en-sql.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/2361179761833317246'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/2361179761833317246'/><link rel='alternate' type='text/html' href='http://vallejocarlos.blogspot.com/2014/12/porcentaje-por-cantidad-en-sql.html' title='Porcentaje por cantidad en SQL'/><author><name>Carlos Vallejo</name><uri>http://www.blogger.com/profile/00677841853099549076</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3529340304316648370.post-7115821470741851997</id><published>2014-11-24T12:04:00.003-08:00</published><updated>2014-11-24T12:04:33.519-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="SQL"/><title type='text'>ELIMINAR TODOS LOS REGISTROS DE LAS TABLAS DE UNA BASE</title><content type='html'>EXEC sp_MSForEachTable &#39;ALTER TABLE ? NOCHECK CONSTRAINT ALL&#39;&lt;br /&gt;
GO&lt;br /&gt;
EXEC sp_MSForEachTable &#39;ALTER TABLE ? DISABLE TRIGGER ALL&#39;&lt;br /&gt;
GO&lt;br /&gt;
EXEC sp_MSForEachTable&lt;br /&gt;
&#39;BEGIN TRY&lt;br /&gt;
&amp;nbsp;&amp;nbsp; TRUNCATE TABLE ?&lt;br /&gt;
END TRY&lt;br /&gt;
BEGIN CATCH&lt;br /&gt;
&amp;nbsp;&amp;nbsp; DELETE FROM ?&lt;br /&gt;
END CATCH;&#39;&lt;br /&gt;
EXEC sp_MSForEachTable &#39;ALTER TABLE ? CHECK CONSTRAINT ALL&#39;&lt;br /&gt;
GO&lt;br /&gt;
EXEC sp_MSForEachTable &#39;ALTER TABLE ? ENABLE TRIGGER ALL&#39;&lt;br /&gt;
GO</content><link rel='replies' type='application/atom+xml' href='http://vallejocarlos.blogspot.com/feeds/7115821470741851997/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://vallejocarlos.blogspot.com/2014/11/eliminar-todos-los-registros-de-las.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/7115821470741851997'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/7115821470741851997'/><link rel='alternate' type='text/html' href='http://vallejocarlos.blogspot.com/2014/11/eliminar-todos-los-registros-de-las.html' title='ELIMINAR TODOS LOS REGISTROS DE LAS TABLAS DE UNA BASE'/><author><name>Carlos Vallejo</name><uri>http://www.blogger.com/profile/00677841853099549076</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3529340304316648370.post-739053944087033274</id><published>2014-11-24T12:03:00.001-08:00</published><updated>2014-11-24T12:03:08.285-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="SQL"/><title type='text'>Función que retorna una tabla</title><content type='html'>create function dbo.fuda1(@id int)&lt;br /&gt;returns table&amp;nbsp;&lt;br /&gt;as&amp;nbsp;&lt;br /&gt;Return&lt;br /&gt;select top 1 id, descr from uno2 where &lt;a href=&quot;mailto:id=@id&quot;&gt;id=@id&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='http://vallejocarlos.blogspot.com/feeds/739053944087033274/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://vallejocarlos.blogspot.com/2014/11/funcion-que-retorna-una-tabla.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/739053944087033274'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/739053944087033274'/><link rel='alternate' type='text/html' href='http://vallejocarlos.blogspot.com/2014/11/funcion-que-retorna-una-tabla.html' title='Función que retorna una tabla'/><author><name>Carlos Vallejo</name><uri>http://www.blogger.com/profile/00677841853099549076</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3529340304316648370.post-2321430807480104014</id><published>2014-11-24T11:55:00.002-08:00</published><updated>2014-11-24T11:55:35.438-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="SQL"/><title type='text'>Enumerar registros por agrupamiento</title><content type='html'>Select  &#39;DOCTOR&#39;=Doctor,&#39;NO.&#39; = ROW_NUMBER() OVER (PARTITION BY Doctor ORDER BY Fecha),
   &#39;#FICHA&#39;=FICHA,
   &#39;FECHA-HORA&#39;=CONVERT(VARCHAR(8),Fecha,112)+ SUBSTRING(Hora,1,6)
from TRATAMIENTOS </content><link rel='replies' type='application/atom+xml' href='http://vallejocarlos.blogspot.com/feeds/2321430807480104014/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://vallejocarlos.blogspot.com/2014/11/enumerar-registros-por-agrupamiento.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/2321430807480104014'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/2321430807480104014'/><link rel='alternate' type='text/html' href='http://vallejocarlos.blogspot.com/2014/11/enumerar-registros-por-agrupamiento.html' title='Enumerar registros por agrupamiento'/><author><name>Carlos Vallejo</name><uri>http://www.blogger.com/profile/00677841853099549076</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3529340304316648370.post-6206340355525871249</id><published>2013-08-23T09:58:00.000-07:00</published><updated>2014-11-24T11:56:42.444-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="SQL"/><title type='text'>Crear usuario de base de datos via scrypt</title><content type='html'>EXEC sp_addlogin &#39;tuuser&#39;, &#39;tupass&#39;, &#39;master&#39;, &#39;English&#39;

EXEC sp_addsrvrolemember &#39;tuuser&#39;, &#39;sysadmin&#39;

EXEC sp_addsrvrolemember &#39;tuuser&#39;, &#39;securityadmin&#39;</content><link rel='replies' type='application/atom+xml' href='http://vallejocarlos.blogspot.com/feeds/6206340355525871249/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://vallejocarlos.blogspot.com/2013/08/crear-usuar-de-base-de-datos-via-scrypt.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/6206340355525871249'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/6206340355525871249'/><link rel='alternate' type='text/html' href='http://vallejocarlos.blogspot.com/2013/08/crear-usuar-de-base-de-datos-via-scrypt.html' title='Crear usuario de base de datos via scrypt'/><author><name>Carlos Vallejo</name><uri>http://www.blogger.com/profile/00677841853099549076</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3529340304316648370.post-4925045057341482585</id><published>2013-08-23T09:54:00.005-07:00</published><updated>2013-08-23T09:54:41.747-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="SQL"/><title type='text'>Eliminar Log de una base de datos</title><content type='html'>codigo para eliminar el tamaño el Log 
Desatacha la base de datos
sp_detach_db &#39;DBName&#39;
Mueve el actual archivo.log a otra ruta.

Y por último atacha nuevametne la base, con esto se crea un nuevo archivo .log
sp_attach_db &#39;DBName&#39;, &#39;Ruta\nombrearchivo.mdf&#39;</content><link rel='replies' type='application/atom+xml' href='http://vallejocarlos.blogspot.com/feeds/4925045057341482585/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://vallejocarlos.blogspot.com/2013/08/eliminar-log-de-una-base-de-datos.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/4925045057341482585'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/4925045057341482585'/><link rel='alternate' type='text/html' href='http://vallejocarlos.blogspot.com/2013/08/eliminar-log-de-una-base-de-datos.html' title='Eliminar Log de una base de datos'/><author><name>Carlos Vallejo</name><uri>http://www.blogger.com/profile/00677841853099549076</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3529340304316648370.post-3059611843855476410</id><published>2011-11-24T07:21:00.001-08:00</published><updated>2011-11-24T07:22:06.907-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="LinqSQL"/><category scheme="http://www.blogger.com/atom/ns#" term="SQL"/><title type='text'>Recibe parametro tipo Tabla enviado dèsde .net</title><content type='html'>--Crea el data Type de tipo Tabla&lt;br /&gt;CREATE TYPE dtCliente AS TABLE&lt;br /&gt;(&lt;br /&gt;id int not null,&lt;br /&gt;Nombre varchar(10) not null&lt;br /&gt;PRIMARY KEY (id)&lt;br /&gt;)&lt;br /&gt;GO&lt;br /&gt;--procedimiento que recibe parmetro tipo tabla&lt;br /&gt;create procedure spClientes&lt;br /&gt;@a dtCliente&lt;br /&gt;as&lt;br /&gt;begin&lt;br /&gt;insert into Cliente --tabla clientes&lt;br /&gt;select * from @a&lt;br /&gt;end&lt;br /&gt;--llamada dsde .net con LinqSql&lt;br /&gt;ClientesDataContext objDataClass = new ClientesDataContext(); --Objeto LinqSql&lt;br /&gt;datatableClientes Datatable(); --variable de tipo tabla, definir las columnas y registros a enviar&lt;br /&gt;objDataClass.spClientes(datatableClientes);--llamada al procedimiento enviando la tabla requerida.</content><link rel='replies' type='application/atom+xml' href='http://vallejocarlos.blogspot.com/feeds/3059611843855476410/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://vallejocarlos.blogspot.com/2011/11/recibe-parametro-tipo-tabla-enviado.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/3059611843855476410'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/3059611843855476410'/><link rel='alternate' type='text/html' href='http://vallejocarlos.blogspot.com/2011/11/recibe-parametro-tipo-tabla-enviado.html' title='Recibe parametro tipo Tabla enviado dèsde .net'/><author><name>Carlos Vallejo</name><uri>http://www.blogger.com/profile/00677841853099549076</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3529340304316648370.post-3291520826751509665</id><published>2011-11-24T06:19:00.000-08:00</published><updated>2011-11-24T06:20:06.280-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="LinqSQL"/><title type='text'>Transaccionabilidad con Linq</title><content type='html'>System.Data.Common.DbTransaction trans = null;&lt;br /&gt;ClientesDataContext objDataClass = new ClientesDataContext();&lt;br /&gt;trans = objDataClass.Connection.BeginTransaction();&lt;br /&gt;try&lt;br /&gt;{&lt;br /&gt;objDataClass.Transaction = trans;&lt;br /&gt;objDataClass.InsertCliente(idCliente,txtName.Text,txtDescription.Text);&lt;br /&gt;objDataClass.InsertClienteContactos(idCliente,datatableContactos);&lt;br /&gt;trans.Commit();&lt;br /&gt;}&lt;br /&gt;catch (Exception ex)&lt;br /&gt;{&lt;br /&gt;if (trans != null)&lt;br /&gt;trans.Rollback();&lt;br /&gt;}&lt;br /&gt;finally&lt;br /&gt;{&lt;br /&gt;if (objDataClass.Connection.State == ConnectionState.Open)&lt;br /&gt;objDataClass.Connection.Close();&lt;br /&gt;}</content><link rel='replies' type='application/atom+xml' href='http://vallejocarlos.blogspot.com/feeds/3291520826751509665/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://vallejocarlos.blogspot.com/2011/11/transaccionabilidad-con-linq.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/3291520826751509665'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/3291520826751509665'/><link rel='alternate' type='text/html' href='http://vallejocarlos.blogspot.com/2011/11/transaccionabilidad-con-linq.html' title='Transaccionabilidad con Linq'/><author><name>Carlos Vallejo</name><uri>http://www.blogger.com/profile/00677841853099549076</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3529340304316648370.post-6385168557346820236</id><published>2010-12-17T06:25:00.000-08:00</published><updated>2010-12-17T06:40:02.621-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="GPS"/><title type='text'>Que tal esta Idea usando un GPS</title><content type='html'>Al electrodoméstico de mayor valor de tu hogar, le conectas un GPS, por medio de un proveedor de sms optienes las coordenadas, el GPS tendría que tener bateria luego que el electrodoméstico es desconectado de la toma de energía, existen actualmente GPS que tienen batarias por 2 horas, suficiente para poder detectarlo.&lt;br /&gt;Si tienes un sofware de monitoreo, fácilmente creas una zona, la cual te permite saber si salio el electrodoméstico de la zona establecida, si salio, envía un sms de alerta y lo empiezas a seguir, con esto tienes posibilidad de recuperar no solo ese electrodoméstico, sino todo lo que los dueños de lo ajeno se llevaron de tu casa.&lt;br /&gt;&lt;br /&gt;Sería genial, asi como los celulares tienen el GPS, los electrodomésticos de costo alto, tengan un GPS incorpordo.&lt;br /&gt;&lt;br /&gt;Buena si o no.</content><link rel='replies' type='application/atom+xml' href='http://vallejocarlos.blogspot.com/feeds/6385168557346820236/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://vallejocarlos.blogspot.com/2010/12/que-tal-esta-idea-usando-un-gps.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/6385168557346820236'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/6385168557346820236'/><link rel='alternate' type='text/html' href='http://vallejocarlos.blogspot.com/2010/12/que-tal-esta-idea-usando-un-gps.html' title='Que tal esta Idea usando un GPS'/><author><name>Carlos Vallejo</name><uri>http://www.blogger.com/profile/00677841853099549076</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3529340304316648370.post-2768367258908854785</id><published>2010-04-30T06:31:00.000-07:00</published><updated>2010-04-30T06:48:43.164-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Vb.net"/><title type='text'>Formularios Inteligentes</title><content type='html'>&lt;span style=&quot;font-size:85%;&quot;&gt;Que tal esta aplicación, una sola pantalla que permita crear varios formularios para recopilación de información.&lt;br /&gt;&lt;/span&gt;&lt;div&gt;&lt;div&gt;&lt;span style=&quot;font-size:85%;&quot;&gt;&lt;/span&gt; &lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size:85%;&quot;&gt;Poder crear dinámicamente formularios de acuerdo a la necesidad.&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-size:85%;&quot;&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size:85%;&quot;&gt;A continuación muestro la pantalla para la creación de los mismos.&lt;/span&gt;&lt;/div&gt;&lt;br /&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;br /&gt;&lt;div&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhr1ltGWrMhXNNgOVmYhCmUyYEmYXiFvz5kCxsLjvF2m-jlk-LpXsu9B5d-SrjYD86mlJ7eTzk5EuZokaA_HBvzOEku7ttnfDwUbnhIjAG_7IpcMkwEIkPQtpFE8Fjv3_4NIb4armEmNol8/s1600/Smart1.JPG&quot;&gt;&lt;img id=&quot;BLOGGER_PHOTO_ID_5465923833806730114&quot; style=&quot;DISPLAY: block; MARGIN: 0px auto 10px; WIDTH: 200px; CURSOR: hand; HEIGHT: 128px; TEXT-ALIGN: center&quot; alt=&quot;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhr1ltGWrMhXNNgOVmYhCmUyYEmYXiFvz5kCxsLjvF2m-jlk-LpXsu9B5d-SrjYD86mlJ7eTzk5EuZokaA_HBvzOEku7ttnfDwUbnhIjAG_7IpcMkwEIkPQtpFE8Fjv3_4NIb4armEmNol8/s200/Smart1.JPG&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;span style=&quot;font-family:arial;font-size:85%;&quot;&gt;Permite adicionar los diferentes controles disponibles y ubicarlos dónde sea necesario.&lt;/span&gt;&lt;/div&gt;&lt;br /&gt;&lt;div&gt;&lt;span style=&quot;font-size:85%;&quot;&gt;En el siguiente ejemplo se crea un formulario para solicitar datos personales.&lt;/span&gt;&lt;/div&gt;&lt;br /&gt;&lt;div&gt;&lt;span style=&quot;font-family:arial;font-size:85%;&quot;&gt;Adicionando las etiquetas necesarias.&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;/div&gt;&lt;br /&gt;&lt;div&gt;&lt;span style=&quot;font-size:85%;&quot;&gt;&lt;/span&gt;&lt;img id=&quot;BLOGGER_PHOTO_ID_5465924718100488370&quot; style=&quot;DISPLAY: block; MARGIN: 0px auto 10px; WIDTH: 200px; CURSOR: hand; HEIGHT: 130px; TEXT-ALIGN: center&quot; alt=&quot;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZ-SbFieYFy1sVG7qVACHORa_h2veg3q5OqHJC_jVmcXLQPuf8JNPfmewj9UL94YCZSJryEohaikWq3VDsXC9wzH_zRvkz0ZnkgRwVQtc2cpbtbRjPziatsao5K-WJ1c-q6jILpszBp5LZ/s200/Smart4.JPG&quot; border=&quot;0&quot; /&gt;&lt;span style=&quot;font-family:arial;font-size:85%;&quot;&gt; Adicionando las cajas de texto para la recepción del a información, y posterior a eso, grabar el formulario.&lt;/span&gt; &lt;/div&gt;&lt;div&gt;&lt;br /&gt; &lt;/div&gt;&lt;img id=&quot;BLOGGER_PHOTO_ID_5465925034344745138&quot; style=&quot;DISPLAY: block; MARGIN: 0px auto 10px; WIDTH: 200px; CURSOR: hand; HEIGHT: 132px; TEXT-ALIGN: center&quot; alt=&quot;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjjQDd3J5klQXKYbXviig5IKyyJq0pfdRJnSPInkBD_tU4lIXwgRZ9vZ2amtSI18sEe9P4X7ZXzA0uJFEHSSRzijxFC76cDMJ7mMrSaNfHabygsen8-J_EwvMGeI2RT60l7x-drgA-V31EB/s200/Smart6.JPG&quot; border=&quot;0&quot; /&gt;&lt;/div&gt;&lt;br /&gt;&lt;div&gt;&lt;/div&gt;&lt;br /&gt;&lt;div&gt;&lt;span style=&quot;font-family:arial;font-size:85%;&quot;&gt;Ya almacenado el formulario, lu único que queda es entrar en la pantalla de Formularios y seleccionar el formulario creado y empezar a registrar información.&lt;/span&gt;&lt;/div&gt;&lt;br /&gt;&lt;div&gt;&lt;br /&gt;&lt;img id=&quot;BLOGGER_PHOTO_ID_5465926168708542258&quot; style=&quot;DISPLAY: block; MARGIN: 0px auto 10px; WIDTH: 200px; CURSOR: hand; HEIGHT: 124px; TEXT-ALIGN: center&quot; alt=&quot;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgE9c8jcnbSMXql6RljQ4WCJUklG1dwR02iNhmCgQX4J1pR5hIu1s1yky8Q_NfDSB3v1-6pZ_zGIcUClpOEOP-byR_5lBXAoVlZ8XutP9Cd0g6o5oR1iILf2OwGQpDKbmgHc4tMnhytnx6L/s200/Smart8.JPG&quot; border=&quot;0&quot; /&gt;&lt;br /&gt;&lt;/div&gt;&lt;br /&gt;&lt;div&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://vallejocarlos.blogspot.com/feeds/2768367258908854785/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://vallejocarlos.blogspot.com/2010/04/formularios-inteligentes.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/2768367258908854785'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/2768367258908854785'/><link rel='alternate' type='text/html' href='http://vallejocarlos.blogspot.com/2010/04/formularios-inteligentes.html' title='Formularios Inteligentes'/><author><name>Carlos Vallejo</name><uri>http://www.blogger.com/profile/00677841853099549076</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhr1ltGWrMhXNNgOVmYhCmUyYEmYXiFvz5kCxsLjvF2m-jlk-LpXsu9B5d-SrjYD86mlJ7eTzk5EuZokaA_HBvzOEku7ttnfDwUbnhIjAG_7IpcMkwEIkPQtpFE8Fjv3_4NIb4armEmNol8/s72-c/Smart1.JPG" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3529340304316648370.post-9146448291516980411</id><published>2009-10-02T12:45:00.000-07:00</published><updated>2009-10-02T13:04:44.781-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="GPS"/><title type='text'>GPS con Google Earth y archivos kml</title><content type='html'>&lt;span style=&quot;font-size:85%;&quot;&gt;Una muy buen funcionalidad para monitoreo de vehículos es la de integrar los datos que reporta el GPS y crear un archivo KML el cual posteriormente puede ser visualizado dentro de Google Earth.&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style=&quot;font-size:85%;&quot;&gt;Google Earth nos da la posibiildad de programar la lectura del archivo kml el cual teniendo los datos reportados por el GPS se pueda visualizar el movimiento del vehículo.&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style=&quot;font-size:85%;&quot;&gt;&lt;/span&gt;</content><link rel='replies' type='application/atom+xml' href='http://vallejocarlos.blogspot.com/feeds/9146448291516980411/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://vallejocarlos.blogspot.com/2009/10/gps-con-google-earth-y-archivos-kml.html#comment-form' title='2 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/9146448291516980411'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/9146448291516980411'/><link rel='alternate' type='text/html' href='http://vallejocarlos.blogspot.com/2009/10/gps-con-google-earth-y-archivos-kml.html' title='GPS con Google Earth y archivos kml'/><author><name>Carlos Vallejo</name><uri>http://www.blogger.com/profile/00677841853099549076</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3529340304316648370.post-8667197610092421282</id><published>2009-09-11T14:05:00.001-07:00</published><updated>2009-09-11T14:12:00.586-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="SQL"/><title type='text'>Envío de correo electrónico de base de datos</title><content type='html'>&lt;span style=&quot;font-size:85%;&quot;&gt;A continucación muestro la forma de cómo enviar correos electronicos de base de datos.&lt;br /&gt;Esta funcionalidad es muy útil ya que se puede usar para envío de información necesaria y en el momento que lo requiera.&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhRqBuVUkf-zFqzEJ2pOPPc6FFw1lqhBNAnnmYOC0-TCDEmll8JrSX63aXYaXPRM7YZb4hwAYuX8wcEE3k98GzJjorcIQh3huNznv7gjUwSQTqB7fSrKslNAZpeErZsl17f9uZ7N9wHUshl/s1600-h/Dibujo.JPG&quot;&gt;&lt;img id=&quot;BLOGGER_PHOTO_ID_5380320479219331618&quot; style=&quot;DISPLAY: block; MARGIN: 0px auto 10px; WIDTH: 200px; CURSOR: hand; HEIGHT: 188px; TEXT-ALIGN: center&quot; alt=&quot;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhRqBuVUkf-zFqzEJ2pOPPc6FFw1lqhBNAnnmYOC0-TCDEmll8JrSX63aXYaXPRM7YZb4hwAYuX8wcEE3k98GzJjorcIQh3huNznv7gjUwSQTqB7fSrKslNAZpeErZsl17f9uZ7N9wHUshl/s200/Dibujo.JPG&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;br /&gt;&lt;div&gt;&lt;/div&gt;&lt;br /&gt;&lt;p&gt;&lt;p&gt;&lt;span style=&quot;font-size:85%;&quot;&gt;&lt;/span&gt;&lt;/p&gt;&lt;br /&gt;&lt;p&gt;&lt;/p&gt;&lt;p&gt;&lt;/p&gt;</content><link rel='replies' type='application/atom+xml' href='http://vallejocarlos.blogspot.com/feeds/8667197610092421282/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://vallejocarlos.blogspot.com/2009/09/envio-de-correo-electronico-de-base-de.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/8667197610092421282'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/8667197610092421282'/><link rel='alternate' type='text/html' href='http://vallejocarlos.blogspot.com/2009/09/envio-de-correo-electronico-de-base-de.html' title='Envío de correo electrónico de base de datos'/><author><name>Carlos Vallejo</name><uri>http://www.blogger.com/profile/00677841853099549076</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhRqBuVUkf-zFqzEJ2pOPPc6FFw1lqhBNAnnmYOC0-TCDEmll8JrSX63aXYaXPRM7YZb4hwAYuX8wcEE3k98GzJjorcIQh3huNznv7gjUwSQTqB7fSrKslNAZpeErZsl17f9uZ7N9wHUshl/s72-c/Dibujo.JPG" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3529340304316648370.post-2410810278365738465</id><published>2009-05-25T08:37:00.000-07:00</published><updated>2009-05-25T08:43:37.384-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Vb.net"/><title type='text'>Guardar y leer imágenes en SQL Server désde .net</title><content type='html'>&lt;span style=&quot;font-family:arial;font-size:85%;&quot;&gt;El siguiente ejemplo, muestra como almacenar una imàgen en sql server désde .net, y luego recuperar lo almacenado para ser mostrada en un control PictureBox.&lt;/span&gt;&lt;br /&gt;&lt;div&gt;&lt;span style=&quot;font-family:Arial;font-size:85%;&quot;&gt;Para el ejemplo se usa un control PictureBox y un control OpenFileDialog.&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;/div&gt;&lt;img id=&quot;BLOGGER_PHOTO_ID_5339786995590133986&quot; style=&quot;DISPLAY: block; MARGIN: 0px auto 10px; WIDTH: 320px; CURSOR: hand; HEIGHT: 114px; TEXT-ALIGN: center&quot; alt=&quot;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjez6O9Clz5pI4woJEEL2koHIYwPmrpYSJdpYHLq2JD4EtkNdWuvaCddWh_DQF2ry5FPIS_gePvD4UYTm4pZKtZMdXDLiPHToes8wCiajUersHP6CFkS8Gnuy2LUjQ2elHz82PDBz-kwkG/s320/gRABAimGAGEN.JPG&quot; border=&quot;0&quot; /&gt;&lt;br /&gt;&lt;div&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://vallejocarlos.blogspot.com/feeds/2410810278365738465/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://vallejocarlos.blogspot.com/2009/05/guardar-y-leer-imagenes-en-sql-server.html#comment-form' title='1 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/2410810278365738465'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/2410810278365738465'/><link rel='alternate' type='text/html' href='http://vallejocarlos.blogspot.com/2009/05/guardar-y-leer-imagenes-en-sql-server.html' title='Guardar y leer imágenes en SQL Server désde .net'/><author><name>Carlos Vallejo</name><uri>http://www.blogger.com/profile/00677841853099549076</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjez6O9Clz5pI4woJEEL2koHIYwPmrpYSJdpYHLq2JD4EtkNdWuvaCddWh_DQF2ry5FPIS_gePvD4UYTm4pZKtZMdXDLiPHToes8wCiajUersHP6CFkS8Gnuy2LUjQ2elHz82PDBz-kwkG/s72-c/gRABAimGAGEN.JPG" height="72" width="72"/><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3529340304316648370.post-701022013943643142</id><published>2009-05-15T07:57:00.000-07:00</published><updated>2009-05-15T07:59:48.107-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Cachuelos"/><title type='text'>Cachuelo para Diseñador Gráfico</title><content type='html'>&lt;span style=&quot;font-family:arial;font-size:85%;&quot;&gt;&lt;span style=&quot;font-size:100%;&quot;&gt;&lt;strong&gt;Oferta de trabajo&lt;/strong&gt;&lt;/span&gt;:&lt;/span&gt;&lt;br /&gt;&lt;span style=&quot;font-family:arial;font-size:85%;&quot;&gt;&lt;a href=&quot;http://cachuelos.ning.com/forum/topics/cachuelo-para-disenador&quot;&gt;http://cachuelos.ning.com/forum/topics/cachuelo-para-disenador&lt;/a&gt;&lt;/span&gt;</content><link rel='replies' type='application/atom+xml' href='http://vallejocarlos.blogspot.com/feeds/701022013943643142/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://vallejocarlos.blogspot.com/2009/05/cachuelo-para-disenador-grafico.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/701022013943643142'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/701022013943643142'/><link rel='alternate' type='text/html' href='http://vallejocarlos.blogspot.com/2009/05/cachuelo-para-disenador-grafico.html' title='Cachuelo para Diseñador Gráfico'/><author><name>Carlos Vallejo</name><uri>http://www.blogger.com/profile/00677841853099549076</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3529340304316648370.post-2477686008126365193</id><published>2009-03-19T13:55:00.000-07:00</published><updated>2009-03-19T14:01:36.971-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ASP"/><title type='text'>Filtrar datos en el GridView y Ventanas Emergentes</title><content type='html'>&lt;div align=&quot;justify&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSgkhyphenhyphene1PrPQfoMwFAKxPDvKqYRPtmaHCq5jKqzhLgGUBKz47u7KnqPy9_jmlYLSBG-IUDnlIPkJhPyEPvlQ3HihTlaoF7vZIUXjrESEK3kxRBKcXIFRizXsRC65zeCd6UtNb6BK19Gleq/s1600-h/gridviewF.JPG&quot;&gt;&lt;img id=&quot;BLOGGER_PHOTO_ID_5315005724228653682&quot; style=&quot;DISPLAY: block; MARGIN: 0px auto 10px; WIDTH: 320px; CURSOR: hand; HEIGHT: 157px; TEXT-ALIGN: center&quot; alt=&quot;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSgkhyphenhyphene1PrPQfoMwFAKxPDvKqYRPtmaHCq5jKqzhLgGUBKz47u7KnqPy9_jmlYLSBG-IUDnlIPkJhPyEPvlQ3HihTlaoF7vZIUXjrESEK3kxRBKcXIFRizXsRC65zeCd6UtNb6BK19Gleq/s320/gridviewF.JPG&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;br /&gt;&lt;span style=&quot;font-size:85%;&quot;&gt;La imàgen muestra una implementación de filtros en las columnas del gridview, ademàs de la implementación que permite mostrar una ventana emergente con datos adicionales de un regístro específico.&lt;/span&gt;&lt;br /&gt;&lt;span style=&quot;font-size:85%;&quot;&gt;&lt;/span&gt;&lt;br /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://vallejocarlos.blogspot.com/feeds/2477686008126365193/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://vallejocarlos.blogspot.com/2009/03/filtrar-datos-en-el-gridview-y-ventanas.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/2477686008126365193'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/2477686008126365193'/><link rel='alternate' type='text/html' href='http://vallejocarlos.blogspot.com/2009/03/filtrar-datos-en-el-gridview-y-ventanas.html' title='Filtrar datos en el GridView y Ventanas Emergentes'/><author><name>Carlos Vallejo</name><uri>http://www.blogger.com/profile/00677841853099549076</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSgkhyphenhyphene1PrPQfoMwFAKxPDvKqYRPtmaHCq5jKqzhLgGUBKz47u7KnqPy9_jmlYLSBG-IUDnlIPkJhPyEPvlQ3HihTlaoF7vZIUXjrESEK3kxRBKcXIFRizXsRC65zeCd6UtNb6BK19Gleq/s72-c/gridviewF.JPG" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3529340304316648370.post-5157068022026337507</id><published>2009-02-18T06:04:00.000-08:00</published><updated>2009-02-18T06:08:26.409-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Vb.net"/><title type='text'>Asignar diferente ForeColor a cada Row del DataGridView</title><content type='html'>El siguiente ejemplo, muestra como definir diferente ForeColor a cada uno de los registros del DataGridView, dependiendo de una condición específica.&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiAtzm-TaZj_8jm5Pkevhmlfo9o0A6tuYf8wAssqu8fGHWz40dyRz43agJsPwhqzM-_9RupAvtJHGSmRAYTfPptmQhcg6ydwTv5Nrkg88Wk0cenjGzlFwY_fmpAHGAup8EEBzMmnPOqJiK3/s1600-h/gridview.JPG&quot;&gt;&lt;img id=&quot;BLOGGER_PHOTO_ID_5304138902909296738&quot; style=&quot;DISPLAY: block; MARGIN: 0px auto 10px; WIDTH: 320px; CURSOR: hand; HEIGHT: 93px; TEXT-ALIGN: center&quot; alt=&quot;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiAtzm-TaZj_8jm5Pkevhmlfo9o0A6tuYf8wAssqu8fGHWz40dyRz43agJsPwhqzM-_9RupAvtJHGSmRAYTfPptmQhcg6ydwTv5Nrkg88Wk0cenjGzlFwY_fmpAHGAup8EEBzMmnPOqJiK3/s320/gridview.JPG&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;br /&gt;&lt;div&gt;&lt;span style=&quot;font-family:arial;font-size:85%;&quot;&gt;&lt;/span&gt; &lt;/div&gt;&lt;br /&gt;&lt;div&gt;&lt;span style=&quot;font-family:Arial;font-size:85%;&quot;&gt;&lt;/span&gt;&lt;/div&gt;&lt;br /&gt;&lt;div&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://vallejocarlos.blogspot.com/feeds/5157068022026337507/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://vallejocarlos.blogspot.com/2009/02/asignar-diferente-forecolor-cada-row.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/5157068022026337507'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/5157068022026337507'/><link rel='alternate' type='text/html' href='http://vallejocarlos.blogspot.com/2009/02/asignar-diferente-forecolor-cada-row.html' title='Asignar diferente ForeColor a cada Row del DataGridView'/><author><name>Carlos Vallejo</name><uri>http://www.blogger.com/profile/00677841853099549076</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiAtzm-TaZj_8jm5Pkevhmlfo9o0A6tuYf8wAssqu8fGHWz40dyRz43agJsPwhqzM-_9RupAvtJHGSmRAYTfPptmQhcg6ydwTv5Nrkg88Wk0cenjGzlFwY_fmpAHGAup8EEBzMmnPOqJiK3/s72-c/gridview.JPG" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3529340304316648370.post-9097853488526992127</id><published>2008-12-29T07:31:00.000-08:00</published><updated>2008-12-29T07:32:09.656-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Otros"/><title type='text'>Plan estratégico para el nuevo año.</title><content type='html'>&lt;span style=&quot;font-family:verdana;font-size:85%;&quot;&gt;1.- Enlista de uno en uno cada objetivo que deseas cumplir.&lt;/span&gt;&lt;br /&gt;&lt;span style=&quot;font-family:verdana;font-size:85%;&quot;&gt;&lt;br /&gt;2.- Identifica la cantidad de días laborables y obtén el valor real de días en el año.&lt;br /&gt;&lt;br /&gt;3.- Divide la cantidad de días para 7 y obtén la cantidad de semanas en el año.&lt;br /&gt;&lt;br /&gt;4.- De los 7 días de cada semana, 5 dedica a cumplir los objetivos, los 2 restantes, comparte en familia ya que son la energía fundamental para continuar cada semana.&lt;br /&gt;&lt;br /&gt;5.- Luego de identificar la cantidad de semanas disponibles, repasa cada uno de los objetivos que deseas cumplir y ordénalos en orden de prioridad y menos complejidad.&lt;br /&gt;&lt;br /&gt;6.- Define la o las semanas por cada objetivo, siempre tomando en cuenta un tiempo adicional por cualquier acontecimiento no previsto (tiempo de colchón).&lt;br /&gt;&lt;br /&gt;7.- Luego de tener ya identificado cada uno de los objetivos y el tiempo en resolverlos, asigna responsabilidades a cada miembro del hogar, si crees que pueden ayudar a cumplir ciertos de ellos.&lt;br /&gt;&lt;br /&gt;8.- Pega los objetivos en un lugar visible, en cada objetivo agrega 3 columnas adicionales en las cuales puedas ir marcando, cumplido (si/no), fecha cumplimiento, y una observación.&lt;br /&gt;&lt;br /&gt;9.- Al final del año, revisa tu plan estratégico y verifica cada objetivo cumplido, en caso de existir objetivos no cumplidos, verifica la observación escrita y analiza si lo incluyes o no en la nueva lista de objetivos del nuevo año.&lt;br /&gt;&lt;br /&gt;10.-Repite el mismo proceso en cada inicio del año y verás como mejora tu forma de vida.&lt;br /&gt;&lt;br /&gt;Todo se puede lograr si le pones corazón a cada cosa que haces, la fe en dios y la buena energía te ayudarán a cumplir los objetivos.&lt;br /&gt;&lt;br /&gt;Mucha suerte y un Próspero Año Nuevo.&lt;/span&gt;&lt;br /&gt;&lt;/span&gt;</content><link rel='replies' type='application/atom+xml' href='http://vallejocarlos.blogspot.com/feeds/9097853488526992127/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://vallejocarlos.blogspot.com/2008/12/plan-estratgico-para-el-nuevo-ao.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/9097853488526992127'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/9097853488526992127'/><link rel='alternate' type='text/html' href='http://vallejocarlos.blogspot.com/2008/12/plan-estratgico-para-el-nuevo-ao.html' title='Plan estratégico para el nuevo año.'/><author><name>Carlos Vallejo</name><uri>http://www.blogger.com/profile/00677841853099549076</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3529340304316648370.post-4901017173539516021</id><published>2008-12-01T05:47:00.001-08:00</published><updated>2008-12-01T07:57:53.690-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ASP"/><title type='text'>GridView - Footer Row</title><content type='html'>A continuación muetra un ejemplo de la propiedad ShowFooter del GridView.&lt;br /&gt;&lt;br /&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-5EdSMq_AO69biDdUDVawBAE4am_Fm0UMpzEs9J5vtT7FuGR_j2Irbq-_VVwuOcoi2szs1JO8IrTcACFG92HLh74Vhjojnk86arC38DJ_R9-bMM58zmUQ6DId03ihWpTlsw9B87Zm-vh1/s1600-h/Footer.JPG&quot;&gt;&lt;img id=&quot;BLOGGER_PHOTO_ID_5274818793953063906&quot; style=&quot;DISPLAY: block; MARGIN: 0px auto 10px; WIDTH: 320px; CURSOR: hand; HEIGHT: 175px; TEXT-ALIGN: center&quot; alt=&quot;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-5EdSMq_AO69biDdUDVawBAE4am_Fm0UMpzEs9J5vtT7FuGR_j2Irbq-_VVwuOcoi2szs1JO8IrTcACFG92HLh74Vhjojnk86arC38DJ_R9-bMM58zmUQ6DId03ihWpTlsw9B87Zm-vh1/s320/Footer.JPG&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;br /&gt;&lt;div&gt;&lt;span style=&quot;font-family:verdana;font-size:85%;&quot;&gt;&lt;/span&gt;&lt;/div&gt;&lt;br /&gt;&lt;div&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://vallejocarlos.blogspot.com/feeds/4901017173539516021/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://vallejocarlos.blogspot.com/2008/12/gridview-footer-row.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/4901017173539516021'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/4901017173539516021'/><link rel='alternate' type='text/html' href='http://vallejocarlos.blogspot.com/2008/12/gridview-footer-row.html' title='GridView - Footer Row'/><author><name>Carlos Vallejo</name><uri>http://www.blogger.com/profile/00677841853099549076</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-5EdSMq_AO69biDdUDVawBAE4am_Fm0UMpzEs9J5vtT7FuGR_j2Irbq-_VVwuOcoi2szs1JO8IrTcACFG92HLh74Vhjojnk86arC38DJ_R9-bMM58zmUQ6DId03ihWpTlsw9B87Zm-vh1/s72-c/Footer.JPG" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3529340304316648370.post-878622703811441763</id><published>2008-11-13T05:58:00.000-08:00</published><updated>2008-11-13T05:59:57.428-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ASP"/><title type='text'>Guardar Archivos en SQL Server</title><content type='html'>&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh43_yZzDVVQgjcEL-RVmNcozvUm78AdSTGHuL-WHfZZJ-jR6o4I2XdbPaatQnMhYWQECPBEWOj4gAR4yaRPvdGA3BOe4GxEENz9W99phar-Q0blAgoYNcrDrtWu4dDX-i-VbVH1E2jxOgX/s1600-h/GuardaIMG.JPG&quot;&gt;&lt;img id=&quot;BLOGGER_PHOTO_ID_5268141559285976434&quot; style=&quot;DISPLAY: block; MARGIN: 0px auto 10px; WIDTH: 320px; CURSOR: hand; HEIGHT: 142px; TEXT-ALIGN: center&quot; alt=&quot;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh43_yZzDVVQgjcEL-RVmNcozvUm78AdSTGHuL-WHfZZJ-jR6o4I2XdbPaatQnMhYWQECPBEWOj4gAR4yaRPvdGA3BOe4GxEENz9W99phar-Q0blAgoYNcrDrtWu4dDX-i-VbVH1E2jxOgX/s320/GuardaIMG.JPG&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;br /&gt;&lt;div&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://vallejocarlos.blogspot.com/feeds/878622703811441763/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://vallejocarlos.blogspot.com/2008/11/guardar-archivos-en-sql-server.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/878622703811441763'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3529340304316648370/posts/default/878622703811441763'/><link rel='alternate' type='text/html' href='http://vallejocarlos.blogspot.com/2008/11/guardar-archivos-en-sql-server.html' title='Guardar Archivos en SQL Server'/><author><name>Carlos Vallejo</name><uri>http://www.blogger.com/profile/00677841853099549076</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh43_yZzDVVQgjcEL-RVmNcozvUm78AdSTGHuL-WHfZZJ-jR6o4I2XdbPaatQnMhYWQECPBEWOj4gAR4yaRPvdGA3BOe4GxEENz9W99phar-Q0blAgoYNcrDrtWu4dDX-i-VbVH1E2jxOgX/s72-c/GuardaIMG.JPG" height="72" width="72"/><thr:total>0</thr:total></entry></feed>