blocks|key|81057|text|这应该是可行的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|81058|(--.*)%7C(((/\*)%2B?[\w\W]%2B?(\*/)%2B))|code-block|syntax|javascript|81059|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This should work: 

<pre class="lang-none prettyprint-override"><code>(--.*)|(((/\*)+?[\w\W]+?(\*/)+))
</code></pre>

blocks|key|185662|text|使用此代码：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|185663|StringCollection+resultList+=+new+StringCollection();+
try+{
Regex+regexObj+=+new+Regex(@"/\*(?>(?:(?!\*/%7C/\*).)*)(?>(?:/\*(?>(?:(?!\*/%7C/\*).)*)\*/(?>(?:(?!\*/%7C/\*).)*))*).*?\*/%7C--.*?\r?[\n]",+RegexOptions.Singleline);
Match+matchResult+=+regexObj.Match(subjectString);
while+(matchResult.Success)+{
++++resultList.Add(matchResult.Value);
++++matchResult+=+matchResult.NextMatch();
}+
}+catch+(ArgumentException+ex)+{
//+Syntax+error+in+the+regular+expression
}|code-block|syntax|javascript|185664|通过以下输入：|185665|--+This+is+Comment+1
SELECT+Foo+FROM+Bar
GO

--+This+is
--+Comment+2
UPDATE+Bar+SET+Foo+==+'Foo'
GO

/*+This+is+Comment+3+*/
DELETE+FROM+Bar+WHERE+Foo+=+'Foo'

/*+This+is+a
multi-line+comment+*/
DROP+TABLE+Bar

/*+comment+/*+nesting+*/+of+/*+two+*/+levels+supported+*/
foo...|185666|生产这些火柴：|185667|--+This+is+Comment+1
--+This+is
--+Comment+2
/*+This+is+Comment+3+*/
/*+This+is+a
multi-line+comment+*/
/*+comment+/*+nesting+*/+of+/*+two+*/+levels+supported+*/|185668|这并不是说这将只匹配2层嵌套注释，尽管在我的生活中，我从未见过不止一个级别被使用。永远不会。|185669|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

Using this code : 

<pre><code>StringCollection resultList = new StringCollection(); 
try {
Regex regexObj = new Regex(@"/\*(?&gt;(?:(?!\*/|/\*).)*)(?&gt;(?:/\*(?&gt;(?:(?!\*/|/\*).)*)\*/(?&gt;(?:(?!\*/|/\*).)*))*).*?\*/|--.*?\r?[\n]", RegexOptions.Singleline);
Match matchResult = regexObj.Match(subjectString);
while (matchResult.Success) {
 resultList.Add(matchResult.Value);
 matchResult = matchResult.NextMatch();
} 
} catch (ArgumentException ex) {
// Syntax error in the regular expression
}
</code></pre>

With the following input : 

<pre><code>-- This is Comment 1
SELECT Foo FROM Bar
GO

-- This is
-- Comment 2
UPDATE Bar SET Foo == 'Foo'
GO

/* This is Comment 3 */
DELETE FROM Bar WHERE Foo = 'Foo'

/* This is a
multi-line comment */
DROP TABLE Bar

/* comment /* nesting */ of /* two */ levels supported */
foo...
</code></pre>

Produces these matches : 

<pre><code>-- This is Comment 1
-- This is
-- Comment 2
/* This is Comment 3 */
/* This is a
multi-line comment */
/* comment /* nesting */ of /* two */ levels supported */
</code></pre>

Not that this will only match 2 levels of nested comments, although in my life I have never seen more than one level being used. Ever.

blocks|key|2009664|text|这对我来说很管用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2009665|(/\*(.%7C[\r\n])*?\*/)%7C(--(.*%7C[\r\n]))|code-block|syntax|javascript|2009666|它匹配以*/+..开头的所有注释--或括在*/..*/区块|2009667|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

This works for me:

<pre><code>(/\*(.|[\r\n])*?\*/)|(--(.*|[\r\n]))
</code></pre>

It matches all comments starting with -- or enclosed within */ .. */ blocks

