Kiểm tra trường dữ liệu thêm mới gần nhất trong SQL Server

Theo: nguyenhaidang.name.vn | 06/12/2021 - 09:55

 Cách kiểm tra các cột mới thêm trong toàn bộ database trong SQL Server:

SELECT

    OBJECT_NAME(sc.[object_id]) as [table]

    ,sc.[name] as [column]

    ,so.modify_date

    ,so.create_date

  FROM [sys].[columns] sc

  JOIN [sys].[objects] so

  ON sc.[object_id] = so.[object_id]

  ORDER BY so.modify_date DESC, so.create_date ASC

Back Head Print
Tin khác

Search GridView with Paging on TextBox KeyPress using jQuery in ASP.Net    (28/07/2010)

Bootstrap AutoComplete TextBox example using jQuery TypeAhead plugin in ASP.Net with C# and VB.Net    (28/07/2010)

Disable Button and Submit button after one click using JavaScript and jQuery    (29/07/2010)

Split and convert Comma Separated (Delimited) String to Table in SQL Server    (01/09/2010)

Select Column values as Comma Separated (Delimited) string in SQL Server using COALESCE    (01/09/2010)