Activity overview
Latest activity by kknyazev
SQL Code Guard from command line
Hello! Can i run SQL Code Guard from command line and parse results? Thanks!Best regards, Konstantin Knyazev
Yes. The most surprising is that in sql select T.ID, T2.Name from #Tmp2 T
Invalid only alias, not table name or even column name! / comments
Yes. The most surprising is that in sql select T.ID, T2.Name from #Tmp2 T
Invalid only alias, not table name or even column name!
It is not correct, i am talking about invalid alias for temporary table. And i just suggest to think about implementing this functionality. Recently, i have found same bug and only one tool can help with it - unit tests (tSQLt ). Thanks for your attention! / comments
It is not correct, i am talking about invalid alias for temporary table. And i just suggest to think about implementing this functionality. Recently, i have found same bug and only one tool can hel...
Hello! No, #tmp does not exist. / comments
Hello! No, #tmp does not exist.
It's same but have CREATE. Very strange... I don't have error on compile on SQL Server 2017 Enterprise Edition. / comments
It's same but have CREATE. Very strange... I don't have error on compile on SQL Server 2017 Enterprise Edition.
Of course it was created.[image] / comments
Of course it was created.
Now error is no showed but alias not recognized at all (there are no any hint message), only standard SSMS warning displayed, and procedure not recognized as invalid object, although execution returns error [image] / comments
Now error is no showed but alias not recognized at all (there are no any hint message), only standard SSMS warning displayed, and procedure not recognized as invalid object, although execution retu...
I have checked - distance is 140 rows, ParserLookAheadDistance = 3000. Thank you for your attention! / comments
I have checked - distance is 140 rows, ParserLookAheadDistance = 3000.Thank you for your attention!
Yes, #Table2 is created locally in stored procedure by "select into #Table2" command / comments
Yes, #Table2 is created locally in stored procedure by "select into #Table2" command
Thank you for answer! During investigations, i found that reason is temporary table. So, SQL Prompt can not check about invalid aliases in query with temporary table [image] select T.ID from Table1 T1 join #Table2 T2 on T2.ID = T1.ID / comments
Thank you for answer! During investigations, i found that reason is temporary table. So, SQL Prompt can not check about invalid aliases in query with temporary table select T.ID from Table1 T1...