Query Analyzer includes time-saving shortcuts to two online Help files: Transact-SQL Help and Object Help. To access Transact-SQL Help in SQL Server 2000, 7.0, and 6.5, type a T-SQL statement such as...
One of SQL Server's weak points when critics compare it with DB2 and Oracle is its lack of programmability. Longtime SQL Server users might find this criticism strange. From the developer standpoint, SQL Server seems to be the most programmable...
Some people prefix their stored procedure names with sp_. Some people say you should never use the sp_ prefix in procedure names. What's the real scoop?
Related: Recompilation and Coding Owner Prefixes on a Stored Procedure
Never mi...