How to add new column using the network id or name and current date

[iamRandy]

Hi,

I created a new SQL server table that I populate data daily.  I want to add 2 new additional columns an insert a dynamic current date/time and the username or id (usually its the server id but is there a dynamic field for this) used for this insert.  

Thanks.

[atcodedog05]

Hi @iamRandy 

I guess you can use the below functions in the insert statement to update the data.

Current DateTime: https://www.w3schools.com/sql/func_sqlserver_sysdatetime.asp 

Current user: https://learn.microsoft.com/en-us/sql/t-sql/functions/current-user-transact-sql?view=sql-server-ver1...

Specific is not clear about your question.

Hope this helps : )

[iamRandy · Accepted solution]

I figured it out.. it can be done from the source script.