blocks|key|81087|text|在PHP中，我使用这段代码取消注释SQL+(这是注释版->+x修饰符)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|81088|trim(+preg_replace(+'@
(([\'"]).*?[%5E\\\]\2)+#+$1+:+Skip+single+&+double+quoted+expressions
%7C(+++++++++++++++++++#+$3+:+Match+comments
++++(?:\#%7C--).*?$++++#+-+Single+line+comment
++++%7C++++++++++++++++#+-+Multi+line+(nested)+comments
+++++/\*+++++++++++++#+++.+comment+open+marker
++++++++(?:+[%5E/*]++++#+++.+non+comment-marker+characters
++++++++++++%7C/(?!\*)+#+++.+not+a+comment+open
++++++++++++%7C\*(?!/)+#+++.+not+a+comment+close
++++++++++++%7C(?R)++++#+++.+recursive+case
++++++++)*+++++++++++#+++.+repeat+eventually
++++\*\/+++++++++++++#+++.+comment+close+marker
)\s*+++++++++++++++++#+Trim+after+comments
%7C(?<=;)\s%2B+++++++++++#+Trim+after+semi-colon
@msx',+'$1',+$sql+)+);|code-block|syntax|javascript|81089|简短版本：|81090|trim(+preg_replace(+'@(([\'"]).*?[%5E\\\]\2)%7C((?:\#%7C--).*?$%7C/\*(?:[%5E/*]%7C/(?!\*)%7C\*(?!/)%7C(?R))*\*\/)\s*%7C(?<=;)\s%2B@ms',+'$1',+$sql+)+);|81091|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

In PHP, i'm using this code to uncomment SQL (this is the commented version -> x modifier) :

<pre><code>trim( preg_replace( '@
(([\'"]).*?[^\\\]\2) # $1 : Skip single &amp; double quoted expressions
|( # $3 : Match comments
 (?:\#|--).*?$ # - Single line comment
 | # - Multi line (nested) comments
 /\* # . comment open marker
 (?: [^/*] # . non comment-marker characters
 |/(?!\*) # . not a comment open
 |\*(?!/) # . not a comment close
 |(?R) # . recursive case
 )* # . repeat eventually
 \*\/ # . comment close marker
)\s* # Trim after comments
|(?&lt;=;)\s+ # Trim after semi-colon
@msx', '$1', $sql ) );
</code></pre>

Short version:

<pre><code>trim( preg_replace( '@(([\'"]).*?[^\\\]\2)|((?:\#|--).*?$|/\*(?:[^/*]|/(?!\*)|\*(?!/)|(?R))*\*\/)\s*|(?&lt;=;)\s+@ms', '$1', $sql ) );
</code></pre>

blocks|key|81097|text|我看到您使用的是微软的Server+(而不是甲骨文或MySQL)。如果放宽regex要求，现在(从2012年起)可以使用Microsoft自己的解析器：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|81098|using+Microsoft.SqlServer.Management.TransactSql.ScriptDom;

...

public+string+StripCommentsFromSQL(+string+SQL+)+{

++++TSql110Parser+parser+=+new+TSql110Parser(+true+);
++++IList<ParseError>+errors;
++++var+fragments+=+parser.Parse(+new+System.IO.StringReader(+SQL+),+out+errors+);

++++//+clear+comments
++++string+result+=+string.Join+(+
++++++string.Empty,
++++++fragments.ScriptTokenStream
++++++++++.Where(+x+=>+x.TokenType+!=+TSqlTokenType.MultilineComment+)
++++++++++.Where(+x+=>+x.TokenType+!=+TSqlTokenType.SingleLineComment+)
++++++++++.Select(+x+=>+x.Text+)+);

++++return+result;

}|code-block|syntax|javascript|81099|请参阅从SQL中删除注释|offset|length|81100|entityMap|0|LINK|mutability|MUTABLE|url|http://michaeljswart.com/2014/04/removing-comments-from-sql/^0|0|0|3|9|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

I see you're using Microsoft's SQL Server (as opposed to Oracle or MySQL). 
If you relax the regex requirement, it's now possible (since 2012) to use Microsoft's own parser:

<pre><code>using Microsoft.SqlServer.Management.TransactSql.ScriptDom;

...

public string StripCommentsFromSQL( string SQL ) {

 TSql110Parser parser = new TSql110Parser( true );
 IList&lt;ParseError&gt; errors;
 var fragments = parser.Parse( new System.IO.StringReader( SQL ), out errors );

 // clear comments
 string result = string.Join ( 
 string.Empty,
 fragments.ScriptTokenStream
 .Where( x =&gt; x.TokenType != TSqlTokenType.MultilineComment )
 .Where( x =&gt; x.TokenType != TSqlTokenType.SingleLineComment )
 .Select( x =&gt; x.Text ) );

 return result;

}
</code></pre>

See <a href="http://michaeljswart.com/2014/04/removing-comments-from-sql/" rel="nofollow">Removing Comments From SQL</a>

blocks|key|2009747|text|我创建了这个函数，它删除了所有的SQL注释，使用普通正则表达式。它移除行注释(即使之后没有行中断)和块注释(即使存在嵌套块注释)。此函数还可以替换文字(如果要在SQL过程中搜索某些内容，但需要忽略字符串，则非常有用)。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2009748|我的代码基于这个回答+(关于C#注释)，所以我不得不将行注释从"//“更改为--，但更重要的是，我必须重写块注释regex+(使用平衡组)，因为SQL允许嵌套块注释，而C#不允许。|2009749|另外，我有一个"preservePositions“参数，它不是去掉注释，而是用空格填充注释。如果您想要保留每个SQL命令的原始位置，这是很有用的，以防您需要在保留原始注释的同时操作原始脚本。|2009750|Regex+everythingExceptNewLines+=+new+Regex("[%5E\r\n]");
public+string+RemoveComments(string+input,+bool+preservePositions,+bool+removeLiterals=false)
{
++++//based+on+https://stackoverflow.com/questions/3524317/regex-to-strip-line-comments-from-c-sharp/3524689#3524689

++++var+lineComments+=+@"--(.*?)\r?\n";
++++var+lineCommentsOnLastLine+=+@"--(.*?)$";+//+because+it's+possible+that+there's+no+\r\n+after+the+last+line+comment
++++//+literals+('literals'),+bracketedIdentifiers+([object])+and+quotedIdentifiers+("object"),+they+follow+the+same+structure:
++++//+there's+the+start+character,+any+consecutive+pairs+of+closing+characters+are+considered+part+of+the+literal/identifier,+and+then+comes+the+closing+character
++++var+literals+=+@"('(('')%7C[%5E'])*')";+//+'John',+'O''malley''s',+etc
++++var+bracketedIdentifiers+=+@"\[((\]\])%7C[%5E\]])*+\]";+//+[object],+[+%25+object]]+],+etc
++++var+quotedIdentifiers+=+@"(\""((\""\"")%7C[%5E""])*\"")";+//+"object",+"object[]",+etc+-+when+QUOTED_IDENTIFIER+is+set+to+ON,+they+are+identifiers,+else+they+are+literals
++++//var+blockComments+=+@"/\*(.*?)\*/";++//the+original+code+was+for+C#,+but+Microsoft+SQL+allows+a+nested+block+comments+//+//https://msdn.microsoft.com/en-us/library/ms178623.aspx
++++//so+we+should+use+balancing+groups+//+http://weblogs.asp.net/whaggard/377025
++++var+nestedBlockComments+=+@"/\*
++++++++++++++++++++++++++++++++(?>
++++++++++++++++++++++++++++++++/\*++(?<LEVEL>)++++++#+On+opening+push+level
++++++++++++++++++++++++++++++++%7C+
++++++++++++++++++++++++++++++++\*/+(?<-LEVEL>)+++++#+On+closing+pop+level
++++++++++++++++++++++++++++++++%7C
++++++++++++++++++++++++++++++++(?!+/\*+%7C+\*/+)+.+#+Match+any+char+unless+the+opening+and+closing+strings+++
++++++++++++++++++++++++++++++++)%2B+++++++++++++++++++++++++#+/*+or+*/+in+the+lookahead+string
++++++++++++++++++++++++++++++++(?(LEVEL)(?!))+++++++++++++#+If+level+exists+then+fail
++++++++++++++++++++++++++++++++\*/";

++++string+noComments+=+Regex.Replace(input,
++++++++++++nestedBlockComments+%2B+"%7C"+%2B+lineComments+%2B+"%7C"+%2B+lineCommentsOnLastLine+%2B+"%7C"+%2B+literals+%2B+"%7C"+%2B+bracketedIdentifiers+%2B+"%7C"+%2B+quotedIdentifiers,
++++++++me+=>+{
++++++++++++if+(me.Value.StartsWith("/*")+&&+preservePositions)
++++++++++++++++return+everythingExceptNewLines.Replace(me.Value,+"+");+//+preserve+positions+and+keep+line-breaks+//+return+new+string('+',+me.Value.Length);
++++++++++++else+if+(me.Value.StartsWith("/*")+&&+!preservePositions)
++++++++++++++++return+"";
++++++++++++else+if+(me.Value.StartsWith("--")+&&+preservePositions)
++++++++++++++++return+everythingExceptNewLines.Replace(me.Value,+"+");+//+preserve+positions+and+keep+line-breaks
++++++++++++else+if+(me.Value.StartsWith("--")+&&+!preservePositions)
++++++++++++++++return+everythingExceptNewLines.Replace(me.Value,+"");+//+preserve+only+line-breaks+//+Environment.NewLine;
++++++++++++else+if+(me.Value.StartsWith("[")+%7C%7C+me.Value.StartsWith("\""))
++++++++++++++++return+me.Value;+//+do+not+remove+object+identifiers+ever
++++++++++++else+if+(!removeLiterals)+//+Keep+the+literal+strings
++++++++++++++++return+me.Value;
++++++++++++else+if+(removeLiterals+&&+preservePositions)+//+remove+literals,+but+preserving+positions+and+line-breaks
++++++++++++{
++++++++++++++++var+literalWithLineBreaks+=+everythingExceptNewLines.Replace(me.Value,+"+");
++++++++++++++++return+"'"+%2B+literalWithLineBreaks.Substring(1,+literalWithLineBreaks.Length+-+2)+%2B+"'";
++++++++++++}
++++++++++++else+if+(removeLiterals+&&+!preservePositions)+//+wrap+completely+all+literals
++++++++++++++++return+"''";
++++++++++++else
++++++++++++++++throw+new+NotImplementedException();
++++++++},
++++++++RegexOptions.Singleline+%7C+RegexOptions.IgnorePatternWhitespace);
++++return+noComments;
}|code-block|syntax|javascript|2009751|测试1(第一次原始，然后删除注释，最后删除注释/文字)|2009752|[select+/*+block+comment+*/+top+1+'a'+/*+block+comment+/*+nested+block+comment+*/*/+from++sys.tables+--LineComment
union
select+top+1+'/*+literal+with+*/--+lots+of+comments+symbols'+from+sys.tables+--FinalLineComment]

[select+++++++++++++++++++++top+1+'a'+++++++++++++++++++++++++++++++++++++++++++++++from++sys.tables++++++++++++++
union
select+top+1+'/*+literal+with+*/--+lots+of+comments+symbols'+from+sys.tables+++++++++++++++++++]

[select+++++++++++++++++++++top+1+'+'+++++++++++++++++++++++++++++++++++++++++++++++from++sys.tables++++++++++++++
union
select+top+1+'+++++++++++++++++++++++++++++++++++++++++++++'+from+sys.tables+++++++++++++++++++]|2009753|测试2(第一次原始，然后删除注释，最后删除注释/文字)|2009754|Original:
[create+table+[/*]+/*+
++--+huh?+*/
(
++++"--
+++++--"+integer+identity,+--+/*
++++[*/]+varchar(20)+/*+--+*/
+++++++++default+'*/+/*+--+*/'+/*+/*+/*+*/+*/+*/
);
++++++++++++go]


[create+table+[/*]++++

(
++++"--
+++++--"+integer+identity,++++++
++++[*/]+varchar(20)+++++++++
+++++++++default+'*/+/*+--+*/'++++++++++++++++++
);
++++++++++++go]


[create+table+[/*]++++

(
++++"--
+++++--"+integer+identity,++++++
++++[*/]+varchar(20)+++++++++
+++++++++default+'+++++++++++'++++++++++++++++++
);
++++++++++++go]|2009755|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/3524689/3606250^0|M|9|Z|3|1E|3|1Z|4|0|1T|3|20|A|8|2|0|0|8|H|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@$9|15|A|16|B|C]|$9|17|A|18|B|C]|$9|19|A|1A|B|C]|$9|1B|A|1C|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|1D|8|@$9|1E|A|1F|B|C]|$9|1G|A|1H|B|C]]|D|@$9|1I|A|1J|1|1K]]|E|$]]|$1|H|3|I|5|6|7|1L|8|@$9|1M|A|1N|B|C]]|D|@]|E|$]]|$1|J|3|K|5|L|7|1O|8|@]|D|@]|E|$M|N]]|$1|O|3|P|5|6|7|1P|8|@]|D|@]|E|$]]|$1|Q|3|R|5|L|7|1Q|8|@]|D|@]|E|$M|N]]|$1|S|3|T|5|6|7|1R|8|@]|D|@]|E|$]]|$1|U|3|V|5|L|7|1S|8|@]|D|@]|E|$M|N]]|$1|W|3|-4|5|6|7|1T|8|@]|D|@]|E|$]]]|X|$Y|$5|Z|10|11|E|$12|13]]]]

