x = 1
INSERT INTO information(
(SELECT productid from products where productid = x ),
(select accessoryorder from accessorytypes where accessoryid = x ),
(SELECT orderid from orders where orderid = x )
select * from information
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '='.
Msg 156, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'SELECT'.
I've encountered valid database schemas that do not have a primary key. For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis. However, occasionally due to user error or a scheduled task…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder. The folder can be on the local hard drive or on a network share. This batch file will query the SQL server to get the current date & time and wi…