Hi,

Different problems may be presenting themselves, to help you try to do the following steps:

1. Clean Database Mail Log

2. Execute a Database Mail - Send Test E-mail.

3. Copy and...

Really, did not see that consideration.

Thxs!

Hello, I would do as follows there are many others but please verify whether the expected results.

Create TAble #Old_Table

(Id int, National_Code varchar(20))

Create TAble #New_Table

(Id int, National_Code varchar(20))

Insert into #Old_Table

Values (1,'0000000000')

,(2,...

Hi, very true!

Cursors aren’t all bad. In fact, they can make some database problems a lot easier to solve. But take a step back and really examine the problem. There...

Of course you can use the data type varbinary (max), but you should consider this information will make your database grow dramatically what hurt you in some processes such as...