If you use the DBCC CHECKIDENT command: DBCC CHECKIDENT (“YourTableNameHere”, RESEED, 1); But use with CAUTION! – this will just reset the IDENTITY to 1 – so your next inserts will get values 1, then 2, and then 3 –> and you’ll have a clash with your pre-existing value of 3 here! IDENTITY just dishes … Read more
Since SQL Server Version 2012 you can use: SELECT format(getdate(),’yyyyMMddHHmmssffff’)
If you’re talking about last time the table was updated in terms of its structured has changed (new column added, column changed etc.) – use this query: SELECT name, [modify_date] FROM sys.tables If you’re talking about DML operations (insert, update, delete), then you either need to persist what that DMV gives you on a regular … Read more
That task should be done by the next layer up in your software stack. SQL is a data repository, not a presentation system You can do it with CONVERT(VARCHAR(10), fmdate(), 101) But you shouldn’t