- Jan 30 Tue 2018 10:50
-
【ASP.NET 4.5】Step 2 最上面的畫面(menutop.aspx)
- Jan 30 Tue 2018 10:45
-
【ASP.NET 4.5】Step 1 切割畫面先設定主畫面(index.aspx)
- Jan 30 Tue 2018 10:41
-
【ASP.NET 4.5】直接連到某網頁
//測試直接連到某網頁
protected void Button1_Click(object sender, EventArgs e)
{
// Do some other processing...
protected void Button1_Click(object sender, EventArgs e)
{
// Do some other processing...
- Jan 30 Tue 2018 10:34
-
【ASP.NET 4.5】 (?:) 是根據布林運算式的值傳回兩個值的其中一個
- Jan 30 Tue 2018 10:24
-
【SQL-STORE PROCEDURE】從字串中抽取出一段字串
USE [TempDB]
GO
/****** Object: UserDefinedFunction [dbo].[funSplitToString] Script Date: 2018/1/30 上午 10:27:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
GO
/****** Object: UserDefinedFunction [dbo].[funSplitToString] Script Date: 2018/1/30 上午 10:27:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
- Jan 30 Tue 2018 10:15
-
【SQL-STORE PROCEDURE】 STEP 1 找出使用的的mail body內容
USE [TempDB]
GO
/****** Object: StoredProcedure [dbo].[usp_GetMailContent] Script Date: 2018/1/30 上午 10:15:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
GO
/****** Object: StoredProcedure [dbo].[usp_GetMailContent] Script Date: 2018/1/30 上午 10:15:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
- Jan 30 Tue 2018 10:13
-
【SQL-STORE PROCEDURE】 STEP 2 將mail的body內容值[XXX]更換成正確的資料
USE [TempDB]
GO
/****** Object: StoredProcedure [dbo].[usp_GetMailBody] Script Date: 2018/1/30 上午 10:13:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
GO
/****** Object: StoredProcedure [dbo].[usp_GetMailBody] Script Date: 2018/1/30 上午 10:13:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
- Jan 30 Tue 2018 10:11
-
【SQL-STORE PROCEDURE】 判斷使用者的權限
USE [TempDB]
GO
/****** Object: StoredProcedure [dbo].[usp_GetAuthCRM] Script Date: 2018/1/30 上午 10:10:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
GO
/****** Object: StoredProcedure [dbo].[usp_GetAuthCRM] Script Date: 2018/1/30 上午 10:10:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
- Jan 30 Tue 2018 10:05
-
【SQL-STORE PROCEDURE】 SQL組mail內容，發送信件
USE [TempDB]
GO
/****** Object: StoredProcedure [dbo].[JOB_ExpireMail_Manual] Script Date: 2018/1/30 上午 10:01:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
GO
/****** Object: StoredProcedure [dbo].[JOB_ExpireMail_Manual] Script Date: 2018/1/30 上午 10:01:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
- Jan 30 Tue 2018 10:03
-
【SQL-STORE PROCEDURE】 透過SQL發送mail出現沒有權限
TempUser 結構描述 'dbo'，資料庫 'msdb'，物件 'sp_send_dbmail' 沒有 EXECUTE 權限
EXEC msdb.dbo.sp_addrolemember @rolename = 'DatabaseMailUserRole',@membername = 'TempUser ';
EXEC msdb.dbo.sp_addrolemember @rolename = 'DatabaseMailUserRole',@membername = 'TempUser ';
- Jan 30 Tue 2018 09:50
-
【SQL-STORE PROCEDURE】 可以回傳的資料表直接套到.net的gridview中
SQL Store Procedure 的寫法**************
USE [TempDB]
GO
/****** Object: StoredProcedure [dbo].[JOB_GVReport] Script Date: 2018/1/30 上午 09:49:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
USE [TempDB]
GO
/****** Object: StoredProcedure [dbo].[JOB_GVReport] Script Date: 2018/1/30 上午 09:49:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
- Jan 30 Tue 2018 09:43
-
【SQL-FUNCTION 資料表值函式】 FUNCTION 也可以回傳 TABLE 資料
FUNCTION 也可以回傳 TABLE 資料哦
USE [TempDB]
GO
/****** Object: UserDefinedFunction [dbo].[fn_EmpIDOrgan] Script Date: 2018/1/30 上午 09:44:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
USE [TempDB]
GO
/****** Object: UserDefinedFunction [dbo].[fn_EmpIDOrgan] Script Date: 2018/1/30 上午 09:44:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO