Skip to content
Tako Lee edited this page Feb 16, 2014 · 24 revisions
  • Fit into one line if possible

    INSERT INTO dbo.Points (PointValue) VALUES (CONVERT(Point, '3,4'));
  • Column list/value list fit into one line if possible

    INSERT INTO MyLinkServer.AdventureWorks2008R2.HumanResources.Department (Name, GroupName)
    VALUES (N'Public Relations', N'Executive General and Administration');
Clone this wiki locally