CREATE PROCEDURE dbo.spGetData @ID1 int, @ID2 int

AS

SET NOCOUNT ON

SELECT

T1.Param_ID

...

Wish you had included a few examples of retrieving the output values from ASP, VBS, js.

Hi Andy,

Your article gives substance and credibility to declarative statements around regularly published standards for database architecture. In many, if not most, cases I would have to agree “Always...

Hi Matt101,

IGNORE_DUP_KEY will check each attempted insert or update to verify that it its key(s) are unique. Violations of the constraint will be ignored, i.e. they will not be...

Shotgun approach:

Put indexes on columns of tables referenced by in the join clause.

Index columns which are selective and referenced in the where clause.

Use Graphical Show Plan: (Highlight your query &...

Have you tried running a profiler trace while using EM? You can also run the non-intrusive queries that are presented in the trace from QA and see if you...

in c:\boot.ini you can specify /NUMPROC=4

this will tell Windows to use the first 4 CPUs which are your "real CPUs"

ref: http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q170/7/56.asp&NoWebContent=1

hth,

joe

I just tried the following code in SS2k SP3. Timestamp behaves by incrementing each time a record is added or updated.

use tempdb

-- drop table dbo.t1

...

quote:

---

hmm,...

quote:

---

That is odd, I just did it, in SQL 2000 and allow nulls...

select @@TRANCOUNT will give you the current open transaction count. Try executing: COMMIT WORK

If you get error"

Server: Msg 3902, Level 16, State 1, Line 1

The COMMIT TRANSACTION request has...