'db'에 해당되는 글 1건

  1. 2011.05.31 [db] 간단한 프로시저 만들기
database2011.05.31 15:40
USE [WP7NotificationServer]
GO
/****** Object:  StoredProcedure [dbo].[sp_HugeFlowAppManifest_List_Select]    Script Date: 05/31/2011 14:35:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/*
Developer : test
Date : 2010/11/18
Desc : test
*/
 
CREATE proc [dbo].[sp_WP7NotificationServer_List_Select]
    @AppID int
AS
BEGIN
    SELECT [Idx]
      ,[Subscriber]
      ,[SubScribeDate]
    From [WP7NotificationServer] 
END
GO

 

이건 그냥 단순한 list select

 

이건 insert

USE [WP7NotificationServer]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
 
Create proc [dbo].[sp_WP7NotificationServer_Insert]
@AppID int
,@SubScriber VARCHAR(255)
,@SubScribeDate datetime
AS
INSERT INTO WP7NotificationSever_Subscribers(AppID , SubScriber, SubScribeDate) VALUES (@AppID , @Subscriber,@SubScribeDate)

 

 

머 이런식으로 하면 된다 쉽다.

Posted by 동동(이재동)

댓글을 달아 주세요