tag:blogger.com,1999:blog-495177919198719500.post4285000257541837946..comments2023-12-27T20:52:29.483-08:00Comments on Microsoft Sql Server Tutorials: T-SQL Insert Into Table ExamplesSuprotim Agarwalhttp://www.blogger.com/profile/08349831623922214390noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-495177919198719500.post-42402948908100345572016-07-23T12:51:27.480-07:002016-07-23T12:51:27.480-07:00You left out a few important things. The only date...You left out a few important things. The only date format allowed in ANSI/ISO standard SQL is based on ISO 8601 (yyyy-mm-dd). The old Sybase "select… Union all" syntax is strictly dialect in the really bad programming practice. Rows are nothing like records, so you get the terminology wrong. None of your examples showed passing and expression in an insertion statement. You did not show how to use the create sequence statement in an insertion. Most of your tables were not really tables at all! By definition, a table has to have a key.--CELKO--https://www.blogger.com/profile/11908190660799274693noreply@blogger.com