Add record

Hello,
I am just starting with SQL Server 2005 and I would like to know if it
is possible to add a record to a table as I do in Microsoft Access, by
opening the table, or can I only do it executing a Stored Procedure?
Thanks,
MiguelHello,
You can do this in SQL Server Management Studio. Just connect to SQL
Server-- expand databases-- tables --right click above table and open.
There you can enter data and save..
Thanks
Hari
"shapper" <mdmoura@.gmail.com> wrote in message
news:1164768583.433805.262850@.j44g2000cwa.googlegroups.com...
> Hello,
> I am just starting with SQL Server 2005 and I would like to know if it
> is possible to add a record to a table as I do in Microsoft Access, by
> opening the table, or can I only do it executing a Stored Procedure?
> Thanks,an do this
> Miguel
>|||shapper wrote:
> Hello,
> I am just starting with SQL Server 2005 and I would like to know if it
> is possible to add a record to a table as I do in Microsoft Access, by
> opening the table, or can I only do it executing a Stored Procedure?
> Thanks,
> Miguel
>
You *can* manipulate a table using the GUI, but it's not recommended.
You can add rows to a table using a simple INSERT statement typed into a
query window. Using the GUI can lead to unexpected locking problems.
Tracy McKibben
MCDBA
http://www.realsqlguy.com