You could have coded your SP as follows

CREATE PROCEDURE usp_check_login

  @username varchar(20),

  @password varchar(20) AS

  SET NOCOUNT ON

  SELECT user_id,

    user_active as login_active,

    user_loginattempts as login_attempts,

    user_type

  FROM tbl_user

  WHERE user_username = @usernameAND user_password = @password

  RETURN @@ROWCOUNT

GO

That...

TRUNCATE also fails if you use foreign key constraints, regardless of whether they are violated.

I fully agree that people should not be allowed to create datbases willy-nilly.

If developers go creating...

Firstly, I've come across SQL6.5 a couple of times recently because it was a huge undocumented, mission critical application written in C++ where the source code had been lost. ...

I tend to use short meaningful abbreviations, which is fine for databases with a few tables, but if you get an app with thousands of tables then your abbreviations cna...

quote:

---

Dude should have normalized his database...

---

Probably bought the list from a...

quote:

---

For the second best practice, i would like to add

Give proper alignments or Indent while writing the joins to make...

Perhaps you should write an article and submit it to the site.

Enlighten us all and earn US$25 in the process.

========================

He was not wholly unware of the potential lack of insignificance.

Yep, Douglas Adams.

The robot was Marvin the paranoid android but I'm thinking of a character in a later book in the series but can't think of his name.

There...

Sorry, forgot the language barrier.

They say that eskimos have thousands of names for snow, the British have millions that can be used as insults.

Bodily parts can be used as insults...

I used to work on an HP3000 mini-computer where the console had ultimate control followed by administrators followed by users.

We had a utility that let us impersonate differing levels of...

In my environment yes because

• I have a suitable carrot (the keys to the bosses drinks cabinet and the ability to sign expense forms).
• I have a suitable stick (I contribute...

As a DBA I expect all submitted code to be commented.

The comments should detail up front which tables are going to be used, what variables if any are declared and...

Do you mean the physical size of the database or the amount of data within the database?

If you use sp_helpfile within your database this will give you the files used...

I've had situations where I have had to use cursors.

I had a recordset containing the stages in securing a sale for customers.

The complete set of stages was called a chain.

Certain...

quote:

---

SQL Server is based on the relational model ....but not a very good implementation of it.

Of course, since SQL Server is not...