Databases

< <

Get flash to fully experience Pearltrees

http://msdn.microsoft.com/en-us/library/ms190243(v=sql.105).aspx

Using Extended Properties on Database Objects

Each extended property has a user-defined name and value. The value of an extended property is a sql_variant value that can contain up to 7,500 bytes of data.

DBA

New Installation (Reporting Services)

parsing - How to strip all non-alphabetic characters from string in SQL Server

Introduction

Migrate MySQL to Microsoft SQL Server

6 Reference Manual :: 13.7.1.4 GRANT Syntax

ConnectionStrings.com - Forgot that connection string? Get it here!

By Bill Graziano on 6 August 2007 | 6 Comments | Tags: Identity , INSERT Identity columns are commonly used as primary keys in database tables.

How to Insert Values into an Identity Column in SQL Server

Best approach to remove time part of datetime in SQL Server

ADO Connection Strings

Overview Generally, one of the first steps when you are trying to work with databases is open it.

InterSystems Caché ® is an advanced object database that provides in-memory speed with persistence, and the ability to handle huge volumes of transactional data. Plus, it can run SQL faster than relational databases.

Caché - World's fastest high performance object database

asp.net - Entity Framework v2 doesn't support sql 2000

AppendText Method

Also available on tomjewett.com: color tutorial, demo application, and video ; for Web accessibility resources and consulting, please see The Enabled Web . This third edition of dbDesign is a general update, both to meet legal requirements for U.S. “Section 508” accessibility and to bring the code into compliance with the latest World Wide Web Consortium standards.

Database Design - Introduction

http://www.tomjewett.com/dbdesign/dbdesign.php

By Sean Baird on 12 September 2000 | 21 Comments | Tags: Identity Kim writes: "with an identity column you can SELECT @@identity after inserting a row. How do you get the value of a uniqueidentifier column after an insert?

Uniqueidentifier vs. IDENTITY

The Visual Studio 2010 IDE does not support connecting to SQL Server 2000, including not allowing connections from the ADO.NET Entity Framework designer. However, the ADO.NET Entity Framework 4 runtime continues to offer support for running with SQL Server 2000 databases. A number of people have asked what to do with existing ADO.NET Entity Framework models built against SQL Server 2000 when moving to Visual Studio 2010. Following are a few development options and items of note: - The ADO .NET Entity Framework 4 runtime fully supports SQL Server 2000. - Apps you previously built on top of SQL Server 2000 will continue to function as-is when you move those apps to the ADO.NET Entity Framework 4 runtime.

http://social.msdn.microsoft.com/Forums/en/adodotnetentityframework/thread/781d7256-8226-4e56-a1aa-16ca33e1cbe7

Using Entity Framework 4 with SQL Server 2000 Databases

sql - Is there common street addresses database design for all addresses of the world

internationalization - What is the "best" way to store international addresses in a database

http://blog.sqlauthority.com/2006/11/01/sql-server-query-to-display-foreign-key-relationships-and-name-of-the-constraint-for-each-table-in-database/

Query to Display Foreign Key Relationships and Name of the Constraint for Each Table in Database « Journey to SQLAuthority

November 1, 2006 by pinaldave UPDATE : SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database This is very long query. Optionally, we can limit the query to return results for one or more than one table.