I made this function that removes all SQL comments, using plain regular expressons. It removes both line comments (even when there is not a linebreak after) and block comments (even if there are nested block comments). This function can also replace literals (useful if you are searching for something inside SQL procedures but you want to ignore strings).

My code was based on this <a href="https://stackoverflow.com/a/3524689/3606250">answer</a> (which is about C# comments), so I had to change line comments from "//" to "--", but more importantly I had to rewrite the block comments regex (using balancing groups) because SQL allows nested block comments, while C# doesn't. 

Also, I have this "preservePositions" argument, which instead of stripping out the comments it just fills comments with whitespace. That's useful if you want to preserve the original position of each SQL command, in case you need to manipulate the original script while preserving original comments.

<pre><code>Regex everythingExceptNewLines = new Regex("[^\r\n]");
public string RemoveComments(string input, bool preservePositions, bool removeLiterals=false)
{
 //based on https://stackoverflow.com/questions/3524317/regex-to-strip-line-comments-from-c-sharp/3524689#3524689

 var lineComments = @"--(.*?)\r?\n";
 var lineCommentsOnLastLine = @"--(.*?)$"; // because it's possible that there's no \r\n after the last line comment
 // literals ('literals'), bracketedIdentifiers ([object]) and quotedIdentifiers ("object"), they follow the same structure:
 // there's the start character, any consecutive pairs of closing characters are considered part of the literal/identifier, and then comes the closing character
 var literals = @"('(('')|[^'])*')"; // 'John', 'O''malley''s', etc
 var bracketedIdentifiers = @"\[((\]\])|[^\]])* \]"; // [object], [ % object]] ], etc
 var quotedIdentifiers = @"(\""((\""\"")|[^""])*\"")"; // "object", "object[]", etc - when QUOTED_IDENTIFIER is set to ON, they are identifiers, else they are literals
 //var blockComments = @"/\*(.*?)\*/"; //the original code was for C#, but Microsoft SQL allows a nested block comments // //https://msdn.microsoft.com/en-us/library/ms178623.aspx
 //so we should use balancing groups // http://weblogs.asp.net/whaggard/377025
 var nestedBlockComments = @"/\*
 (?&gt;
 /\* (?&lt;LEVEL&gt;) # On opening push level
 | 
 \*/ (?&lt;-LEVEL&gt;) # On closing pop level
 |
 (?! /\* | \*/ ) . # Match any char unless the opening and closing strings 
 )+ # /* or */ in the lookahead string
 (?(LEVEL)(?!)) # If level exists then fail
 \*/";

 string noComments = Regex.Replace(input,
 nestedBlockComments + "|" + lineComments + "|" + lineCommentsOnLastLine + "|" + literals + "|" + bracketedIdentifiers + "|" + quotedIdentifiers,
 me =&gt; {
 if (me.Value.StartsWith("/*") &amp;&amp; preservePositions)
 return everythingExceptNewLines.Replace(me.Value, " "); // preserve positions and keep line-breaks // return new string(' ', me.Value.Length);
 else if (me.Value.StartsWith("/*") &amp;&amp; !preservePositions)
 return "";
 else if (me.Value.StartsWith("--") &amp;&amp; preservePositions)
 return everythingExceptNewLines.Replace(me.Value, " "); // preserve positions and keep line-breaks
 else if (me.Value.StartsWith("--") &amp;&amp; !preservePositions)
 return everythingExceptNewLines.Replace(me.Value, ""); // preserve only line-breaks // Environment.NewLine;
 else if (me.Value.StartsWith("[") || me.Value.StartsWith("\""))
 return me.Value; // do not remove object identifiers ever
 else if (!removeLiterals) // Keep the literal strings
 return me.Value;
 else if (removeLiterals &amp;&amp; preservePositions) // remove literals, but preserving positions and line-breaks
 {
 var literalWithLineBreaks = everythingExceptNewLines.Replace(me.Value, " ");
 return "'" + literalWithLineBreaks.Substring(1, literalWithLineBreaks.Length - 2) + "'";
 }
 else if (removeLiterals &amp;&amp; !preservePositions) // wrap completely all literals
 return "''";
 else
 throw new NotImplementedException();
 },
 RegexOptions.Singleline | RegexOptions.IgnorePatternWhitespace);
 return noComments;
}
</code></pre>

