You can convert hashbytes to varchar through XQuery as well.

Here is the solution. http://raresql.com/2013/04/02/sql-server-how-to-convert-hashbytes-to-varchar/

Hi,

If your SQL Server is in full recovery model than you can recover it without backup.

SQL server keeps the entry (Page # & file #) of the truncated records and...

Hi,

SQL server keeps log for every transation.So you can recover your modified data from the log as well without backup.Here is the artcile, that can explain ,...

Hi Jeff,

Thank you for your feedback.

BLOB data type (Varbinary (Max)) recovery is already defined in this article.

But 'Image' data type is not available yet.

Imran

This articale can help you to recover the deleted data from sql server 2005 and above.

http://raresql.com/2011/10/22/how-to-recover-deleted-data-from-sql-sever/

In sql server 2005 , you can recover the deleted records as mentioned in this article.

http://raresql.com/2011/10/22/how-to-recover-deleted-data-from-sql-sever/

try this

Select *

,(Select top 1 [Percentage] from [tblB] B Where B.EffectiveDate<=A.Date

Order By .EffectiveDate Desc) as [ColB]

from [tblA] A

Can you plz put your stored procedure source here.

I think you did not define the output parameter there like this

CREATE PROCEDURE dbo.GetCountByLastName (

@LastName NVARCHAR(50),

...

try this

EXEC [Assignment].[dbo].[spStudent_Insert_ByStudentIDs] @ProcessID=483 ,@SchoolYear=2011 ,@StudentIDs=456985 ,@CreatedBy='testuser',@Rowcount output

Select @Rowcount

Hi,

Here is the articale for your reference

http://msdn.microsoft.com/en-us/library/ms188001.aspx

Here is the sample.

Declare @X as nvarchar(100)

Declare @Item int

Set @X='Select top 1 @Item=[Item] from...

Hi,

Here we go.

http://blog.lavablast.com/post/2008/10/14/SQL-Server-Restore-a-bak-to-a-database-in-command-line.aspx

But you need to schedule a task in the server to execute that batch file (defined in this article) whenever u need to restore the...

Hi,

I made a sample here.

Drop table [SW_ReturnMessages]

GO

Create table [SW_ReturnMessages]

(WaitingMessagesID int identity(1,1),

[Status] nvarchar(50) ,

LastUpdatedAt datetime,

ReturnMessageID nvarchar(50))

GO

DECLARE @Message XML

set @Message = '<?xml version="1.0" encoding="UTF-8"?>...

Make WaitingMessagesID column as an identity column and

change the query like.

INSERT INTO [SW_ReturnMessages] ([Status], LastUpdatedAt, ReturnMessageID)

SELECT

@status,

@CreatedAt,

[Message].rows.value('@id[1]', 'VARCHAR(50)') AS ReturnMessageID

FROM @Message.nodes('/MessagesWaiting/ReturnMessage') [Message](rows)