Tag：stored procedure
-
Time：2020-2-12
An example of this article describes the MSSQL paging stored procedure. To share with you for your reference, as follows: USE [DB_Common] GO /******Object: Storedprocedure [dbo]. [com_pagination] script date: 03 / 09 / 2012 23:46:20******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO /************************************************************ * *SQL paging stored procedure (supports multi table paging storage) * […]
-
Time：2020-2-11
The specific code of Oracle stored procedure, package and method is as follows: /** *@author：zhengwei *@date:2017-04-28 *@Desc: summary of stored procedure usage */ CREATE OR REPLACE PROCEDURE MYPROCEDURE(P_ID IN VARCHAR, P ﹣ status out varchar) — P ﹣ ID is the input parameter, P ﹣ status is the output parameter AS —Variable declaration T_STATUS VARCHAR2(20); […]
-
Time：2020-2-10
Since spring cloud officially announced that spring cloud Netflix has entered the maintenance state, we have started to produce a series of articles in the spring cloud Alibaba migration guide, which provides developers with more technical options and reduces the technical difficulty in the migration process. Part 1: one line of code from hystrix to […]
-
Time：2020-1-22
Abstract:As an old friend of DTCC and the world’s leading cloud computing manufacturer, Alibaba cloud database team is invited to participate in this technology event. It will not only send a team of distinguished guests, but also present 8 wonderful topics for the vast number of database industry professionals and users. The following editor combed […]
-
Time：2020-1-14
Platform status The following is the current architecture of the platform: Data from multiple data sources are written to Kafka. The computing engines are storm, spark and Flink. The result data from the computing engine is then landed on various storage. At present, there are more than 100 storm tasks and about 50 spark tasks. […]
-
Time：2020-1-4
Alibaba cloud database has been named by top organizations again! Recently, TPC, the world’s most famous data management system evaluation standardization organization, announced the latest ranking of database domain analysis performance benchmark. Alibaba cloud’s large-scale analytical database, analyticdb, topped the listThe world’s firstCloud database products that have passed TPC strict audit certification. In short, analyticdb […]
-
Time：2020-1-3
It’s a great honor to hear Steve Flanders’s speech on opentelemetry at kubecon Shanghai station in 2019. Before that, opentracing and opencensus, two online Red projects in OPS field, finally came together. The standardization of observability and unity has set sail.The purpose of this article is to attract more and more students and exchange the […]
-
Time：2019-12-21
background With the rapid growth of time series data, time series database not only needs to solve the stability and performance problems of the system, but also needs to realize the link between data collection and analysis to make time series data really produce value. In the field of time series data acquisition, there is […]
-
Time：2019-12-21
background Timestream model is a unique model designed for time series scenarios, which can enable users to quickly complete the development of business code and realize relevant business requirements. However, if the business system not only wants to achieve the basic business functions, but also to achieve the best performance, and take into account the […]
-
Time：2019-12-18
“Click to get help documents for cloud access” Dear alicloud users: Hello! To facilitate your trial access to alicloud MQ with open-source rocketmq client, we have applied for a special coupon, which can directly deduct the amount. Please fill in your company account information, click on the above figure to learn more. I. Introduction purpose […]
-
Time：2019-12-16
Abstract:Data storage plays an important role in performance optimization. H5 has a lot of related storage. This paper introduces the characteristics of various storage and related optimization practices in detail. Preface Data storage plays an important role in performance optimization. Storage type, access policy, storage hit rate, etc., often affect the actual performance of the […]
-
Time：2019-12-10
Mongodb oplog (similar to MySQL binlog) records all the modification operations of the database, in addition to the primary and secondary synchronization; oplog can play many tricks, such as Full backup + incremental backup of all oplog can realize the function of mongodb recovery to any point in time Through oplog, in addition to synchronization […]
