how to insert values table using stored procedure

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

how to insert values table using stored procedure

Author

Topic

hemachitra.ashokkumar
Starting Member

1 Post

Posted - 2010-08-09 : 06:12:18

I want to know whether values can be inserted into tables using stored procedure. If yes, pl give me the syntax

k.hemachitra

kashyap_sql
Posting Yak Master

174 Posts

Posted - 2010-08-09 : 06:23:07

example:-


create PROCEDURE [dbo].[Table_name]
	@Column_name varchar(50),
	@Column_name float(53),
	@Date datetime
AS
SET NOCOUNT ON

INSERT INTO  [Share]
(
			[Column_name],
			[Share],
			[Date]
)
VALUES
(
			@Column_name,
			@Share,
			@Date
)

With Regards
Kashyap M

kashyap_sql
Posting Yak Master

174 Posts

Posted - 2010-08-09 : 06:24:35

or else check the link
http://bytes.com/topic/visual-basic-net/answers/606236-using-stored-procedures-insert-values-into-databse

With Regards
Kashyap M

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources