I did many times in SQL 2012.

From now on I will do it in code.

Thank you.

I did not use code to delete it.

I open table in edit mode and then hit delete key to delete it.

Does it make difference?

I checked it many times the record...

Thank you.

Here is my codes.

I want to reproduce the same error message but I can't.

Also, I received error message time by time not always when user clicking the button firing the...

• This reply was modified 4 years, 4 months ago by  adonetok.

Yes, thank you so much.

(How to use BBCodes?  I still confused. It came out very ugly)

Finally, I created a function below.

Public Function GetCountScalar(ByVal strSQL As String) As Object

'usage: select count(MRN)...

• This reply was modified 4 years, 4 months ago by  adonetok.

Yes, this my fault. Should be "strSQL"

This error did not occur every time when user hit a button and this is very hard for me to reproduce the same error.

If I updated code below, is it...

Thank you for help.

As your advice, I updated codes without using "Using".

I have a question.

Does it need the line "mySQLCommand.CommandType = CommandType.Text" ?

From the link below, it did not use...

I tried Phil Parkin's way, it is working now.

Thank all of you.

I set up primary key on email column.

I want to void inserting any duplicate record in email column.

It is working great in another PC in which there is no another version of SSMS.

Question:

I want to install version 18.5 in my PC in which has old version 11.0...

SELECT STUFF('00000', 5, 1, '1');

00001

SELECT STUFF('00000', 4, 2, '12');

00012

SELECT STUFF('00000', 3, 3, '698');

00698

Thank you. It works for me.

Many thanks for all of you.
I did run this script and it works great.
I modified the code to run lower case as below it works great as well.

Another question.
If I only need to update tables under MyTemp database, how to modify your code?