Forum Discussion
Can someone help me fix the errors in my sql coding?
USE Optician; -- Create the branches table CREATE TABLE branches ( branch_id INT PRIMARY KEY, branch_name VARCHAR(255), branch_address VARCHAR(255), technician_available BOOLEAN ); -- Crea...
You forgot the keyword AS in your create proc synthax
Proper SQL synthax
CREATE PROC What_DB_is_this
AS
SELECT DB_NAME() AS ThisDB;
Proper SQL synthax
CREATE PROC What_DB_is_this
AS
SELECT DB_NAME() AS ThisDB;