For INSERT, it's pretty straightforward.

INSERT INTO dbo.Table1 (ID, Pics)

VALUES (1,{Image BLOB})

You get into real problems when trying to use UPDATE, though. Generally speaking, you can't UPDATE blob fields (such...

If you look at the DTS GUI interface in EM, it has options to connect to different servers. Just create two different connections. Generally speaking, you want to...

I would just like to tweak lakusha's otherwise excellent answer.

Always use the ORDER BY clause when you need the results ordered. If you don't need them in a particular...

I, on the other hand, use very few. I tend to not trust mucking about with them. The solutions I come up with may not be the most...

A bit OT, but I love that company name.

Also look into the Resync Command property (on the Data tab of the Form properties). I don't know how it works for DLookup. But, it's critical for using...

Do you have the rights to create a new proc? Can you talk to the DBA who does have the rights, or is this a commercial app? Because,...

I've asked this of multiple sources. The basic answer I've gotten is "It depends." It depends on the version of SQL Server you're running (apparently, they tweaked how...

IIRC, datareader doesn't deny write access to the tables. It simply doesn't grant it. Which is a very different thing, especially in terms of accumulation. Once you...

Did you add the CDate function to the EXEC statement?

In your SP, are the variables declared as smalldatetime type?

I'm not entirely sure what you mean by that. You should just be using unbound controls. Then, make a command button that opens the report. Validate the...

SELECT ISNULL(R.RegisterDate,C.CancelDate) AS TranDate, R.Registrations, C.Cancellations

FROM

(SELECT COUNT(*) AS Registrations, CONVERT(VARCHAR, registerdate, 101) AS RegisterDate

FROM users WHERE registerdate > @startdate AND registerdate @startdate AND canceldate...

First, you need to remember that SQL Server does NOT use # to designate dates. It uses the singe quote.

Second, for SQL Server standards, you actually should put the...

If you want better performance (to avoid the table scan), reverse the comparison and use DATEADD:

SELECT *

FROM sometable

WHERE JoinDate BETWEEN DATEADD(d,-3,GETDATE()) AND DATEADD(d,-2,GETDATE())

I think it might be the lazier approach to just list out the columns.

If you don't have a bunch of indices or relationships based on the IDENTITY column, you can...