Test 1 (first original, then removing comments, last removing comments/literals)

<pre><code>[select /* block comment */ top 1 'a' /* block comment /* nested block comment */*/ from sys.tables --LineComment
union
select top 1 '/* literal with */-- lots of comments symbols' from sys.tables --FinalLineComment]

[select top 1 'a' from sys.tables 
union
select top 1 '/* literal with */-- lots of comments symbols' from sys.tables ]

[select top 1 ' ' from sys.tables 
union
select top 1 ' ' from sys.tables ]
</code></pre>

Test 2 (first original, then removing comments, last removing comments/literals)

<pre><code>Original:
[create table [/*] /* 
 -- huh? */
(
 "--
 --" integer identity, -- /*
 [*/] varchar(20) /* -- */
 default '*/ /* -- */' /* /* /* */ */ */
);
 go]


[create table [/*] 

(
 "--
 --" integer identity, 
 [*/] varchar(20) 
 default '*/ /* -- */' 
);
 go]


[create table [/*] 

(
 "--
 --" integer identity, 
 [*/] varchar(20) 
 default ' ' 
);
 go]
</code></pre>

blocks|key|81144|text|下面的工作原理很好-+pg-小型化，不仅适用于PostgreSQL，也适用于MS-SQL。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|81145|据推测，如果我们删除注释，这意味着脚本不再用于阅读，同时缩小它是一个好主意。|81146|该库删除所有注释，作为脚本缩小的一部分。|81147|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/vitaly-t/pg-minify^0|B|6|0|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|C|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]]]

