adam | Shared With: Everyone - Nov 28 2006 | sql server, database, microsoft, oracle
adam | Shared With: Everyone - Nov 19 2006 | IT, sql server, databaseQuoted: Some nifty SQL statements I made last week: Firstly, listing all databases on a server. -- Get Databases SELECT name FROM master.dbo.sysdatabases ORDER BY name Secondly, a way to get all the user-created stored procedures from a database. -- Get Stored
adam | Shared With: Everyone - Nov 13 2006 | database, trailers, movies
adam | Shared With: Everyone - Oct 05 2006 | sql server, database, microsoft, @@identity, programming
good explanation of @@IDENTITY vs SCOPE_IDENTITY()... I never knew the difference. Also, there are 9 other things you should watch out for. (lots of common sense)
Quoted: Both @@IDENTITY and SCOPE_IDENTITY() return the last identity value (primary key) that was entered by your active session, but in different scenarios they can each ...
adam | Shared With: Everyone - Oct 02 2006 | sql server, database, microsoft, programmingLooks nice for Data Dictionary searches...
Quoted: The following lengthy SQL script will create a system function in SQL Server that returns a data dictionary for any database on the server
adam | Shared With: Everyone - Sep 26 2006 | sql, blogs, sql server, database, microsoft, not jesus
adam | Shared With: Everyone - Sep 26 2006 | news, taxes, database, budget, not jesus
adam | Shared With: Everyone - Aug 09 2006 | database, work, oracle, 9i, dbms_job, not jesus
adam | Shared With: Everyone - Jun 26 2006 | sql server, dba, database, report, not jesus
adam | Shared With: Everyone - Apr 24 2006 | Database, microsoft, howto, cluster, not jesus
Related Content from Around Faves
database
-
A frequently updated database of internet memes with background information about each.
1 FaverViewed: 3 Times - mike - Nov 10 20091 FaverViewed: 4 Times
- guido - Feb 22 20094 FaversViewed: 8 Times



![John Papa [MVP C#] : Find a Column, Find a Table in SQL Server](http://i.faves.com/01/49/e968/43ca5d21/e5725e827a92ab559c_5.jpg)


