fix mssql createPerson example. (#1048)

kysely-org · Jun 21, 2024 · e71bbc4 · e71bbc4
1 parent 6dd7ce2
commit e71bbc4
Showing 1 changed file with 4 additions and 3 deletions.
diff --git a/site/docs/getting-started/Querying.tsx b/site/docs/getting-started/Querying.tsx
@@ -44,11 44,12 @@ export async function deletePerson(id: number) {
 export async function createPerson(person: NewPerson) {
  const compiledQuery = db.insertInto('person').values(person).compile()
 
- compiledQuery.sql = '; select scope_identity() as id'
-
  const {
  rows: [{ id }],
- } = await db.executeQuery<Pick<Person, 'id'>>(compiledQuery)
  } = await db.executeQuery<Pick<Person, 'id'>>({
  ...compiledQuery,
  sql: \`\${compiledQuery.sql}; select scope_identity() as id\`
  })
 
  return await findPersonById(id)
 }