Navicat เป็นอีกโปรแกรมหนึ่งที่น่าใช้สะดวกในการจัดการฐานข้อมูล สามารถเชื่อมต่อกับฐานข้อมูลได้หลายตัว ไม่ว่าจะเป็น MySQL, MariaDB, SQL Server, SQLite, Oracle. Navicat for SQL Server 12.1.9 (x86/x64) 78.9 Mb Navicat for SQL Server gives you a fully graphical approach to database management and development. Quickly and easily create, edit, and delete all database objects, or execute SQL queries and scripts. Connect to any local/remote SQL Server, and compatible with cloud databases like Amazon RDS.
A user-defined function, which is a Transact-SQL or common language runtime (CLR) routine that accepts parameters, performs an action, such as a complex calculation, and returns the result of that action as a value. The return value can either be a scalar (single) value or a table. Click to open an object list for Function.
Stored procedures are similar to procedures in other programming languages in that they can:
Note: SQL Azure does not support the Comment tab.
Function Wizard
Click the New Function from the object list toolbar. The Function Wizard will pop up and it allows you to create a procedure/function easily. You are allowed not to show the Function Wizard when create new procedure/function.
Description | |
Encryption | The database will convert the CREATE statement to an obfuscated format. Note: SQL Azure does not support. |
Recompile | Instruct the database not to cache a plan for the procedure. Note: Available only for procedure. |
Schema binding | The function is bound to the database objects that it references. Note: Available only for function. |
NULL on NULL Input | Indicate the server can return null without invoking the function body. Note: Available only for function and support from SQL Server 2005 or later. |
Execute As | Specify the runtime user of the function. Note: Support from SQL Server 2005 or later and SQL Azure. |
For replication | Stored procedures created for replication cannot be executed on the Subscriber. Note: Available only for procedure and SQL Azure does not support. |
Hint: Once uncheck the Show wizard next time, you can go to Options to enable it.
Definition
The Code Outline window displays information about the function/procedure including parameter, code body, etc. To show the Code Outline window, simply choose View -> Code Outline.
Note: Available only in Full Version.
Description |
Refresh the code outline. |
Show the detail view of the code outline. |
Turn mouse over highlight on or off. |
Expand the selected item. |
Collapse the selected item. |
Toggle sorting by position. |
Hint: To customize the view of the editor and find out more features for sql editing, see Editor Advanced Features.
Result
To run the procedure/function, click Run on the toolbar. If the SQL statement is correct, the statement will be executed and, if the statement is supposed to return data, the Result tab opens with the data returned by the procedure/function. If an error occurs while executing the procedure/function, execution stops, the appropriate error message is displayed. If the function/procedure requires input parameter, the Input Parameters box will pop up.
Hint: Navicat supports to return 10 resultsets.
Intuitive and well-designed GUI simplifies your database administration and development.
Manage all the database objects with smart object designer.
Insert, edit, delete or copy/paste a data entry into our spreadsheet-like data editor.
Visualize and edit your databases using a sophisticated database design and modeling tool.
Turn your database data into visuals to have clear insights in data through charts and graphs.
Compare and sync data between databases/schemas with a detailed analytical process.
Deliver a full picture of database differences, and generate script to update the destination database.
Construct SQL statements in the SQL Editor by picking the suggestions from the drop-down list.
Insert a snippet into the SQL Editor for faster and error-free SQL writing.
Create and schedule a batch job for your daily tasks, and get notification e-mails upon tasks completion.
Store your files in cloud to start collaboration with your team members.
Seamless Data Migration
Data Transfer, Data Synchronization and Structure Synchronization help you migrate your data easier and faster for less overhead. Deliver detailed, step-by-step guidelines for transferring data across databases. Compare and synchronize databases with Data and Structure Synchronization. Set up and deploy the comparisons in seconds, and get the detailed script to specify the changes you want to execute.
Diversified Manipulation Tool
Use Import Wizard to transfer data into a database from diverse formats, or from ODBC after setting up a data source connection. Export data from tables, views, or query results to formats like Excel, Access, CSV and more. Add, modify, and delete records with our spreadsheet-like Grid View together with an array of data editing tools to facilitate your edits. Navicat gives you the tools you need to manage your data efficiently and ensure a smooth process.
Easy SQL Editing
Visual SQL Builder will help you create, edit and run SQL statements without having to worry about syntax and proper usage of commands. Code fast with Code Completion and customizable Code Snippet by getting suggestions for keywords and stripping the repetition from coding.
Intelligent Database Designer
Create, modify and manage all database objects using our professional object designers. Convert your databases into graphical representations using a sophisticated database design and modeling tool so you can model, create, and understand complex databases with ease.
Data Visualization Tool
Our Charts feature lets you create visual representations of large data sets and help you to gain deeper insights from your data. Explore and unearth patterns, trends and relations between data, and create effective visual outputs to present your findings in dashboard for sharing.
Increase your Productivity
Our intuitive GUI for SQL Server Backup Utility guides you through the backup process and reduces the potential for errors. Set an automation for repeatable deployment process like script execution at a specific time or day. No matter where you are, you can always get the job done.
Make Collaboration Easy
Synchronize your connection settings, models, queries and virtual groups to our Navicat Cloud service so you can get real-time access to them, and share them with your coworkers anytime and anywhere. With Navicat Cloud, you can leverage every minute of your day to maximize your productivity. Learn more >
Advanced Secure Connection
Establish secure connections through SSH Tunneling ensures every connection is secure, stable, and reliable. Navicat provides more encryption formats and high-performance environments so you never have to worry about connecting over an insecure network.
Cross-Platform LicensingCross-platform licensing is now available. Whether you’re operating on Windows, macOS, or Linux, you can purchase once and select a platform to activate and later on transfer your license.
Dark Mode
Set dark theme to protect your eyes from the traditionally blinding whiteness of computer. No behavior changes with how pages look when you are in dark mode.
Intuitive and well-designed GUI simplifies your database administration and development.
Manage all the database objects with smart object designer.
Insert, edit, delete or copy/paste a data entry into our spreadsheet-like data editor.
Visualize and edit your databases using a sophisticated database design and modeling tool.
Turn your database data into visuals to have clear insights in data through charts and graphs.
Compare and sync data between databases/schemas with a detailed analytical process.
Deliver a full picture of database differences, and generate script to update the destination database.
Construct SQL statements in the SQL Editor by picking the suggestions from the drop-down list.
Insert a snippet into the SQL Editor for faster and error-free SQL writing.
Create and schedule a batch job for your daily tasks, and get notification e-mails upon tasks completion.
Store your files in cloud to start collaboration with your team members.
Data Transfer, Data Synchronization and Structure Synchronization help you migrate your data easier and faster for less overhead. Deliver detailed, step-by-step guidelines for transferring data across databases. Compare and synchronize databases with Data and Structure Synchronization. Set up and deploy the comparisons in seconds, and get the detailed script to specify the changes you want to execute.
Diversified Manipulation ToolUse Import Wizard to transfer data into a database from diverse formats, or from ODBC after setting up a data source connection. Export data from tables, views, or query results to formats like Excel, Access, CSV and more. Add, modify, and delete records with our spreadsheet-like Grid View together with an array of data editing tools to facilitate your edits. Navicat gives you the tools you need to manage your data efficiently and ensure a smooth process.
Easy SQL EditingVisual SQL Builder will help you create, edit and run SQL statements without having to worry about syntax and proper usage of commands. Code fast with Code Completion and customizable Code Snippet by getting suggestions for keywords and stripping the repetition from coding.
Intelligent Database DesignerCreate, modify and manage all database objects using our professional object designers. Convert your databases into graphical representations using a sophisticated database design and modeling tool so you can model, create, and understand complex databases with ease.
Data Visualization Tool
Our Charts feature lets you create visual representations of large data sets and help you to gain deeper insights from your data. Explore and unearth patterns, trends and relations between data, and create effective visual outputs to present your findings in dashboard for sharing.
Increase your ProductivityOur intuitive GUI for SQL Server Backup Utility guides you through the backup process and reduces the potential for errors. Set an automation for repeatable deployment process like script execution at a specific time or day. No matter where you are, you can always get the job done.
Make Collaboration EasySynchronize your connection settings, models, queries and virtual groups to our Navicat Cloud service so you can get real-time access to them, and share them with your coworkers anytime and anywhere. With Navicat Cloud, you can leverage every minute of your day to maximize your productivity. Learn more >
Advanced Secure ConnectionEstablish secure connections through SSH Tunneling ensures every connection is secure, stable, and reliable. Navicat provides more encryption formats and high-performance environments so you never have to worry about connecting over an insecure network.
Cross-Platform LicensingCross-platform licensing is now available. Whether you’re operating on Windows, macOS, or Linux, you can purchase once and select a platform to activate and later on transfer your license.
Dark Mode
Set dark theme to protect your eyes from the traditionally blinding whiteness of computer. No behavior changes with how pages look when you are in dark mode.
Intuitive and well-designed GUI simplifies your database administration and development.
Manage all the database objects with smart object designer.
Insert, edit, delete or copy/paste a data entry into our spreadsheet-like data editor.
Visualize and edit your databases using a sophisticated database design and modeling tool.
Turn your database data into visuals to have clear insights in data through charts and graphs.
Compare and sync data between databases/schemas with a detailed analytical process.
Deliver a full picture of database differences, and generate script to update the destination database.
Construct SQL statements in the SQL Editor by picking the suggestions from the drop-down list.
Insert a snippet into the SQL Editor for faster and error-free SQL writing.
Create and schedule a batch job for your daily tasks, and get notification e-mails upon tasks completion.
Store your files in cloud to start collaboration with your team members.
Seamless Data Migration
Data Transfer, Data Synchronization and Structure Synchronization help you migrate your data easier and faster for less overhead. Deliver detailed, step-by-step guidelines for transferring data across databases. Compare and synchronize databases with Data and Structure Synchronization. Set up and deploy the comparisons in seconds, and get the detailed script to specify the changes you want to execute.
Diversified Manipulation Tool
Use Import Wizard to transfer data into a database from diverse formats, or from ODBC after setting up a data source connection. Export data from tables, views, or query results to formats like Excel, Access, CSV and more. Add, modify, and delete records with our spreadsheet-like Grid View together with an array of data editing tools to facilitate your edits. Navicat gives you the tools you need to manage your data efficiently and ensure a smooth process.
Easy SQL Editing
Visual SQL Builder will help you create, edit and run SQL statements without having to worry about syntax and proper usage of commands. Code fast with Code Completion and customizable Code Snippet by getting suggestions for keywords and stripping the repetition from coding.
Intelligent Database Designer
Create, modify and manage all database objects using our professional object designers. Convert your databases into graphical representations using a sophisticated database design and modeling tool so you can model, create, and understand complex databases with ease.
Data Visualization Tool
Our Charts feature lets you create visual representations of large data sets and help you to gain deeper insights from your data. Explore and unearth patterns, trends and relations between data, and create effective visual outputs to present your findings in dashboard for sharing.
Increase your Productivity
Our intuitive GUI for SQL Server Backup Utility guides you through the backup process and reduces the potential for errors. Set an automation for repeatable deployment process like script execution at a specific time or day. No matter where you are, you can always get the job done.
Make Collaboration Easy
Synchronize your connection settings, models, queries and virtual groups to our Navicat Cloud service so you can get real-time access to them, and share them with your coworkers anytime and anywhere. With Navicat Cloud, you can leverage every minute of your day to maximize your productivity. Learn more >
Advanced Secure Connection
Establish secure connections through SSH Tunneling ensures every connection is secure, stable, and reliable. Navicat provides more encryption formats and high-performance environments so you never have to worry about connecting over an insecure network.
Cross-Platform LicensingCross-platform licensing is now available. Whether you’re operating on Windows, macOS, or Linux, you can purchase once and select a platform to activate and later on transfer your license.
Dark Mode
Set dark theme to protect your eyes from the traditionally blinding whiteness of computer. No behavior changes with how pages look when you are in dark mode.
System Requirements | ||
Windows Microsoft Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10, Server 2008, Server 2012, Server 2016, Server 2019 | macOS Mac OS X 10.11 El Capitan, macOS 10.12 Sierra, macOS 10.13 High Sierra, macOS 10.14 Mojave, macOS 10.15 Catalina | Linux Debian 9 or later, Ubuntu 16.04 or later, CentOS 7 or later, Fedora 26 or later, Linux Mint 18 or later |