The following works fine - <a href="https://github.com/vitaly-t/pg-minify" rel="nofollow">pg-minify</a>, and not only for PostgreSQL, but for MS-SQL also.

Presumably, if we remove comments, that means the script is no longer for reading, and minifying it at the same time is a good idea.

That library deletes all comments as part of the script minification.

blocks|key|185818|text|我正在使用这个java代码从文本中删除所有的sql注释。它支持诸如/*+.+*/、-.嵌套注释之类的注释，忽略引用字符串中的注释。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|185819|++public+static+String+stripComments(String+sqlCommand)+{
++++StringBuilder+result+=+new+StringBuilder();
++++//group+1+must+be+quoted+string
++++Pattern+pattern+=+Pattern.compile("('(''%7C[%5E'])*')%7C(/\\*(.%7C[\\r\\n])*?\\*/)%7C(--(.*%7C[\\r\\n]))");
++++Matcher+matcher+=+pattern.matcher(sqlCommand);
++++int+prevIndex+=+0;
++++while(matcher.find())+{
++++++//+add+previous+portion+of+string+that+was+not+found+by+regexp+-+meaning+this+is+not+a+quoted+string+and+not+a+comment
++++++result.append(sqlCommand,+prevIndex,+matcher.start());
++++++prevIndex+=+matcher.end();
++++++//+add+the+quoted+string
++++++if+(matcher.group(1)+!=+null)+{
++++++++result.append(sqlCommand,+matcher.start(),+matcher.end());
++++++}
++++}
++++result.append(sqlCommand.substring(prevIndex));
++++return+result.toString();
++}|code-block|syntax|javascript|185820|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I am using this java code to remove all sql comments from text. It supports comments like /* ... */ , --..., nested comments, ignores comments inside quoted strings
<pre><code> public static String stripComments(String sqlCommand) {
 StringBuilder result = new StringBuilder();
 //group 1 must be quoted string
 Pattern pattern = Pattern.compile(&quot;('(''|[^'])*')|(/\\*(.|[\\r\\n])*?\\*/)|(--(.*|[\\r\\n]))&quot;);
 Matcher matcher = pattern.matcher(sqlCommand);
 int prevIndex = 0;
 while(matcher.find()) {
 // add previous portion of string that was not found by regexp - meaning this is not a quoted string and not a comment
 result.append(sqlCommand, prevIndex, matcher.start());
 prevIndex = matcher.end();
 // add the quoted string
 if (matcher.group(1) != null) {
 result.append(sqlCommand, matcher.start(), matcher.end());
 }
 }
 result.append(sqlCommand.substring(prevIndex));
 return result.toString();
 }
