Error 156 Incorrect Syntax Near The Keyword
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies incorrect syntax near the keyword 'case' of this site About Us Learn more about Stack Overflow the company incorrect syntax near the keyword 'group' Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users incorrect syntax near the keyword 'select' Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a
Incorrect Syntax Near The Keyword 'identity'
minute: Sign up SQL: Msg 156, Level 15, State 1 :Incorrect syntax near the keyword 'END' up vote 0 down vote favorite Ok i have 2 questions 1) I've googled that error(in title) but I cant seem to get it to help me, my proc: CREATE PROCEDURE [dbo].[p_Target] AS BEGIN ET NOCOUNT ON CREATE TABLE #tmp1 ( AUD_ID BIGINT, RowCounter BIGINT, DistinctCounter incorrect syntax near the keyword 'with'. if this statement is a common table expression BIGINT, NACounter BIGINT, Total BIGINT, [Status] VARCHAR(MAX) ) INSERT INTO #tmp1 EXEC [p_GetCompleteIncompleteNaOverviewSCORE] DECLARE @Total AS INT SELECT @Total = COUNT(*) FROM ( SELECT CASE WHEN CONVERT(DATETIME,CONVERT(CHAR(10),DATEADD(DAY,0,t2.AUD_TargetDate), 101)) < CONVERT(DATETIME,CONVERT(CHAR(10),DATEADD(DAY,0,GETDATE()), 101)) THEN 'Over Due: ' ELSE 'On Time: ' END AS [Target Status] FROM #tmp1 t1 INNER JOIN dbo.Audit t2 ON t1.AUD_ID = t2.AUD_ID WHERE t1.[Status] = 'Open') DER SELECT ([Target Status] + '' + CAST(COUNT(*) AS NVARCHAR(255)) + ' of ' + CAST(@Total AS NVARCHAR(255))) AS TargetStatus, (SELECT COUNT(*)) * 100 / (SELECT ([Target Status] + '' + CAST(COUNT(*) AS NVARCHAR(255))) AS [Count] FROM ( SELECT CASE WHEN CONVERT(DATETIME,CONVERT(CHAR(10),DATEADD(DAY,0,t2.AUD_TargetDate), 101)) < CONVERT(DATETIME,CONVERT(CHAR(10),DATEADD(DAY,0,GETDATE()), 101)) THEN 'Over Due: ' ELSE 'On Time: ' END AS [Target Status] FROM #tmp1 t1 INNER JOIN dbo.Audit t2 ON t1.AUD_ID = t2.AUD_ID WHERE t1.[Status] = 'Open') DER GROUP BY [Target Status] END GO I've tied adding ) to NVARCHAR(255))) AS [Count] but still errors, 2)I need to get AS [Count] as a percentag, if anyone can help? That is my try code maybe i am on the right track.? sql-server tsql share|improve this question edited Jan 8 '14
Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated http://www.tek-tips.com/viewthread.cfm?qid=350284 SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting https://codedump.io/share/mKQnXRC7uHNP/1/error-msg-156-level-15-state-1-incorrect-syntax-near-the-keyword-39continue39 is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML incorrect syntax Markdown MediaWiki reStructuredText code below into your site. Microsoft SQL Server: Programming Forum at Tek-Tips HomeForumsProgrammersDBMS PackagesMicrosoft SQL Server: Programming Forum Error #156: Incorrect syntax near the keyword 'File'. thread183-350284 Forum Search FAQs Links MVPs Error #156: Incorrect syntax near the keyword 'File'. Error #156: Incorrect syntax near the keyword 'File'. tats (Programmer) (OP) 2 Sep 02 20:29 I have an ASP.NET page which updates, deletes and adds records to/from incorrect syntax near one table in the database, but not another. The only difference between the two tables that I can see is that the 2nd table contains [Date] and [File] columns (Sql Server puts the brackets automatically to distinquish between the Date and File reserved keywords).I tried to change the File column name to FilePath, and that worked. But I'm suspicious. Why doesn't Date produce a problem? If Sql Server allows keywords in the column names, howcome it cannot handle the updates? Perhaps, my problem is somewhere else?!Any suggestions? RE: Error #156: Incorrect syntax near the keyword 'File'. tlbroadbent (MIS) 3 Sep 02 02:11 Did you include the brackets around the keywords?If that isn't the problem, please post the query. Terry L. Broadbent - DBAComputing Links: http://tlbroadbent.home.attbi.com/prog.htmFAQ183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions. RE: Error #156: Incorrect syntax near the keyword 'File'. tats (Programmer) (OP) 3 Sep 02 04:06 When I used brackets, I got a different error saying that no such fieldexists.I'm using .NET SqlCommandBuilder class which automatically builds thequery for me. For eg, for an insert it generates the following:INSERT INTO Press( Author , Date , Title , PublicationTitle ,PageReference , File , Abstract ) VALUES ( @p1 , @p2 , @p3 , @p4 ,
Gherkin Git Go Groovy Haml Handlebars Haskell HTML HTTP Ini iOS Jade Java Javascript jQuery JSON Julia Keyman LaTeX Linux Less LOLCODE Makefile Markdown MATLAB MySQL NASM Node.js NSIS Objective-C Pascal Perl PHP PHP Extras PowerShell Python R React JSX reST (reStructuredText) Rip Ruby Rust SAS Sass (Sass) Sass (Scss) Scala Scheme Smalltalk Smarty SQL Stylus Swift Twig TypeScript Vb.net VHDL Wiki markup YAML Other Search Anonymous - 9 months ago 172x SQL Question ERROR Msg 156, Level 15, State 1, Incorrect syntax near the keyword 'CONTINUE' I need some Help making this MySQL Cursor, I have been following this guide:http://www.mysqltutorial.org/mysql-cursor/. I am trying to make a cursor to iterate through a table and create a list of names one row at a time. CREATE PROCEDURE build_people_table ( @people varchar(4000))
AS
BEGIN
DECLARE @v_finished INT;
DECLARE @v_name nvarchar(255);
--Main Cursor
DECLARE people_cursor CURSOR FOR
SELECT [Person Name]
FROM [dbo].[People];
-- declare NOT FOUND handler
DECLARE CONTINUE HANDLER
FOR NOT FOUND SET @v_finished = 1;
OPEN people_cursor;
get_name: LOOP
FETCH people_cursor INTO @v_name ;
IF @v_finished = 1 THEN
LEAVE get_name;
END IF;
SET @people = CONCAT(@v_name,';',@people);
END LOOP get_name;
CLOSE people_cursor;
END
mySQL ERROR Message Msg 156, Level 15, State 1, Procedure build_people_table, Line 41
Incorrect syntax near the keyword 'CONTINUE'.
Msg 136, Level 15, State 1, Procedure build_people_table, Line 41
Cannot use a CONTINUE statement outside the scope of a WHILE statement.
Msg 102, Level 15, State 1, Procedure build_people_table, Line 47
Incorrect syntax near 'LOOP'.
Msg 156, Level 15, State 1, Procedure build_people_table, Line 56
Incorrect syntax near the keyword 'THEN'.
Msg 102, Level 15, State 1, Procedure build_people_table, Line 61
Incorrect syntax near