Пример #1
0
		protected internal override void WriteToInternal(SqlWriter writer, bool isPartOfQualifiedName) {
			if (IsBuiltinFunction) {
				if ((writer.Engine == DatabaseEngine.SqlAzure) && (Value.Equals("NEWSEQUENTIALID", StringComparison.OrdinalIgnoreCase))) {
					writer.WriteFunction(ScriptParser.GetBuiltinFunctionName("NEWID"));
				} else {
					writer.WriteFunction(Value);
				}
			} else {
				base.WriteToInternal(writer, true);
			}
		}
Пример #2
0
		public override void WriteTo(SqlWriter writer) {
			WriteCommentsTo(writer);
			writer.WriteFunction("UPDATE");
			writer.Write('(');
			writer.WriteScript(columnName, WhitespacePadding.None);
			writer.Write(')');
		}
Пример #3
0
		public override void WriteTo(SqlWriter writer) {
			writer.WriteFunction("COUNT");
			writer.Write('(');
			writer.WriteDuplicateRestriction(restriction, WhitespacePadding.SpaceAfter);
			writer.WriteScript(expression, WhitespacePadding.None);
			writer.Write(')');
		}
Пример #4
0
		public override void WriteTo(SqlWriter writer) {
			writer.WriteFunction("CAST");
			writer.Write('(');
			writer.WriteScript(expression, WhitespacePadding.None);
			writer.WriteKeyword(" AS ");
			writer.WriteScript(typeName, WhitespacePadding.None);
			writer.Write(')');
		}
Пример #5
0
		public override void WriteTo(SqlWriter writer) {
			writer.WriteFunction("OPENXML");
			writer.Write('(');
			writer.WriteScript(variableName, WhitespacePadding.None);
			writer.Write(", ");
			stringValue.WriteTo(writer);
			if (flags != 0) {
				writer.Write(", ");
				writer.WriteKeyword(flags.ToString(NumberFormatInfo.InvariantInfo));
			}
			writer.Write(')');
			writer.WriteScript(schema, WhitespacePadding.SpaceBefore);
		}
Пример #6
0
		public override void WriteTo(SqlWriter writer) {
			writer.WriteFunction("OBJECT_ID");
			writer.Write('(');
			using (StringWriter nameWriter = new StringWriter(CultureInfo.InvariantCulture)) {
				objectName.WriteTo(new SqlWriter(nameWriter, writer.Engine, SqlWriterMode.NoComments));
				new StringLiteral(nameWriter.ToString(), unicodeObjectName, null).WriteTo(writer);
			}
			if (objectType != null) {
				writer.Write(", ");
				objectType.WriteTo(writer);
			}
			writer.Write(')');
		}
Пример #7
0
		protected internal override void WriteToInternal(SqlWriter writer, bool isPartOfQualifiedName) {
			writer.WriteFunction(Value);
		}