<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[gpz_dalian的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/gpz_dalian</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; gpz_dalian]]></copyright><item><title><![CDATA[sql server 数据的循环插入]]></title><link>https://blog.youkuaiyun.com/gpz_dalian/article/details/2532143</link><guid>https://blog.youkuaiyun.com/gpz_dalian/article/details/2532143</guid><author>gpz_dalian</author><pubDate>Tue, 10 Jun 2008 16:27:00 +0800</pubDate><description><![CDATA[declare @strsku as varchar(15)declare @sku intset @sku = 60 while @sku beginset @strsku=0000000000000 + cast(@sku + 1 as char(39))insert into dbo.syohinMvalues( @str,001 ,BREAKFAST SET 2  WITH SO]]></description><category></category></item><item><title><![CDATA[ASP.NET 跨页面传值总结]]></title><link>https://blog.youkuaiyun.com/gpz_dalian/article/details/2341810</link><guid>https://blog.youkuaiyun.com/gpz_dalian/article/details/2341810</guid><author>gpz_dalian</author><pubDate>Tue, 29 Apr 2008 10:39:00 +0800</pubDate><description><![CDATA[1. 使用QueryString变量QueryString是一种非常简单的传值方式，他可以将传送的值显示在浏览器的地址栏中。如果是传递一个或多个安全性要求不高或是结构简单的数值时，可以使用这个方法。但是对于传递数组或对象的话，就不能用这个方法了。下面是一个例子：a.aspx的VB.NET代码Private  Sub Button1_Click(ByVal sender As Object,]]></description><category></category></item><item><title><![CDATA[ＳＱＬ文　参考]]></title><link>https://blog.youkuaiyun.com/gpz_dalian/article/details/2122147</link><guid>https://blog.youkuaiyun.com/gpz_dalian/article/details/2122147</guid><author>gpz_dalian</author><pubDate>Tue, 26 Feb 2008 13:56:00 +0800</pubDate><description><![CDATA[-----------------------列から行まで---------------------------------------------------------------------------------------------------------select  部門CD ,部門名 ,sum(case (伝票日付%100) when 1 then 残高 else 0 end]]></description><category></category></item><item><title><![CDATA[トランザクションについて、一つの簡単なサンプル]]></title><link>https://blog.youkuaiyun.com/gpz_dalian/article/details/2122097</link><guid>https://blog.youkuaiyun.com/gpz_dalian/article/details/2122097</guid><author>gpz_dalian</author><pubDate>Tue, 26 Feb 2008 13:45:00 +0800</pubDate><description><![CDATA[CREATE  PROCEDURE TRAN_1 @IN_ID INT = 0, @IN_NAME VARCHAR(10), @IN_ADD VARCHAR(125)ASDECLARE @RE INTBEGIN TRAN TRAN_1UPDATE  dbo.TbExam01SET  Name = @IN_NAMEWHERE ID = @IN_IDINSERT INTO dbo.Tb]]></description><category></category></item><item><title><![CDATA[カーソル（cursor,游标）の使用]]></title><link>https://blog.youkuaiyun.com/gpz_dalian/article/details/2122047</link><guid>https://blog.youkuaiyun.com/gpz_dalian/article/details/2122047</guid><author>gpz_dalian</author><pubDate>Tue, 26 Feb 2008 13:35:00 +0800</pubDate><description><![CDATA[原理：游标就是把数据按照指定要求提取出相应的数据集，然后逐条进行数据处理。      1.1游标的概念       游标(Cursor)它使用户可逐行访问由SQL Server返回的结果集。使用游标(cursor)的一个主要的原因就是把集合操作转换成单个记录处理方式。用SQL语言从数据库中检索数据后，结果放在内存的一块区 域中，且结果往往是一个含有多个记录的集合。游标机制允]]></description><category></category></item><item><title><![CDATA[VB.NET とオラクルの接続（一つ簡単なサンプル)]]></title><link>https://blog.youkuaiyun.com/gpz_dalian/article/details/2048142</link><guid>https://blog.youkuaiyun.com/gpz_dalian/article/details/2048142</guid><author>gpz_dalian</author><pubDate>Thu, 17 Jan 2008 10:24:00 +0800</pubDate><description><![CDATA[Imports System.Data.SqlClientImports Oracle.DataAccess.ClientImports System.Data.CommonPublic Class BankTransactions        Public Sub transferMoney(ByVal amount As Decimal)        Dim connstr As St]]></description><category></category></item><item><title><![CDATA[オラクル10ｇ　データベース作成]]></title><link>https://blog.youkuaiyun.com/gpz_dalian/article/details/2029779</link><guid>https://blog.youkuaiyun.com/gpz_dalian/article/details/2029779</guid><author>gpz_dalian</author><pubDate>Tue, 08 Jan 2008 09:50:00 +0800</pubDate><description><![CDATA[1.テーブルスペース作成DBCA(Database Configuration Assistant)でデータベースを作成するOracle-OraDb10g_home2-->コンフィグレーションよび移行ツール-->データベース・コンフィギュレーション・アシスタント例：http://lsd42195.sakura.ne.jp/xoops/modules/pukiwiki/123.html[SQ]]></description><category></category></item><item><title><![CDATA[ユーザーコントロールの作成]]></title><link>https://blog.youkuaiyun.com/gpz_dalian/article/details/2000011</link><guid>https://blog.youkuaiyun.com/gpz_dalian/article/details/2000011</guid><author>gpz_dalian</author><pubDate>Fri, 28 Dec 2007 14:41:00 +0800</pubDate><description><![CDATA[Imports System.Windows.FormsPublic Class MyWebBrowser    Inherits System.Windows.Forms.WebBrowser    Public Event UrlChanged(ByVal sender As Object, ByVal e As EventArgs)    Dim blnLoad As Boolean ]]></description><category></category></item><item><title><![CDATA[ログオフ、シャットダウンしようとしている時Windwos Form)]]></title><link>https://blog.youkuaiyun.com/gpz_dalian/article/details/1999804</link><guid>https://blog.youkuaiyun.com/gpz_dalian/article/details/1999804</guid><author>gpz_dalian</author><pubDate>Fri, 28 Dec 2007 13:44:00 +0800</pubDate><description><![CDATA[Imports SystemImports Microsoft.Win32Imports System.Net.MailImports System.Net.Mail.SmtpClientPublic Class Form1    Dim smtp() As SmtpClient    Dim MailHost As String = "172.16.1.3"    Dim FromAdd A]]></description><category></category></item><item><title><![CDATA[Windows  サービス　 Windowsがシャットダウンしようとしているとき,メールを送る]]></title><link>https://blog.youkuaiyun.com/gpz_dalian/article/details/1943117</link><guid>https://blog.youkuaiyun.com/gpz_dalian/article/details/1943117</guid><author>gpz_dalian</author><pubDate>Mon, 17 Dec 2007 10:04:00 +0800</pubDate><description><![CDATA[Imports SystemImports System.Windows.FormsImports Microsoft.Win32Imports System.Net.MailImports System.Net.Mail.SmtpClientImports System.ServiceProcessPublic Class Service1    Dim smtp() As SmtpClient]]></description><category></category></item><item><title><![CDATA[Visual Basic .NET または Visual Basic 2005 で Windows サービスのセットアップ プロジェクトを作成する方法]]></title><link>https://blog.youkuaiyun.com/gpz_dalian/article/details/1934403</link><guid>https://blog.youkuaiyun.com/gpz_dalian/article/details/1934403</guid><author>gpz_dalian</author><pubDate>Fri, 14 Dec 2007 09:34:00 +0800</pubDate><description><![CDATA[Microsoft Visual C# .NET については、次の資料を参照してください。(http://support.microsoft.com/kb/317421/ja)目次概要必要条件 Windows サービスのセットアップ プロジェクトを作成する Windows サービス プロジェクトを作成する コンパイルされたセットアップ プロジェクトを使用して Windows サ]]></description><category></category></item><item><title><![CDATA['ログオフ、シャットダウンの通知(メールの方式)]]></title><link>https://blog.youkuaiyun.com/gpz_dalian/article/details/1931655</link><guid>https://blog.youkuaiyun.com/gpz_dalian/article/details/1931655</guid><author>gpz_dalian</author><pubDate>Wed, 12 Dec 2007 16:30:00 +0800</pubDate><description><![CDATA[Imports SystemImports Microsoft.Win32Imports System.Net.MailImports System.Net.Mail.SmtpClientログオフ、シャットダウンの通知Public Class Form1    Dim smtp() As SmtpClient    Dim MailHost As String = "172.18.1.3"   ]]></description><category></category></item><item><title><![CDATA[VBScriptについて]]></title><link>https://blog.youkuaiyun.com/gpz_dalian/article/details/1928726</link><guid>https://blog.youkuaiyun.com/gpz_dalian/article/details/1928726</guid><author>gpz_dalian</author><pubDate>Tue, 11 Dec 2007 09:43:00 +0800</pubDate><description><![CDATA[今の期日と曜日を取得するDim   MyWeek   Dim   MyWeekIndex   MyWeek   =   Array("星期日","星期一","星期二","星期三","星期四","星期五","星期六")   MyWeekIndex   =   Weekday(Date)   MsgBox  now() &" "& MyWeek(MyWeekIndex-1)     メールを送]]></description><category></category></item><item><title><![CDATA[Oracle 左连接和右连接]]></title><link>https://blog.youkuaiyun.com/gpz_dalian/article/details/1922769</link><guid>https://blog.youkuaiyun.com/gpz_dalian/article/details/1922769</guid><author>gpz_dalian</author><pubDate>Fri, 07 Dec 2007 15:18:00 +0800</pubDate><description><![CDATA[在Oracle PL-SQL中，左连接和右连接以如下方式来实现 查看如下语句： SELECT emp_name, dept_name  FORM Employee, Department WHERE Employee.emp_deptid(+) = Department.deptid此SQL文使用了右连接，即“(+)”所在位置的另一侧为连接的方向，右连接说明等号右侧的所有记录均会被显示，无论其在左]]></description><category></category></item><item><title><![CDATA[VB.Net操作]]></title><link>https://blog.youkuaiyun.com/gpz_dalian/article/details/1918716</link><guid>https://blog.youkuaiyun.com/gpz_dalian/article/details/1918716</guid><author>gpz_dalian</author><pubDate>Wed, 05 Dec 2007 17:00:00 +0800</pubDate><description><![CDATA[Ctrl+Shift+F9  去掉所有断点Ctrl+Shift+U   小写字母变大写Ctrl+U             大写字母变小写 ]]></description><category></category></item><item><title><![CDATA[如何让程序只开启一个例程(コンソール　アプリケーション,mutex)]]></title><link>https://blog.youkuaiyun.com/gpz_dalian/article/details/1861492</link><guid>https://blog.youkuaiyun.com/gpz_dalian/article/details/1861492</guid><author>gpz_dalian</author><pubDate>Thu, 01 Nov 2007 16:28:00 +0800</pubDate><description><![CDATA[Imports SystemImports System.ThreadingModule Module1    Sub Main()        Dim mutex As System.Threading.Mutex = New Threading.Mutex(False, "this should only run once")        Dim run As Boolean = T]]></description><category></category></item><item><title><![CDATA[VB.NET とオラクルの接続（com+ コンポーネント)]]></title><link>https://blog.youkuaiyun.com/gpz_dalian/article/details/1861476</link><guid>https://blog.youkuaiyun.com/gpz_dalian/article/details/1861476</guid><author>gpz_dalian</author><pubDate>Thu, 01 Nov 2007 16:20:00 +0800</pubDate><description><![CDATA[これは自分で作ったCOM+コンポーネントです。EnterpriseServicesのContextUtiを利用して、二つの更新操作は一緒に実行します。Imports System.EnterpriseServicesImports System.Data.SqlClientImports Oracle.DataAccess.ClientImports System.Data.Common]]></description><category></category></item><item><title><![CDATA[VB.Net 使用Thread和DoEvent 进行并发处理]]></title><link>https://blog.youkuaiyun.com/gpz_dalian/article/details/1844360</link><guid>https://blog.youkuaiyun.com/gpz_dalian/article/details/1844360</guid><author>gpz_dalian</author><pubDate>Fri, 26 Oct 2007 09:36:00 +0800</pubDate><description><![CDATA[进度条控制问题:一.BackgroundWorker 组件 和Thread许多经常执行的操作可能需要很长的执行时间。类似这样的操作可能导致用户界面在操作运行时挂起。如果您需要用户界面的响应却遇到与此类操作关联的长时间延迟，BackgroundWorker组件可以提供一种方便的解决方案。使用 BackgroundWorker 组件，您可以在不同于应用程序的主用户界面线程的另一线程上异]]></description><category></category></item><item><title><![CDATA[オラクル　カーソルの使用]]></title><link>https://blog.youkuaiyun.com/gpz_dalian/article/details/1842085</link><guid>https://blog.youkuaiyun.com/gpz_dalian/article/details/1842085</guid><author>gpz_dalian</author><pubDate>Wed, 24 Oct 2007 18:03:00 +0800</pubDate><description><![CDATA[过程如下：  1.在user_tab_columns找出所有含有bu_cd的表的名字。  select   table_name,column_name     from   user_tab_columns     where   column_name=  BU_CD    结果如下：  --------------------------------------  table_name ]]></description><category></category></item><item><title><![CDATA[如何设置远程登陆]]></title><link>https://blog.youkuaiyun.com/gpz_dalian/article/details/1833103</link><guid>https://blog.youkuaiyun.com/gpz_dalian/article/details/1833103</guid><author>gpz_dalian</author><pubDate>Fri, 19 Oct 2007 16:38:00 +0800</pubDate><description><![CDATA[如何设置远程登陆远程登陆现在用的地方是越来越多了,现在我就简单的说一下如何设置远程登陆的主端和客户端首先找一台PC做主机也就是被登陆的电脑1、建立一个受限制的来宾帐号，可以从控制面板的用户帐号里面创建，创建名如：laibin2、在桌面上右键点击＂我的电脑＂然后选择远程，分别把　远程协助＼远程桌面　选中！然后在远程桌面的选项上有　选择远程用户，点击，会弹出一个对话框然后在选择添加]]></description><category></category></item></channel></rss>