UPDATE c SET Tot_Dst = ( SELECT SUM(TableA.Dst) FROM TableA a WHERE a.TrpM="OCT" AND a.VehN = c.VehN ) FROM TableC c WHERE c.VehN in (SELECT VehN from TableB)
<textarea type="text" name="translatetext" style="width: 600px; height:250px;"/>Da followin procedure raps bout tha steps used ta bust data ta a server n' sh*t. This procedure is commonly used ta post data ta a Web page.translate=Tranzizzle Dis Shiznit</textarea>
[KNW][0-9].* A[A-GI-K].* [KNW][A-FI-KM-OQ-Z].* KP[06-9].* KG[0-35-9].* KG4[A-Z] KG4[A-Z][A-Z][A-Z]
var cs = from c in xml.Root.Elements("Countries001").Elements("item") let exp = c.Attribute("PrefixList").Value let re = new Regex(string.Format("^{0}$", exp.Replace("|","$|^")), RegexOptions.IgnoreCase) where re.IsMatch("VP8VPC") select c.Attribute("Country").Value;
var xml = XDocument.Load(@"http://www.hrdsoftwarellc.com/hrdxmlcountries/LogbookCountryDataEx.xml"); var cs = from c in xml.Root.Elements("Countries001").Elements("item") let re = new Regex(string.Format("^{0}$",c.Attribute("PrefixList").Value), RegexOptions.IgnoreCase) where re.IsMatch("OZ1BV") select c.Attribute("Country").Value; cs.Dump();
var z = new int[x.Length + y.Length]; x.CopyTo(z, 0); y.CopyTo(z, x.Length);
return View(Samples);
public static bool isFloatValue(string text) { Regex regex = new Regex(@"^\d*\.?\d?$"); return regex.IsMatch(text); } void Main() { Console.WriteLine(isFloatValue("12.5")); Console.WriteLine(isFloatValue("12.5.")); Console.WriteLine(isFloatValue("12")); Console.WriteLine(isFloatValue(".1")); Console.WriteLine(isFloatValue("12.")); }
True False True True True
srno
include
CREATE TYPE dbo.dtExcel AS TABLE ( nameCustomer NVARCHAR(50), nameItem NVARCHAR(50) ); GO CREATE TABLE Customers ( nameCustomer NVARCHAR(50), ) GO CREATE PROCEDURE dbo.InsertMyDataTable @dt AS dbo.dtExcel READONLY AS BEGIN SET NOCOUNT ON; insert into Customers (nameCustomer) select DISTINCT nameCustomer from @dt as dt where NOT EXISTS (select nameCustomer from Customers where Customers.nameCustomer=dt.nameCustomer) END GO