Apr 13, 2010 at 9:38 PM
Edited Apr 13, 2010 at 9:49 PM
Trying your tool, one thing came up:
Error #: 40517 -- Keyword or statement option '$identity' is not supported in this version of SQL
Should perhaps come up in the analyze stage?
Anyway, thanks, you saved me a lot of time.
CREATE PROCEDURE spStoreMessage
@clientAddress nvarchar(255) = NULL,
@pageUrl nvarchar(400) = NULL,
@userName nvarchar(50) = NULL,
@message nvarchar(255) = NULL
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Get the client address id
DECLARE @clientId INT
SET @clientId = (SELECT id FROM tblClient WHERE address LIKE @clientAddress)
IF @clientId IS NULL
INSERT tblClient(address) VALUES (@clientAddress)
SET @clientId = (SELECT MAX($IDENTITY) FROM tblClient)
Apr 14, 2010 at 4:04 PM
Edited Apr 14, 2010 at 4:04 PM
I will put that in my NotSupportedByAzureFile.config. If you want, you can add the following line to your NotSupportedByAzureFile.config (under <GeneralTSQL>):
This should catch the IDENTITY issue until I make a new release.
Ok, fine by me.