You don't need the FROM, all you need is this:

DELETE [002 Shipments Table]

In which case the deletions are written to the transaction log. Depending on the permissions, you might also...

That Tally table thing is pretty slick. In my case it created 11000 rows. I will definitely study how it works.

Anyway, here is a possible final solution that inserts from...

Florian Reischl (6/7/2009)

---

Nothing to apologize :-). I just intended to ensure that...

Sorry, did not read the entire question, missed the part where the dates come from another table.

If the dates are sequential you could use this

-- these would be your input parameters

DECLARE

@empno int,

@start_date datetime,

@end_date datetime,

@project nvarchar(50)

-- set them to some values for testing

SELECT

@empno = 1,

@start_date = '10/01/2009',

@end_date...

You wouldn't normally do that, because in a relational database you would write your query to look up the job name from that other table using the ID. What you...

Here's one more way to do that in an MDB file:

Create a pass-thru query, and in the button click event on your form, you re-write the SQL string with the...

Thanks for the search tip, here it is:

http://www.sqlservercentral.com/links/158289/42671

QOD was posted May 8, 2008 - lots of replies 🙂

and the name of msdb is actually msdbdata.mdf just to...

This same QOD was posted a long time ago. . .

the sqlist (5/9/2009)

---

jeremygiaco (4/14/2009)

---

I have to respectfully disagree with the posters that are saying that using the GUI is the best approach. If by best you mean easiest, then...

rayzor (5/4/2009)

---

I need to have my access form keep the previously entered data in a field for the next record. The field is a Combo-Box with a Value List as...

You could just use this

EXEC sp_MSforeachtable @command1="EXEC sp_spaceused '?' "

Back again to the original question, you can avoid using GO by using this:

EXEC sp_executesql N'ALTER TABLE Temp ADD num int identity(1,1)'

One situation where you would not want to use...

Your first code example was almost complete, except for opening the recordset to retrieve the value.

Your second code example will only work the first time, then it will fail with...