add text to colum in sql database

This topic contains 2 replies, has 2 voices, and was last updated by  Jaapie bakker 4 months ago.

  • Author
    Posts
  • #77448

    Jaapie bakker
    Participant

    Hi Guys,

    I would like to put some information in a collum of a sql databases. The following information i got:

    Sqlserver 2012SQL1
    Databasename DB1
    Table DBO.User

    In the DBO.user is a field where i want to add some numbers. I would like to find an emailadress and then add text to a different collum lets say the the name of that is numbers.

    Could you help where to start please?

    King Regards

  • #77460

    Don Jones
    Keymaster

    I can show you the code for executing a SQL query – it's also in our free book on making trend and historical reports. The actual .NET Framework code is pretty simple, and if you have the SQL Server module it's even easier – just run Invoke-SQL.

    You'll need to know how to write a T-SQL query, but that's not really a PowerShell question at that point. The aforementioned book does have some query language examples. There are also tons of online references for SQL queries.

  • #77571

    Jaapie bakker
    Participant

    Thanks Don, will look into the documentation.

You must be logged in to reply to this topic.