SQL - 文章分类 - 只想做好

GridView 中，hypelink 添加参数的方法

摘要：<ItemTemplate> <asp:HyperLink runat="server" ID="hlkItemUrl" NavigateUrl='<%# "/pages/doctor/doctor.aspx?id="+Eval("DoctorId") %>' Text='<%# Bind("UserName") %>' Target="_self"></asp:HyperLink> 阅读全文

posted @ 2012-11-15 16:22 只想做好阅读(146) 评论(0) 推荐(0) 编辑

无法连接到 sql server

摘要：出现以下错误：请使用[sql server配置管理器]查看 sql server网络配置-->MSSQLSERVER的协议TCP/IP 是否启用！阅读全文

posted @ 2012-11-02 09:25 只想做好阅读(96) 评论(0) 推荐(0) 编辑

Update 两张表之间的数据

摘要：1.update t1set t1.c2 = t2.c2from t2 where t1.c1 = t2.c12.Update t1set t1.c2 = t2.c2from t1 inner join t2on t1.c1 = t2.c1 阅读全文

posted @ 2011-01-05 10:27 只想做好阅读(559) 评论(0) 推荐(0) 编辑

SqlParameter数组添加到SqlCommand中，CommandType.Text

摘要：protected void Button1_Click(object sender, EventArgs e) { string strSql="insert into Invoice_Rebate_Customer_L (FORM_ID,LINE_NO) values (@formNo,@lineNo)"; SqlParameter[] paras =new SqlParameter[2];... 阅读全文

posted @ 2009-06-03 15:15 只想做好阅读(3569) 评论(1) 推荐(1) 编辑

临时表，select into，insert into select 使用

摘要：SELECT [FORM_ID] ,identity(int,50,1) AS Line_No ,[BU] ,[WEBSITE] ,'Y' as [IS_ACTUAL_LINE] ,[CUSTOMER_TYPE] ,[CUSTOMER_GROUP] ,[CUSTOMER_NAME] ,[CUSTOMER_CODE] ,[REBATE_TYPE] ,[MODEL_VERSION] ,[PART_N... 阅读全文

posted @ 2009-06-02 14:36 只想做好阅读(726) 评论(0) 推荐(0) 编辑

.临时表 select into和insert into select

摘要：SELECT [FORM_ID] ,identity(int,50,1) AS Line_No ,[BU] ,[WEBSITE] ,'Y' as [IS_ACTUAL_LINE] ,[CUSTOMER_TYPE] ,[CUSTOMER_GROUP] ,[CUSTOMER_NAME] ,[CUSTOMER_CODE] ,[REBATE_TYPE] ,[MODEL_VERSION] ,[PART_N... 阅读全文

posted @ 2009-06-02 14:36 只想做好阅读(486) 评论(0) 推荐(0) 编辑

临时表 select into和insert into select

摘要：SELECT [FORM_ID] ,identity(int,50,1) AS Line_No ,[BU] ,[WEBSITE] ,'Y' as [IS_ACTUAL_LINE] ,[CUSTOMER_TYPE] ,[CUSTOMER_GROUP] ,[CUSTOMER_NAME] ,[CUSTOMER_CODE] ,[REBATE_TYPE] ,[MODEL_VERSION] ,[PART_N... 阅读全文

posted @ 2009-06-02 14:36 只想做好阅读(9092) 评论(0) 推荐(0) 编辑

SQL编程例2

摘要：set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[sp_Generate_Part_By_Flower_No] ( @form_no int ) as begin BEGIN TRANSACTION Part_BOM; --料號給號後執行 ---Generate Part declare @res... 阅读全文

posted @ 2008-11-14 07:56 只想做好阅读(124) 评论(0) 推荐(0) 编辑

SQL编程例1

摘要：select sno, l.file_content, l.desc_file_name, l.desc_file_name_link, l.modelname_file_name, l.modelname_file_name_link, l.model_name, l.station, l.factory, l.version, convert(decimal (5,2), version... 阅读全文

posted @ 2008-11-14 07:54 只想做好阅读(112) 评论(0) 推荐(0) 编辑

学无止境

------

文章分类 - SQL