정훈's 프로그래밍

일반 버전 페이징 쿼리 MS-SQL-2012 부터 지원] 페이징 쿼리 declare @PageCounting int = 2 , @TopN int = 10 select * from dbo.Word as w with(nolock) order by w.RegisterDate offset (@PageCounting - 1) * @TopN row fetch next @TopN row only

declare @picking_no bigint = '' , @pl_cd varchar(10) = '' , @date_type int = 1 , @start_date datetime = '2020-5-31' , @end_date datetime = '2020-5-31' , @search_type int = 0 , @search_value varchar(25) = '' , @picking_status char(1) = 'A' begin declare @sql nvarchar(max) , @paramlist nvarchar(4000) set @sql = N' set nocount on declare @datetime_min_value datetime = ''1753-01-01'' if @end_date > ..

coalesceselect coalesce ( ( select count(*) from @BasicData group by bd.RegisterDate ) , 0) as AmountOfDailyWord

DataTable dt = new DataTable(); dt.Columns.Add("EMPLOYEE_ID", typeof(int)); dt.Columns.Add("FIRST_NAME", typeof(string)); dt.Columns.Add("LAST_NAME", typeof(string)); dt.Columns.Add("HIRE_DATE", typeof(DateTime)); dt.Columns.Add("SALARY", typeof(int)); dt.Rows.Add(100, "Steven", "King", "2003-06-17", 24000); dt.Rows.Add(101, "Neena", "Kochhar", "2005-09-21", 17000); dt.Rows.Add(102, "Lex", "De H..

declare @t_picking_list_inserted_data table( picking_no int , cust_no int ) -- insert to [t_picking_list] insert into tir.dbo.t_picking_list( op_id , picking_yn , picking_work_no , cust_no , reg_id , reg_dt , chg_id , chg_dt , page_no , packing_no , pl_cd ) output inserted.picking_no , inserted.cust_no into @t_picking_list_inserted_data select @op_id , @picking_yn , @picking_work_no , sub_table...

begin tran insert into SDFSDF ( cj_invoice_id , contract_no , original_invoice_number , renewal_invoice_number ) values ( @cj_invoice_id , @contract_no , @original_invoice_number , @renewal_invoice_number ) if @@ERROR 0 and @@ROWCOUNT 1 begin if @@TRANCOUNT > 0 rollback tran return end insert into CJF ( contract_no , renewal_invoice_number , state_code ) values ( @contract_no , @renewal_invoice_..

https://localhost:44303/Authentication/Login?isRegistered=True $.GetUrlParam = function(name) { var results = new RegExp('[\?&]' + name + '=([^&#]*)').exec(window.location.href); return results[1] || 0; } $(function () { alert($.GetUrlParam("isRegistered")); });

CREATE FUNCTION [dbo].[fn_gmkt_split_array](@String NVARCHAR(4000), @Delimiter CHAR(1)) RETURNS @Results TABLE (Items NVARCHAR(4000)) AS BEGIN DECLARE @index INT DECLARE @slice NVARCHAR(4000) SELECT @index = 1 IF @String IS NULL RETURN WHILE @index != 0 BEGIN SELECT @index = CHARINDEX(@Delimiter,@String) IF @index !=0 SELECT @slice = left(@String,@index - 1) ELSE SELECT @slice = @String INSERT I..

보호되어 있는 글입니다.