I found that if I create a stored procedure as follows

CREATE PROC usp_SetName @sName VARCHAR(50)

AS

SET NOCOUNT ON

SET QUOTED_IDENTIFIER OFF

INSERT Tbl_Name (Name)

VALUES (@sName)

GO

Then executing the stored proc

exec usp_SetName "O'Reilly" gets...

Years ago I was told that Microsoft set up a Publisher on one side of the Atlantic and the Distributor/Subscriber at the other.

When they got their first phone bill it...

quote:

---

In our environment, we capture and process millions of transactions per day. We increased throughput on these intense inserts (15%) by...

I would regard having a compound primary key as terrible practice.

By all means have a unique key on it, but the primary key?

I have a situation where we have an...

You were the last person consulted on a database issue and got so pissed off you resigned.

6 months later you see your old job advertised at twice the salary.

Scott Adams...

The problem is that management believes in 0% downtime. Fortunately, they have 50% downtime so its not too hard to sync downtime where they won't notice.

The worst case...

The only down side I have found with derived tables is that they are memory intensive.

This becomes an issue if you have an application that runs complicated queries for a...

The great thing about scripting is that you are creating documentation for your database.

I also find that a well laid out script is useful teaching aid for educating wannabe developers.

When...

I work within a programming company and everyone who has seen .NET absolutely raves about it.

The one comment that has been made is that VB.NET will make a lot of...

I've found that if you want to pass a string to use as the IN list in a WHERE clause it doesn't work!

What I did was put a small header...

The idea of certification becoming the IT worlds equivalent of a doctor's license to practice medicine is an interesting one.

I think certification should be levels of certifications i.e. MCDBA grade...

Whole heartedly agree.

I also remove all rights assigned to the PUBLIC group/role so that a user has to be explicitly associated with a specific role. You don't come in...

I haven't checked either because I'm working in a pure development environment and at this stage is is all pretty hypothetical.

I will do some testing at a later stage to...

Thanks Guys

But what I was after was something like

SELECT @@ROWID,*

FROM Tbl_

WHERE @@ROWID BETWEEN 10 AND 20

I've seen your select TOP queries where a sub-query also has a TOP clause...

Yes definitely

When I did the SQL 6.5 courses I was lucky enough to be taught by a trainer with commercial dba and they stressed the importance of this.

One thing I...