wizjamin/next-mssql-template

This is a Next.js project bootstrapped with create-next-app.

Includes MSSQL Connection utility functions

Getting Started

import MSSQLDB from './utils';

// usage
const result = await MSSQLDB.execute(/* sql statement */)

const result = await MSSQLDB.newRequest()
            .input('param1', 10)
            .input('param2', 'hello')
            .execute('select * from table where column1=@param1 and column2=@param2');

const result = await MSSQLDB.beginTransaction(async ( newRequest, abort) => {
       const result1 =  await newRequest()
       .input('param1', 10)
       .input('param2', 'hello')
       .execute('select * from table where column1=@param1 and column2=@param2');

       .....

       const result4 =  await newRequest()
       .input('param1', 10)
       .input('param2', 'hello')
       .execute('select * from table where column1=@param1 and column2=@param2');


       if(err) abort('Abort message')

       return {result1.resultset, result4.resultset}
    })

Create a .env.local file at root folder with these variables

DB_SERVER=
DB_NAME=
DB_USER=
DB_PASSWORD=

First, run the development server:

npm run dev
# or
yarn dev

Open http://localhost:3000 with your browser to see the result.

You can start editing the page by modifying pages/index.tsx. The page auto-updates as you edit the file.

API routes can be accessed on http://localhost:3000/api/hello. This endpoint can be edited in pages/api/hello.ts.

The pages/api directory is mapped to /api/*. Files in this directory are treated as API routes instead of React pages.

Learn More

To learn more about Next.js, take a look at the following resources:

• Next.js Documentation - learn about Next.js features and API.
• Learn Next.js - an interactive Next.js tutorial.

You can check out the Next.js GitHub repository - your feedback and contributions are welcome!

Deploy on Vercel

The easiest way to deploy your Next.js app is to use the Vercel Platform from the creators of Next.js.

Check out our Next.js deployment documentation for more details.