You can't say this as a stupid qurstion, may be there are many other users who faced this type of problem and didn't find a solution for this.....

Main thing is...

OTF (7/18/2013)

---

kapil_kk (7/18/2013)

---

Instead of specifying it in parameter list you can assign GETDATE() to local variable inside stored procedure body:

CREATE PROCEDURE sp_MyProcedure

@Record_ID Varchar(12),

@OtherKey_ID Int,

@Comments VARCHAR(MAX) = NULL

AS

BEGIN

DECLARE @DateParameter...

You can use below queries to find the index present on a specific table:

sp_helpindex 'table_name'

OR

select i.name, i.type_desc

from sys.indexes I

join sys.tables o ON i.object_id = o.object_id

WHERE o.name = 'table_name'

It will be better if you used Transaction in your stored procedure itself.......

kapil_kk (7/18/2013)

---

Instead of specifying it in parameter list you can assign GETDATE() to local variable inside stored procedure body:

CREATE PROCEDURE sp_MyProcedure

@Record_ID Varchar(12),

@OtherKey_ID Int,

@Comments VARCHAR(MAX) = NULL

AS

BEGIN

DECLARE @DateParameter DATE...

Instead of specifying it in parameter list you can assign GETDATE() to local variable inside stored procedure body:

CREATE PROCEDURE sp_MyProcedure

@Record_ID Varchar(12),

@OtherKey_ID Int,

@Comments VARCHAR(MAX) = NULL

AS

BEGIN

DECLARE @DateParameter DATE

SET...

ChrisM@Work (7/18/2013)

---

Your syntax is incorrect:

DELETE TOP (2) t

FROM tbl1 t

delete...

If you specify alias with TOP in delete it will always gives you an error:

e.g.

DELETE TOP (2)

FROM tbl1 t

Can you please some sample data that you are trying to insert?

Voide (7/17/2013)

---

kapil_kk (7/17/2013)

---

Voide (7/16/2013)

---

As Gail said, why nolocks?...

Thanks Tom for the explanation.......

can you please provide some sample data with resultant output.......

Carlo Romagnano (7/17/2013)

---

kapil_kk (7/16/2013)

---

Hi,

as per the explanation- The stmt "return (select 5)" gives error because in a batch RETURN with integer_expression is not admitted (note: PARENTHESIS cast the SELECT to...

DevilsChest (7/17/2013)

---

kapil_kk (7/16/2013)

---

But we use integer expression with RETURN in a stored procedure and it works...

I am confused that will integer expression works only in stored procedure and not in...

Gail,

Can you please tell me that when...