Hi to all, Programmers. :icon_smile:
i require a general syntax for checking if the SQL table is empty or Contains records.
if the table is empty i'm suppose to add initial counter (like 0001) and if table already contain records then i'm suppose to increment the counter by ONE. The data type of the field: counter , is nvarchar(50).
thanking in advance.