Returns the reverse order of an integer.

No DECLARE @ INPUTBIGINT, @ RESULTBIGINTSET @ INPUT1234SET @ RESULT0while @ INPUT0BEGINSET @ RESULT * 10 + @ INPUT % 10SET @ INPUT @ INPUT10ENDSELECT @ RESULT No DECLARE @ input bigint, @ result bigintset @ INPUT = 1234 SET @ RESULT = 0 while @

SQL Server calculates the number and occupied space of table records

No details no USEADVENTUREWORKSGO -- examples. Parameters. name, TotalRowsprt. rows, [SpaceUsed (KB)] SUM (alloc. used_pages) * 8FROMsys. objectsobjJOINsys. indexesidxonobj. object_id No details no use adventureworksgo -- Count All Rows and Size of

MySQL exports BLOB fields to files

No details: blobmysqlselectcertificate?dumpfiletmpcertificate. binFROMidentityWHEREid42; No details Blob MySQL SELECT certificate into dumpfile '/tmp/certificate. bin' FROM identity WHERE id = 42; Blob MySQL --> $velocityCount--> -->

Use dynamic SQL in oracle: form

Because oracleFORM is different from DB, a specific APIexec_ SQL series is required. It is often used to output the report's forformdynamicsql dynamic explain (2000); explain; v_CursorEXEC_ SQL .CURSTYPE; v_IgnorePLS_INTEGER; begin -- A specific API

Stored Procedure for SQL to convert a table into a table creation statement

No details about struct (@ TableNamevarchar (256) asbeginsetnocountondeclare @ sqlstrvarchar (4000) declare @ sqlstr1varchar (4000) declare @ sqlstr2varchar (4000) select @ sqls No details about SQL Server SET QUOTED_IDENTIFIER ONGOSET

Similar to split, a string is separated into character arrays.

What we can see from an open-source software is also taking the liberty to get the delimiter (listinvarchar2, arroutcol_head_arr, lenarroutinteger) delimiter (50) indexbybinary_integer; rorcol_head_arr; -- number of characters What we can see from

Use an SQL statement to retrieve records from the MTH to nth

Use an SQL statement to retrieve records from the m to n records -- retrieve records from the Table from the m to the n records: (NotIn Version) SELECTTOPn-m + 1 * FROMTableWHERE (idNOTIN (SELECTTOPm-1idFROMTable) -- extracts the m to n records

Solving shipping and transportation problems

No details about the seats: droptablev1; createtablev1 (namevarchar (10), -- name, addresvarchar (10) -- where to go,); insertintov1values (my1, Shanghai); callback (my2, Beijing ); insertintov1values (my3, Shanghai); insertintov1values ( No details:

MySQL exports a table to an XML file

No details-No mysql-udb_user-pdb_name-xml-eSELECT * FROMtable_nametable_name.xml No details no mysql-u db_user-p db_name -- xml-e "SELECT * FROM table_name" table_name.xml --> $velocityCount--> --> mysql -u db_user -p db_name

How to add existing fields to an accesskey

1. Open the data table for which you want to add fields, and click the data table on the menu bar. 2. In the data table option, click "add existing field. 3. The field list panel appears on the right of the interface ., We can see that there is a

How to hide an Access window

Callback (ByValhwndAsLong, ByValnCmdShowAsLong) AsLongFunctionfSetAccessWi Global Const SW_HIDE = 0 Global Const SW_SHOWNORMAL = 1 Global Const SW_SHOWMINIMIZED = 2 Global Const functions = 3 Declare Function ShowWindow Lib user32 Global Const SW_

Decryption stored procedures, views, triggers

Decryption stored procedure, view, trigger Stored Procedure view trigger this stored procedure can be decrypted relatively short stored procedure, backup the stored procedure before running, otherwise it may not be restored. DecryptStoredProcedures,

MySQL Stored Procedure Exception Handling

No detailed content Exception Handling MySQLmysqlmysqldelimiter $ mysqlmysqlCREATEPROCEDUREmyProc No detailed content Exception Handling MySQL mysqlmysql delimiter $ mysqlmysql create procedure myProc-(p_first_name VARCHAR (30),-p_last_name VARCHAR (

MySQL requests a lock object in the Stored Procedure

No details: MySQLmysqlmysqldelimiter $ mysqlmysqlCREATEPROCEDUREmyProc () No details about MySQL mysqlmysql delimiter $ mysqlmysql create procedure myProc ()-BEGIN-DECLARE lock_result INT;-IF get_lock ('SP _ critical_section_lock ', 60) THEN-/* This

Use LOOP and FETCH to read MySQL cursors

No detailed content cursor MySQLmysqlmysqldelimiter $ mysqlCREATEPROCEDUREmyProc () No detailed content cursor MySQL mysqlmysql delimiter $ mysql create procedure myProc ()-BEGIN-DECLARE l_sale_id INT;-DECLARE l_last_sale int default 0; --DECLARE

LinuxOracle deletes archive logs

Today encountered Oracle reported such an error: ORA-00257, view the next, the original Oracle archive log is full, Solution Two One: Increase archive log small two: delete none Today encountered Oracle reported such an error: ORA-00257, view the

Sample MySQL transaction ROLLBACK code

No detailed content transaction ROLLBACKMySQLmysqlmysqldelimiter $ mysqlmysqlCREATEPROCEDUREmyProc ( No details transaction ROLLBACK MySQL mysqlmysql delimiter $ mysqlmysql create procedure myProc (-in_from INTEGER,-in_to INTEGER,-in_amount DECIMAL (

Stored Procedure for batch update of date values of table fields

To test a report today, the data of the current day is required. But I tested the report yesterday and the data is still in the database. So I want to steal the data and manually change the time field to the date of the current day, after less than

MySQL stored procedures use REPEAT to open the cursor to read data

No detailed content cursor MySQLmysqlmysqlmysqldelimiter $ mysqlCREATEPROCEDUREmyProc (in_customer_idINT) No detailed content cursor MySQL mysqlmysqlmysql delimiter $ mysql create procedure myProc (in_customer_id INT)-BEGIN--DECLARE l_first_name

GoldenGateforOracle Data Consistency Initialization Scheme

GoldenGateforOracle Data Consistency Initialization Scheme GoldenGate for Oracle Data Consistency Initialization Scheme The O & M process is a process that constantly generates new problems and requires continuous research and development. Just

Total Pages: 12780 1 .... 9547 9548 9549 9550 9551 .... 12780 Go to: GO

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.