Transact-SQL GudangMovies21 Rebahinxxi LK21

Transact-SQL (disingkat T-SQL) adalah jenis bahasa untuk basis data SQL yang dikeluarkan oleh perusahaan Microsoft dan Sybase. Pada sistem berbasis Microsoft, T-SQL ini diimplementasikan pada perangkat lunak Microsoft SQL Server, sedangkan pada sistem berbasis Sybase, bahasa Transact-SQL ini dipakai pada perangkat lunaknya yang bernama Adaptive Server Enterprise dan Sybase SQL Server.
Seperti bahasa dalam kebanyakan basis data SQL, T-SQL ini mempunyai beberapa fitur:

bahasa kendali alir (control flow)
variabel lokal
pemrosesan matematis, string, tanggal (date), dll
perbaikan perintah DELETE dan UPDATE.
Kata kunci (keyword) yang dipakai meliputi perintah BEGIN dan END, BREAK, CONTINUE, GOTO, IF dan ELSE, RETURN, WAITFOR, serta WHILE. Beberapa contoh dari penggunaan bahasa T-SQL ini adalah:

Untuk perintah lebih dari satu baris, maka blok dengan awal BEGIN dan akhiran END harus dipakai seperti contoh ini:

Tipe suatu variable biasanya dinyatakan dengan perintah DECLARE:

Suatu variable @ArticleCount dapat diberi nilai awal dengan jumlah baris COUNT yang terdapat pada table Articles, sebagai berikut:

Lihat pula

SQL

Kata Kunci Pencarian:

transact sql transact sql adalah transact sql cursor transact sql set transact sql like transact sql join transact sql date format transact sql set variable transact sql if tutorial transact sql

transact sql

Daftar Isi

Transact-SQL in Visual Studio Code
Polyglot Notebooks in VS Code - Visual Studio Code
Transact-SQL with Visual Studio Code
Using GCC with MinGW - Visual Studio Code
Introduction to Git in VS Code - Visual Studio Code
Terminal Advanced - Visual Studio Code
Copilot Edits - Visual Studio Code
AI Toolkit for Visual Studio Code
Fine-tune models - Visual Studio Code
Set up Visual Studio Code with Copilot

Transact-SQL in Visual Studio Code

Turn Visual Studio Code into a powerful editor for Transact-SQL (T-SQL) development, with the mssql extension available in the VS Code Marketplace. The mssql extension is optimized to work with SQL Server running on-premises, in any cloud, …

Polyglot Notebooks in VS Code - Visual Studio Code

Notebooks are interactive files that allow the mixing of executable code, visualizations, equations, and narrative text. Notebooks are composed of code cells that make it easy to quickly iterate on code.

Transact-SQL with Visual Studio Code

Turn Visual Studio Code into a powerful editor for Transact-SQL (T-SQL) development, with the mssql extension available in the VS Code Marketplace. The mssql extension is optimized to …

Using GCC with MinGW - Visual Studio Code

In this tutorial, you configure Visual Studio Code to use the GCC C++ compiler (g++) and GDB debugger from mingw-w64 to create programs that run on Windows. After configuring VS Code, you will compile, run, and debug a Hello World program. This tutorial does not teach you about GCC, GDB, minGW-w64, or the C++ language.

Introduction to Git in VS Code - Visual Studio Code

To use Git and GitHub in VS Code, first make sure you have Git installed on your computer. If Git is missing, the Source Control view shows instructions on how to install it. Make sure to restart VS Code afterwards.

Terminal Advanced - Visual Studio Code

Visual Studio Code's integrated terminal has many advanced features and settings, such as Unicode and emoji support, custom keyboard shortcuts, and automatic replies. This topic explains these advanced features in detail. If you are new to VS Code or the integrated terminal, you may want to review the Terminal Basics topic first.

Copilot Edits - Visual Studio Code

To process a request, Copilot loops over the following steps and iterates multiple times as needed: Determines the relevant context and files to edit autonomously. Offers both code changes and terminal commands to complete the task. For example, Copilot might compile code, install packages, run tests, and more.

AI Toolkit for Visual Studio Code

Develop and test AI apps with AI Toolkit for Visual Studio Code. Inference test, batch run, evaluate, fine-tune and deploy LLMs and SLMs.

Fine-tune models - Visual Studio Code

Fine-tune AI model is a common practice that allows you to use your custom dataset to run fine-tune jobs on a pre-trained model in a computing environment with GPUs. AI Toolkit currently supports fine-tuning SLMs on local machine with GPU …

Set up Visual Studio Code with Copilot

Welcome to AI-powered development with Visual Studio Code! Follow the steps in this guide to get started in minutes. Was this documentation helpful?