The information is not sufficient to provide you the solution...

Can you please some more detailed information so that we can help you?

please provide some more information like what output you required so that we can help you..........

Try in this manner-

create procedure test_sp

AS

BEGIN

declare @count int

Select @count = COUNT(*) from test

RETURN @count

END

Declare @storevalue int

EXECute @storevalue = test_sp

SELECT @storevalue

yes, your syntax is incorrect...

it should be like this:

INSERT INTO table_name

SELECT coumn_names from table_name

Follow the post of laurie, it will works

Excellent article Somm 🙂

Easy one for the day 🙂

you haven't specified the condition thats why you are getting values for all the year....

Put a where clause too in your query....

Hugo Kornelis (7/31/2013)

---

The short and simple answer: because Microsoft didn't build DBCC CHECKDB to include CHECKIDENT.

The longer and more...

SELECT name from tempdb.sys.objects

L' Eomot Inversé (7/30/2013)

---

PHYData DBA (7/30/2013)

---

Thierry,

That explanation is not correct for TSQL. ...

Nice question,........

Thanks Steve 🙂

Thanks Gail for the useful link 🙂

Koen Verbeeck (7/30/2013)

---

You can also create multiple unique indexes on the same table, but you can have only one primary key.

A unique index can also be filtered, while a PK...

Gila,

can you please tell me about this Eager pool? I am not aware of this thing

Good one Paul 🙂