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 - 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 - Jun 26 2006 | sql server, dba, database, report, not jesus
adam | Shared With: Everyone - Mar 30 2006 | Database, tips, sql server, not jesus, blogsA blog with SQL Server tips. This is especially useful since SQL Server 2005 is emerging onto the field of play... with major differences from SQL Server 2000.
adam | Shared With: Everyone - Mar 16 2006 | SQL Server, Access, microsoft, Database
Not just with SQL Server. These functions work in Access too.
Unfortunately, using functions like there often times don't work over an ODBC connection (depending on your driver). It is oft tempting to use the database to do the date calculations... but you'll have better flexibility if you do your calculations in your application logic.
Regardless... these functions are definitely useful.
Related Content from Around Faves
sql server
-
1 FaverViewed: 10 TimesQuoted: SQL Server XML View Mapper 1.0 Brief Description Microsoft® SQL Server View Mapper enables you to produce an XML View schema file that relates an ...
- adam - Jun 26 20061 FaverViewed: 76 Times
- mikkelsd - Oct 04 20069 FaversViewed: 114 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)
