Once you write the question press the send icon.
Me: Please create the code to find a stored procedure that contains the word log in its name. Select your authentication and connect to the Adventureworks2019 database and press Connect.įirst, in the menu select View>Other Windows>Visual ChatGPT Studio. In addition, in the SQL Server Object Explorer, press the Add SQL Server icon.įinally, write the SQL Server Name. Thirdly, write a Project name and press Create.Īlso, in the menu select View>SQL Server Object Explorer. Secondly, in the Create a new project window, select SQL Server Database Project. Open a SQL Server Database Projectįirst, in Visual Studio, select the Create a new project option. Also, you need to be registered in ChatGPT and have a login and password.įinally, press OK to save the secret key. You can get the API key from the OpenAI website. Finally, Turbo chat behavior is used to control the level of engagement and creativity.The top P is to create more diverse text.A higher temperature, a more creative text. Temperature is used to control the creative text.
Stop Sequences includes a list of tokens that the model should avoid. In addition, the presence penalty penalizes generating text too close to the input. Also, we have the OpenAI API key to connect to the REST API. Currently, I only see TextDancinci003 as the only language available right now. Thirdly, the Model Language is used to select the language used. Secondly, we have Max Tokens to control the maximum number of words accepted. First, we have Frequency, which is used to avoid repeating phrases. Here you have an explanation of the parameters: Look for the Visual ChatGPT Studio and copy and paste the OpenAI API key. Secondly, in Visual Studio go to Tools>Options. Write ChatGPT and press the install button to install the Visual ChatGPT Studio. In this example, we will use Visual ChatGPT Studio. Getting started with ChatGPT in Visual Studio – Install Visual ChatGPT Studioįirst, in Visual Studio go to Extensions>Manage Extensions. Secondly, we need to have Adventureworks installed. First, we need to have SQL Server installed. We will install and use an extension in a SQL Server Database Project. In this article, we will learn how to work with ChatGPT in Visual Studio.
0 kommentar(er)
