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

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.

Workflow

Accepted answers

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

All comments

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-ver16

Specific is not clear about your question.

Hope this helps : )

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

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703