In fact, there are certain conditions where your Primary Key most certainly should not be considered for your clustered index. If, for example, you are designing a backend to...

A decent overview with examples and links is in Earland Sommarskog's article here;

http://www.sommarskog.se/dynamic_sql.html#SQL_injection

There's a lot more out there covering in more detail, but IMO this is a good starting point...

It's a bit of a grim hack - but you could set up a VBA script task to check whether it's the first of the month, and raise a DTS...

Afraid you can't use TRY - CATCH in a T-SQL UDF.

Hi,

if you're looking for the equivalent of a sequence in Oracle, you would set up your ID column as an Identity column, for examply as an integer...

jvElecenter (6/27/2008)

---

Hi thx for reply

The only difference between your statement and ours is in the dates where you equal to.

We need the info until that date.

it's a stored procedure which...

jvElecenter (6/25/2008)

---

Hi there

We have a stored procedure like this :

SELECT @sql = 'SELECT * FROM dbo.[OPS Sepia$Sales Line] WHERE ([Document Type] = 1) AND...

Only if you're using the *= =* type syntax. Which...

Have you considered using Sharepoint for this?

Set format on cell(s) column(s) or row(s) to ##0.00##

Hi,

for the logging of individual rows containing errors, in your data transformation task use an OLE DB Destination Error Output connection (red arrow) from the destination for...

In general, don't.

Cursors are, in SQLServer (and relational database in general) terms, a hack - and a bad one. What you should be aiming to do (and...