New 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.


0

You can run SELECT @@SERVERNAME which will give you the current servername you are connected to. Would this suit your requirements?


-3

You need to convert date into nvarchar first through your query: Convert(varchar,[date_attribute],106)



Top 50 recent answers are included