</code></pre>

blocks|key|2009831|text|继杰里米的回答，并受到阿德里安·纪伯拉特的回答的启发。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2009832|这是我的版本，它支持单引号字符串中的注释字符。|2009833|注意，您需要启用RegexOptions.IgnorePatternWhitespace，大多数其他语言--这是x选项|offset|length|style|BOLD|2009834|(?:+(?:'[%5E']*?')+%7C+(?<singleline>--[%5E\n]*)+%7C+(?<multiline>(?:\/\*)%2B?[\w\W]%2B?(?:\*\/)%2B)+)|code-block|syntax|javascript|2009835|示例https://regex101.com/r/GMUAnc/3|2009836|entityMap|0|LINK|mutability|MUTABLE|url|https://regex101.com/r/GMUAnc/3^0|0|0|8|10|1K|1|0|0|2|V|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|10|8|@$F|11|G|12|H|I]|$F|13|G|14|H|I]]|9|@]|A|$]]|$1|J|3|K|5|L|7|15|8|@]|9|@]|A|$M|N]]|$1|O|3|P|5|6|7|16|8|@]|9|@$F|17|G|18|1|19]]|A|$]]|$1|Q|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]]|R|$S|$5|T|U|V|A|$W|X]]]]

Following up from Jeremy's answer and inspired by Adrien Gibrat's answer.
This is my version that supports comment characters inside single-quoted strings.
.NET C# note you need to enable RegexOptions.IgnorePatternWhitespace
, most other languages this is the x option
<pre><code>(?: (?:'[^']*?') | (?&lt;singleline&gt;--[^\n]*) | (?&lt;multiline&gt;(?:\/\*)+?[\w\W]+?(?:\*\/)+) )
</code></pre>
Example
<a href="https://regex101.com/r/GMUAnc/3" rel="nofollow noreferrer">https://regex101.com/r/GMUAnc/3</a>

I need a Regular Expression to capture ALL comments in a block of T-SQL. The Expression will need to work with the .Net Regex Class.

Let's say I have the following T-SQL:

<pre><code>-- This is Comment 1
SELECT Foo FROM Bar
GO

-- This is
-- Comment 2
UPDATE Bar SET Foo == 'Foo'
GO

/* This is Comment 3 */
DELETE FROM Bar WHERE Foo = 'Foo'

/* This is a
multi-line comment */
DROP TABLE Bar
</code></pre>

I need to capture all of the comments, including the multi-line ones, so that I can strip them out.

EDIT: It would serve the same purpose to have an expression that takes everything BUT the comments.

Regular Expression to Match All Comments in a T-SQL Script

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我需要一个正则表达式来捕获T块中的所有注释。表达式将需要使用.Net Regex类。假设我有以下the：-- This is Comment 1SELECT Foo FROM BarGO-- This is-- Comment 2UPDATE Bar SET Foo == 'Foo'GO/* This is Comme...

问正则表达式以匹配to脚本中的所有注释
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问正则表达式以匹配to脚本中的所有注释EN