MS SQL Server - Add record

Author

Add record

shapper

2006-11-29, 12:12 am

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

Hari Prasad

2006-11-29, 12:12 am

Hello,

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
>

Tracy McKibben

2006-11-29, 7:12 pm

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

Sponsored Links