Title / Description
Code SET IDENTITY_INSERT QuizItems ON insert into QuizItems( ID, Views, Url, Created, Header, Body, FK_CreatedBy, FK_Parent) select ThreadID as ID, 0 as Views dbo.removeUnsafeCharactersFromUrl(Title) + '.quiz' as Url, GETDATE() as Created, Title as Header, Body, dbo.mapUsersFromLmsToLion(PostingUserID) as FK_CreatedBy, NULL as FK_Parent from Postings where ParentPostID is null SET IDENTITY_INSERT QuizItems OFF
Author
Highlight as C C++ CSS Clojure Delphi ERb Groovy (beta) HAML HTML JSON Java JavaScript PHP Plain text Python Ruby SQL XML YAML diff code