How to Dynamix AX Thai

Tuesday, January 23, 2018

วิธีดูว่า table ไหน field ไหนเป็น NULL

DECLARE @tb NVARCHAR(255) = N'dbo.[table]';

DECLARE @sql NVARCHAR(MAX) = N'SELECT * FROM ' + @tb
    + ' WHERE 1 = 0';

SELECT @sql += N' OR ' + QUOTENAME(name) + ' IS NULL'
    FROM sys.columns
    WHERE [object_id] = OBJECT_ID(@tb);

EXEC sp_executesql @sql;
Posted by Holiday Undonthani at 12:56 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Comments (Atom)

Blog Archive

  • ►  2022 (1)
    • ►  December (1)
  • ►  2019 (2)
    • ►  July (1)
    • ►  April (1)
  • ▼  2018 (1)
    • ▼  January (1)
      • วิธีดูว่า table ไหน field ไหนเป็น NULL
  • ►  2017 (4)
    • ►  November (2)
    • ►  September (1)
    • ►  August (1)
  • ►  2016 (1)
    • ►  September (1)
  • ►  2015 (1)
    • ►  March (1)

About Me

Holiday Undonthani
View my complete profile
Picture Window theme. Powered by Blogger.