> For the complete documentation index, see [llms.txt](https://kythuat.dtechvn.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://kythuat.dtechvn.com/convert-du-lieu/quy-trinh.md).

# QUY TRÌNH

### 1. Kiểm tra nghiệp vụ có sử dụng

```sql
-- code check nghiepvu có phát sinh dữ liệu
select T1.nghiepvu,t1.ngayMax, T2.ma,T2.vietnam
from (select nghiepvu,max(ngay) as ngayMax from dulieuketoan group by nghiepvu)T1 left join 
(select * from nghiepvu where nghiepvu<>0)T2 on t1.nghiepvu=t2.nghiepvu
order by t2.ma
```

### 2. Kiểm tra danh mục mới

### 3. Kiểm tra tableManage có dòng mới

### 4. Kiểm tra danh mục sử dụng

### 5. Kiểm tra cột mới trên dulieuketoan

```sql
/* bản cũ thì chekc bằng mắt
- bản sql thì đọ 2 bảng bằng lệnh sql
- câu lệnh dưới tìm ra cột lệch 2 bảng và cấu trúc lệch
*/
declare @tableName nvarchar(20)= 'dulieuketoan'
select t1.*, t2.*
from
(
SELECT COLUMN_NAME, DATA_TYPE, IS_NULLABLE, CHARACTER_MAXIMUM_LENGTH,TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME=@tableName
)T1
full outer join 
(
SELECT COLUMN_NAME, DATA_TYPE, IS_NULLABLE, CHARACTER_MAXIMUM_LENGTH,TABLE_NAME
FROM [sql2022].[24h_kiemtra].INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME=@tableName
)T2 on t1.COLUMN_NAME = t2.column_name
where t1.COLUMN_NAME is null or t2.column_name is null 
or t1.CHARACTER_MAXIMUM_LENGTH<> t2.CHARACTER_MAXIMUM_LENGTH
or t1.DATA_TYPE <> t2.DATA_TYPE
```


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://kythuat.dtechvn.com/convert-du-lieu/quy-trinh.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.