Summary of problems in project implementation

1. Create a unique index for the table in the Oracle database

2. Select 1 from kg_kehuxx where s_kehuid = 'p1027616'/select * From kg_kehuxx where s_kehuid = 'p1027616' SQL statements, which are more efficient, only determine whether a value that meets this condition exists

3. query the menus of the current user using Stored Procedures

4. Trigger:

Create or replace trigger "trg_biaokaxx_czsj" -- Update the operation time field of the table card information table to the latest

Before insert or update on kg_biaokaxx for each row begin

Select sysdate into: New. d_caozuosj from dual;

End;

5. Multiple rows are returned in a single row subquery.

6. Insert a result set into a table when inserting a table. Different Columns cannot exist.

7. Fixed 32-bit guid length, sys_guid ()

8. Class fields and attributes are initialized during class initialization. If an error occurs, class initialization will be affected.

9. New able must first give its column to its row.

10. datatable dt is a dataset. You can use LINQ to obtain the row data datarow [] ROW = DT. Select ();

11. The value cannot be assigned because the type of the bound field is different from the value assignment type:

Lueshuibiaokjysxx. editvalue = convert. tostring (rows. First () ["s_koujingbh"]);

12. Each table corresponds to a process that can execute simple SQL statements.

13. Concat (TRIM (user_key), '20140901') is followed by a character

14. Try to read or write the protected memory. This usually indicates that other memory is damaged. ---- This error is reported if the content on the tablet is not closed. Reasons for resource occupation

Summary of problems in project implementation