我不知道这世界上在抱怨什么 在我看来很好
DECLARE @newidentity int
SET @newidentity = scope_identity()
select @newidentity
Insert into @Companies (select @newidentity, Name from Company where Name = Parker )
插入一行,我得到以下内容:
Incorrect syntax near the keyword select .
Incorrect syntax near ) .
请尝试删除括号并指定公司的字段,请:
INSERT INTO @Companies
(field1,
field2)
SELECT @newidentity,
Name
FROM Company
WHERE Name = Parker
什么是“code” companyes ?
I am trying to send the table data which comprises of 2 columns Status and Count through email. And I need to achieve this from stored procedure with DB send mail. I wrote the below code, but the ...
我正试图加入在服务器上的多个桌子,并保持快速业绩。
I have query joining several tables, the last table is joined with LEFT JOIN. The last table has more then million rows and execution plan shows table scan on it. I have indexed columns on which the ...
I have a log table in SQL Server. Table is structured this way: Unique ProblemID ResponsibleID AssignedToID ProblemCode 155 155 0282 4 156 155 ...
I couldn t quite find a scenario that matched what I am trying to do. I have one table that holds UserID, their Subscription PackageID and their Subscription date. Sample data for #Subscription ...
I am using SSMS 2008 and I have the following scalar function to take a text string and remove all metatags from Microsoft Word. The tags are enclosed in "<...>" and there can be any number of ...
I m having some trouble writing a query. For example: Let s say I have just one table with the following values: Items +-----+--------+ | ID | NAME | +-----+--------+ | A1 | Item_1 | | A1 |...
I have this data in my table: onum amt odate cnum snum 3001 18,69 1990-03-10 00:00:00.000 2008 1007 3002 1900,10 1990-03-10 00:00:00.000 ...