ǡѺ query sql server ФѺ USE [shop] GO SELECT [Mem_ID], [User Name], [Password], [Mem_Name], [Mem_Las

Posted torn 29 November 2013 - 5:37 PM
ǡѺ query sql server ФѺ USE [shop] GO SELECT [Mem_ID], [User Name], [Password], [Mem_Name], [Mem_Lastname ], [Mem_Age], [Mem_Address], [Mem_City], [Mem_Post], [Mem_Num], [Mem_Phone], [Mem_Email] FROM [dbo]. [T_Member] GO StringBuilder Ѻ query ҧѹ (ص Թ ФѺ ʹ ѹçѹ) StringBuilder sb = new StringBuilder (); sb.AppendLine ("INSERT INTO [shop]. [dbo ]. [T_Member] "); sb.AppendLine (" ([User-Name] "); sb.AppendLine (" [Password] "); sb.AppendLine (" [Mem_Name] "); sb.AppendLine (" [Mem_Lastname] "); sb.AppendLine (" [Mem_Age] "); sb.AppendLine (" [Mem_Address] "); sb.AppendLine (" [Mem_City] "); sb.AppendLine (" [Mem_Post ] "); sb.AppendLine (" [Mem_Num] "); sb.AppendLine (" [Mem_Phone] "); sb.AppendLine torn (" [Mem_Email]) "); sb.AppendLine (" value "); sb.AppendLine ("(@ UserName"); sb.AppendLine ("@ Password"); sb.AppendLine ("@ Mem_Name"); sb.AppendLine ("@ Mem_Lastname"); sb.AppendLine (" @ Mem_Age "); torn sb.AppendLine (" @ Mem_Address "); sb.AppendLine (" @ Mem_City "); sb.AppendLine (" @ Mem_Post "); sb.AppendLine (" @ Mem_Num "); sb . AppendLine ("@ Mem_Phone");