|
Solution Search:
|
SQL Server Resource Center
SQL Server database design disasters: What not to do
Personally, I would not trust these databases to store a simple catalog of the 2,600 songs on my iPod.
The databases support their respective businesses, but... More... Sep 15, 2008
How to create a SQL Server linked server to DB2
ll enter the bulk of the necessary connection information. The Initial Catalog option is very important; it's what the RDB name is on the DB2. Typically, it's the name of...
More...
Aug 20, 2008
How to use SQL Server 2008 hierarchyid data type
this would be the CEO of the company. If you were building an inventory catalog, you might find this more useful than in an HR system, as the top of each category tree...
More...
Aug 20, 2008
Translating information requests into SQL SELECT statements
a list of subjects, the category each belongs to, and the code we use in our catalog. But I'd like to see the name first, followed by the category and then the code." Subjects...
More...
Jul 30, 2008
SQL Related Articles
Permissions, visibility, UDTs and user-defined aggregates
defined aggregates
A user-defined type must be defined in the SQL Server catalog to be visible to SQL Server stored procedures and other T-SQL procedural code, just as an assembly is. Once a UDT is defined in the SQL... More... Jun 28, 2005
What can .NET code do from within SQL Server: Safety levels
Framework class libraries is enforced at runtime rather than "catalog time;" attempting to load a library not on the list will not throw an exception at runtime.
Let's go through an example of how safety... More... Jun 28, 2005
|