Query for mass edit of a column? - Support Queries

Welcome Guest

Search | Active Topics | Members | Log In | Register

myLittleTools Community Forum » myLittleAdmin For SQL Server (2005, 2008, 2012) » Support Queries » Query for mass edit of a column?

Query for mass edit of a column?

Options · View

Previous Topic · Next Topic

projectet

Posted: Thursday, January 31, 2008 7:49:19 PM

Rank: Newbie
Groups: Member

Joined: 1/31/2008
Posts: 1
Points: 0

I have a column that I want to mass edit to a default value the column has 197 rows so I'm looking for a query string to edit the column.

I was trying to use this but I'm getting errors:

USE [TABLE]
GO

INSERT INTO [dbo].[Borrower_Info] ([My_Column]) VALUES ('111-11-1111')

Am I on the right path?

elian

Posted: Thursday, January 31, 2008 8:34:36 PM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France

You need to use the UPDATE T-SQL statement

Code:

USE [TABLE]
GO

UPDATE [dbo].[Borrower_Info] SET [My_Column]='111-11-1111'

Users browsing this topic

Guest

myLittleTools Community Forum » myLittleAdmin For SQL Server (2005, 2008, 2012) » Support Queries » Query for mass edit of a column?

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.