The retrieval code is generated automatically by the corresponding retrieval code function.

the corresponding retrieval code is automatically generated by the corresponding retrieval code script .

----------------------------------------------------------insert some fields of the GY_YLSF table into the GY_FYBM table. Insert  intoGY_FYBMSelectFYXH,PYDM,FYMC,1  fromGY_YLSF through the corresponding search code (pinyin code, Wubi code) script in the database run, generate functions, and then call the function to generate the corresponding retrieval code. The statements are as follows:--The Retrieval Code (phonetic code) is generated (the length of the <8 bit, also = 8-bit, or >8-bit, >8-bit only takes the previous 8-bit retrieval code) into the PYDM field. UpdateGy_ylsf--Update GY_YLSF TableSetPydm=left(Dbo.fgetpy (FYMC),8)where LEN(Dbo.fgetpy (FYMC))>8     --Set--------------------------------------------------------

1.WillGy_ylsf Some fields of table are inserted into gy_fybm table

-- insert some fields of the GY_YLSF table into the GY_FYBM table.  Insert into gy_fybmSelect fyxh,pydm,fymc,1 from GY_YLSF

2, through the corresponding search code (pinyin code, Wubi code) script in the database run, generate functions, and then call the function to generate the corresponding retrieval code. The statements are as follows:

-- The Retrieval Code (phonetic code) is generated (the length of the <8 bit, also = 8-bit, or >8-bit, >8-bit only takes the previous 8-bit retrieval code) into the PYDM field.   Update GY_YLSF            -- updates the GY_YLSF table set=left(dbo.fgetpy (FYMC),  8whereLEN(dbo.fgetpy (FYMC))>8     -- settings 

3. Insert some fields of the GY_YLSF table into the GY_FYBM table.

-- ----Get some fields in a table and insert them into another table Insert  into YK_YPBM Select YPXH,PYDM,YPMC,1 from YK_TYPK  

The retrieval code is generated automatically by the corresponding retrieval code function.