SQL Server Database Programming Guidelines Part 4
5
Summary 1)Always use stored procedures instead of dynamic SQL when accessing data from external applications. 2)Connection string to the database should indicate the specific SQL Server instance port number. 3)Each table must indicate a primary key.
