PaulB-TheOneAndOnly (12/10/2011)

---

luis martin ortiz barrutia (12/10/2011)

---

Hello

Is a good practice to put a state field in a table?, so if it is 1 means active, 0 is deleted, so i can...

Please evaluate your requirements on following:

Features Supported by the Editions of SQL Server 2008 R2

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

Selecting a High Availability Solution

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

Try the same code with VARCHAR datatype. It should work.

DECLARE @CRD VARCHAR(19) -- Replaced CHAR(19) with VARCHAR(19)

SET @CRD = '1234567890123456'

SELECT CONVERT(BINARY(20), HashBytes('SHA1', @CRD))

SELECT CONVERT(BINARY(20), HashBytes('SHA1', '1234567890123456'))

Will it not be double task, effort & time? :w00t:

Free eBook available on SSC...

Troubleshooting SQL Server: A Guide for the Accidental DBA

http://www.sqlservercentral.com/articles/books/76296/

You can save images in MSSQL. I can’t guide you on How-To-Do in Java but most of the Front End Development Languages (including Java) support Image (blob) data. Obviously syntaxes...

SQL Kiwi (12/10/2011)

---

Yes I had a email today saying it would be republished on that date (no doubt you saw my...

SELECT [ ALL | DISTINCT ]

[ TOP ( expression ) [ PERCENT ] [ WITH TIES ] ]

<select_list>

<select_list> ::=

{

...

Paul's Time Travel :Whistling:

(see the attachment)

And what are the algorithm / logic for it?

Q1: In Table2 car list ‘Car1 Diesel’ matches to ‘Car1 don 12/9/2011’ in Table1 Car User Log but you want the output...

May I know the reason for appending the database backups in single file?

Please check following...

http://support.microsoft.com/kb/977695/en-us

http://support.microsoft.com/kb/977695/en-us

Also... Urgent - No mapping between account names and security IDs was done error !

http://social.msdn.microsoft.com/forums/en-US/sqlsecurity/thread/97f73ec5-5016-4366-af0f-d240ccdf0a0d/

The encryption feature is available in SQL Server. But it’s a BLOB & you want to encrypt a portion of it, I would recommend you to do this encryption on...

Brandie Tarvin (12/9/2011)

---

Dev (12/9/2011)

---

Brandie Tarvin (12/9/2011)

---

DUH!Code

---

Code written by an experienced developer that defies all pre-existing code standards and the dev's knowledge skills by believing it can do something...

I am not sure if it’s applicable in US but in India, if you opt for Contractor it’s very difficult to switch back to Full Time Employment. That’s the reason...