|
|
|
|
|
|
|
-- Insert data into the table INSERT INTO MyTable (Id, Name) VALUES (1, 'John Doe');
Lightweight querying and administration without Windows.
For a more "Mac-native" feel or to manage multiple database types (like MySQL or PostgreSQL) in one app, these third-party tools are highly recommended: Microsoft SQL Management Studio for Mac
To get started with any of these tools, simply download and install them on your Mac. Most of these tools offer a user-friendly interface and documentation to help you get started.
Ensure SQL Server has TCP/IP enabled (SQL Server Configuration Manager) and port 1433 is open in firewall.