mulder's it blog

---------------------------------------------------------- /** CREATE FUNCTION fn_GetRobotCode2 () RETURNS varchar(20) AS BEGIN return 'aaa' END GO */ ---------------------------------------------------------- declare @aa varchar(20) set @aa = dbo.fn_GetRobotCode2() print @aa ----------------------------------------------------------

CREATE FUNCTION test_function_search (@찾을값 int) RETURNS varchar(10) AS BEGIN DECLARE @넘기는값 varchar(10) SET @넘기는값 = '지금은없음' SELECT @넘기는값 = body FROM test_table_for_function WHERE idx = @찾을값 RETURN (@넘기는값) END 위와 같이 FUNCTION을 하나 만듭니다. select idx, body, dbo.test_function_search(idx) As fromFunc from test_table_for_function

StoredProcedure는 각종 업무규정이나 계산이나, 조인문제들을 한꺼번에 작성해두고 필요할때 사용하기에 처리시간면이나,업무 오류를 최소화 하는 면에서나 편리하게 사용할 수 있습니다.하지만, storedprocedure는 다른 테이블들과 join하여 사용할 수 없습니다...이렇게 조금은 껄끄러운 문제를 해결할 수 있는 것이 Function이란 넘입니다.ALTER  Function 인사_근무일보   (@PARAM varchar(300))returns @근무일보  Table      (근무일자   datetime null,        사원번호   char(8) null,       성명       char(12) null,        공장       char(2) null,       공장명    ..

/* MySQL With MM JDBC */ jdbc driver and url driver = "org.gjt.mm.mysql.Driver"; url = "jdbc:mysql://localhost/dbname"; /*Sybase jconnect2.jar */ url = "jdbc:sybase:Tds:host:port"; driver = "com.sybase.jdbc2.SybDriver"; /*Oracle JDBC Thin Driver classes12.zip */ url = "jdbc:oracle:thin:@host:port:sid"; driver = "oracle.jdbc.driver.OracleDriver"; /*Oracle OCI Driver classes12.zip*/ url = "jdbc:or..

unit StudyMain; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, StdCtrls, ExtCtrls; type TForm1 = class(TForm) Panel1: TPanel; Memo1: TMemo; Memo2: TMemo; btnDateTest: TButton; Button2: TButton; Button3: TButton; Button4: TButton; procedure btnDateTestClick(Sender: TObject); procedure FormCreate(Sender: TObject); private { Private declarations }..

Creating Components Dynamically (at Run-Time)From Zarko Gajic, Your Guide to Delphi Programming. FREE Newsletter. Sign Up Now! Most often when programming in Delphi you don't need to dynamically create a component. If you drop a component on a form, Delphi handles the component creation automatically when the form is created. This article will cover the correct way to programmatically create com..

How to Dynamically Add Items (Holding Custom Properties) to a TPopUp MenuFrom Zarko Gajic, Your Guide to Delphi Programming. FREE Newsletter. Sign Up Now! When working with Menus or PopUp menus in Delphi applications, in most scenarios, you create the menu items at design-time. Each menu item is represented by a TMenuItem Delphi class. When a user selects (clicks) an item, the OnClick event is f..

Managing Run-Time Component ArraysFrom Zarko Gajic, Your Guide to Delphi Programming. FREE Newsletter. Sign Up Now! Accessing a group of run-time created components using an arrayA component (or control) array, as the name implies, is nothing more than an array of components. In the first part of this article (Acessing a group of design-time created components using an array), you have learned h..