How Do You Write Basic Sql Statements In Sql Server?
• Click on Start –> All Programs –> Microsoft SQL Server (2005/2008) –> SQL Server Management Studio • Next Login with your credentials to the Server • Now right click on the Northwind Database and choose New Query • In the new Query Window, enter the following command for SELECT • This is the syntax for SELECT – SELECT * FROM Employees • This is the syntax for INSERT – INSERT INTO Employees VALUES(‘col1’, ‘col2’) – Replace col1 and col2 with actual Values as shown below INSERT INTO Employees values(‘Anil’,’anil@company.com’) This inserts a single row into the table. In the even you wish to enter multiple rows at one go, you see the following command INSERT INTO Employees values(‘Anna’,’anna@company.com’), INSERT INTO Employees values(‘Krystel’,’krystel@company.com’), INSERT INTO Employees values(‘Lines’,’lines@company.com’). The key difference here is that every value is appended by a comma • This is the syntax for UPDATE – UPDATE Employees SET col1 = ‘new value’ WHERE col1 = ‘old
