For full information about primary key

please view the below link

http://www.dotnetbites.com/Primary-key-Sql-Server

Please check if this link helps

http://www.dotnetbites.com/find-user-modified-table-stored-procedure

create proc sp_temp

@count INT = NULL OUTPUT

as

begin

declare @Result varchar(5)

select @count = COUNT(*) from #temptable

end

Try this out

You can use an output parameter to get the result

create proc sp_temp

@count INT OUTPUT = NULL

as

begin

declare @Result varchar(5)

select @count = COUNT(*) from #temptable

end

Now your @count variable will have...

I have restored the database successfully without the log file

Actually, this is not the one i expected. i have to write a XQuery to get the XML content inside the Author element/Node

I tried this Query;

SELECT

Author = T.item.query('Author')

FROM @XML.nodes('root/Books/Book') AS...

Can you try this

CREATE TABLE #Temp(Word VARCHAR(100))

INSERT INTO #Temp VALUES('TR#ABC#10/12/2011')

INSERT INTO #Temp VALUES('TR#XYZ#12/12/2011')

INSERT INTO #Temp VALUES('TR#ABC#10/12/2011')

SELECT REPLACE(MyWords, LEFT(MyWords, CHARINDEX('#', MyWords)), '') AS Word FROM

(

SELECT REPLACE(Word, RIGHT(Word, CHARINDEX('#', REVERSE(Word))),...

Please check this Query,

CREATE TABLE #ClaCases (ClaCaseID INT,ReceiverID int, IncidentDate Date )

GO

INSERT INTO #ClaCases VALUES (1234,80451,'2008-11-21')

INSERT INTO #ClaCases VALUES (2442,84244,'2010-03-23')

INSERT INTO #ClaCases VALUES (6774,45676,'2008-06-14')

GO

CREATE TABLE #AccPayments (PaymentStatus INT,ReceiverID int, DueDate...