Hot answers tagged

3

Why doesn't SQL Server honor the default that I placed on my table type? Actually, SQL Server does indeed hono[u]r that default as the following test (using the UDTT provided in the Question) shows: DECLARE @Test dbo.MyObject_TableType; INSERT INTO @Test (Name) VALUES ('ObjectOne'); SELECT * FROM @Test; Returns: Name Index ObjectOne ...


1

Use SQL Server Import and Export Wizard. It is the best for one time transfers.



Only top voted, non community-wiki answers of a minimum length are eligible