Start - As easy as cut & paste!

To get started, run the following query in Query Analyzer (change table name) to create the input needed by N-Tier Builder. After running the query, paste the query results below and click on "Continue to Setup" to build your layers.

DECLARE @TableName varchar(50) SET @TableName = '<Enter Name Here>' select c.name + ',' As ColumnName, st.name + ',' As TypeName, IsNull(CAST(c.Prec as varchar(5)), '4000') + ',' As Length, c.ColStat from syscolumns c, sysobjects o, systypes st where c.id = o.id AND c.xtype = st.xtype AND o.Name = @TableName AND NOT st.Name = 'sysname' order by o.name, c.colorder

Query Analyzer Output: Here's a sample of what the data returned by Query Analyzer should look like. Copy the results to your clipboard by right-clicking a cell of the query results and clicking "Select All". Right-click again and select "Copy".

Paste Query Results Below:

After copying your query results to the clipboard, click the button below. On the next page, you can paste the query output as input for N-Tier Builder.