add text to colum in sql database

Welcome Forums General PowerShell Q&A add text to colum in sql database

This topic contains 2 replies, has 2 voices, and was last updated by

 
Participant
1 year, 7 months ago.

  • Author
    Posts
  • #77448

    Participant
    Points: 0
    Rank: Member

    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

    Keymaster
    Points: 1,811
    Helping HandTeam Member
    Rank: Community Hero

    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

    Participant
    Points: 0
    Rank: Member

    Thanks Don, will look into the documentation.

The topic ‘add text to colum in sql database’ is closed to new replies.

denizli escort samsun escort muğla escort ataşehir escort kuşadası escort