Start here:

Deadlocking

Greets

Flo

Yep, we got your point 😉

As I showed you, use a SELECT to return the data back to the caller of your TESTPROC.

Use a...

Hi Rob

SQL Server analyzes your statement before it becomes executed. Your first IF-block uses INSERT INTO ... Both other blocks use SELECT INTO. Since your temp table was already created...

Hi Avi

To get the elements out of your XML you can use this:

DECLARE @xml XML

SELECT @xml = N'<Employee>

<EMPID>1</EMPID>

<EMPNAME>AAA</EMPNAME>

<EMPSALARY>2000.00</EMPSALARY>

<DEPTID>1</DEPTID>

</Employee>'

SELECT

T.C.value('(EMPID)[1]', 'int')

...

No cursors needed ;-). Where do your 100 rows and the related data come from?

If you have any surrogate key within your data (e.g. a client side id, a row...

Never heard/saw...

Hi

Does "becomes unavailable" mean you get a timeout from web server?

To trace query/sp durations use Events:

* Stored Procedures/RPC:Completed

* SQL:BatchCompleted

Greets

Flo

Hi Yogi

First, if your problem becomes fixed when you restart IIS it does not appear to be a SQL Server problem ;-).

Could you explain more detailed the meaning of "not...

You cannot store multiple values in one variable. Use a SELECT within your procedure and a temp table (or table variable) to receive the values.

CREATE PROCEDURE selectMany

AS

...

Hi

SQL Server takes the memory it needs up to the configured max value. You should restrict the max value to about 3GB to keep some memory for OS.

SQL Server does...

Hi Steve

You can use a CROSS JOIN to get all required combinations. After that use a LEFT JOIN to find the missing rows:

DECLARE @r TABLE (Id INT, Code...

Hi PSB

If your XML is not too large, you can load the file into a XML variable and use XPath to get the data (into your tables).

<?xml version="1.0" encoding="UTF-8"?>

<Root>

...

Use CASE instead of OR

UPDATE dbo.tblUsers SET

GroupId =

CASE

...

Hi

SQL Server first parses your query and creates a complete execution plan. After that it becomes executed. If your statement references not existing columns it fails previous work.

Greets

Flo

As I told you, get rid of dynamic statements with values. And by the way, you should move away from ODBC if possible (if you work with Java or .NET,...