SQL Server Forums - Insert statement and where clause

Home | Weblogs | Forums | SQL Server Links

SQL Server Forums

Register Now and get your question answered!

All Forums

Insert statement and where clause

New Topic

Author

Topic

dnf999
Constraint Violating Yak Guru

251 Posts

Posted - 06/13/2007 : 04:51:01

Hi can I use a where clause with an insert statement using variables?

i.e.

insert into Test Table
(@DB, @DB_Name, @Date, @Quantity)
where ID  = @ID

result:
ID, DB, DB_Name, Date, Quantity
ID1, 1, test1 , 12-June, 1000

Thanks

harsh_athalye
Flowing Fount of Yak Knowledge

India
5509 Posts

Posted - 06/13/2007 : 04:53:57

Insert into Test
Select @DB, @DB_Name, @Date, @Quantity 
Where exists(select * from SomeTable where ID  = @ID)

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

Topic

New Topic

Jump To:

SQL Server Forums

This page was generated in 0.05 seconds.