SQL storing data about columns

Posted by Chris on Stack Overflow See other posts from Stack Overflow or by Chris
Published on 2010-04-06T02:12:33Z Indexed on 2010/04/06 2:23 UTC
Read the original article Hit count: 313

Filed under:

sql-server-compact

I'm learning SQL Server Compact for a program I'm writing that requries a local database. I have multiple tables, each with different columns and I'd like to mark each column as being a certain type (not a data type, just an integer tag) to let the program know what to do with it. I'm clueless about SQL. How does one do this?

Related posts about sql-server-compact

Visual Studio 2008: Don't deploy SQL Server Compact 3.5 when debugging

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm using VS2008 to create a Compact Framework application for a Windows CE 5.0 device (Datalogic Kyman). I'm using SQL Server Compact 3.5 in my application. However, I'm debugging on a Kyman that still has Windows CE 4.2 installed (attached via USB using Mobile Device Center). My problem: VS2008… >>> More
Print DataBase Schema in Sql Server Compact Edition

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All I Want Print DataBase Schema in "Microsoft Sql Server Compact Edition". Maybe Exist Some Tools For it. How Can I do it? >>> More
SQLAuthority News – Downloads Available for Microsoft SQL Server Compact 3.5

as seen on SQL Authority - Search for 'SQL Authority'
There are few downloads released for Microsoft SQL Server Compact 3.5. Here is quick lists of the same. Microsoft SQL Server Compact 3.5 Service Pack 2 for Windows Desktop SQL Server Compact 3.5 SP2 is an embedded database that allows developers to build robust applications for Windows desktops and… >>> More
SQL SERVER – Download Microsoft SQL Server Compact 4.0 SP1

as seen on SQL Authority - Search for 'SQL Authority'
Microsoft SQL Server Compact 4.0 is a free, embedded database that software developers can use for building ASP.NET websites and Windows desktop applications. SQL Server Compact 4.0 is the default database for Microsoft WebMatrix. For enhanced development and debugging capabilities, including designer… >>> More
Connect to SQL Server Compact Edition in SSIS

as seen on Stack Overflow - Search for 'Stack Overflow'
Till now I've been exporting data INTO the SQL Server CE database, but now in SSIS I'm attempting to source data that was inserted in a previous step of the import. The SSIS fails during validation with the following error Error: Microsoft.SqlServer.Dts.Runtime.DtsCouldNotCreateManagedConnectionException:… >>> More

Developer IT

SQL storing data about columns - Developer IT

SQL storing data about columns

sql-server-compact

Related posts about sql-server-compact

Visual Studio 2008: Don't deploy SQL Server Compact 3.5 when debugging

Print DataBase Schema in Sql Server Compact Edition

SQLAuthority News – Downloads Available for Microsoft SQL Server Compact 3.5

SQL SERVER – Download Microsoft SQL Server Compact 4.0 SP1

Connect to SQL Server Compact Edition in SSIS

Categories cloud