sql²Ù×÷
ÅжÏÁ¬½ÓÊý¾Ý¿â״̬£º
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@ Import Namespace= "System.Data.SqlClient" %>
<mce:script runat = "server"><!--
protected void Page_Load(object sender, EventArgs e)
{
var cn = new SqlConnection();
cn.ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|product_Data.MDF;Integrated Security=True;User Instance= True";
cn.Open();
if (cn.State == System.Data.ConnectionState.Open)
{
Response.Write("SQLÁ¬½Ó¿ªÆô");
cn.Close();
}
if (cn.State == System.Data.ConnectionState.Closed)
{
Response.Write("SQLÁ¬½Ó¹Ø±Õ");
}
}
// --></mce:script>
Ö´ÐвåÈëSqlÓï¾ä£¬´úÂëÈçÏ£º
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@ Import Namespace= "System.Data.SqlClient" %>
<mce:script runat = "server"><!--
protected void Page_Load(object sender, EventArgs e)
{
var cn = new SqlConnection();
cn.ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|product_Data.MDF;Integrated Security=True;User Instance= True";
var cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandText = "INSERT Produce(ProductID,ProductName,Price) VALUES(155,'apple',125)";
cn.Open();
var records = cmd.ExecuteNonQuery();
cn.Close();
Response.Write("ÐÂÔöÁË"+records.ToString()+"ÌõÊý¾Ý");
}
// --></mce:script>
¸üÐÂÊý¾Ý¿âÓï¾ä£º
<%@ Pa
Ïà¹ØÎĵµ£º
ͬʱÆô¶¯ÆäËûsql ·þÎñ»á³öÏÖ ´íÎó1068:ÒÀ´æ·þÎñ»ò×éÎÞ·¨Æô¶¯£¨ÕâÊÇÓÉÓÚ¼¸¸öÏà¹ØÁªµÄ·þÎñÖÐÓÐÒ»¸ö²»ÄÜÆô¶¯£©¡£
´íÎó1069ÊÇÒ»¸öWindows NT/2000µÄϵͳ´íÎó¡£´íÎó1069±íÃ÷·þÎñ²»Äܱ»Æô¶¯£¨µ±Æô¶¯·þÎñʱ·µ»Ø“µÇ¼ʧ°Ü”´íÎ󣩡£ÀýÈ磬µ±Æô¶¯MSSQLServer·þÎñʱ£¬µÃµ½ÈçÏ´íÎóÌáʾ£º
·¢Éú´íÎó1069£ºÓÉÓڵǼʧ° ......
CREATE PROCEDURE fenye
@tblName varchar(255)='wdf1', -- ±íÃû
@strGetFields varchar(1000) = '*', -- ÐèÒª·µ»ØµÄÁÐ
@fldName varchar(255)='userid', -- ÅÅÐòµÄ×Ö¶ÎÃû
@PageSize int = 10, -- Ò³³ß´ç
@PageIndex int = 1, -- Ò³Âë
@doCount bit = 0, -- ·µ»Ø¼Ç¼×ÜÊý, ·Ç 0 ÖµÔò·µ»Ø
@OrderType bit = 0, -- Éè ......
ÔÚETL¹ý³ÌÖУ¬¾³£»áÅöµ½È¡½á¹û¼¯µÄ×îºó»ò×îÇ°Ò»Ìõ¼Ç¼¡£ÈçÈ¡»îÆÚ´æ¿îµÄµ±Ç°ÀûÂÊ£¬¿ª»§½ð¶î£¬Ð¶¨ÀûÂʵȡ£Èç¹û²»ÓÃLOOKUPµÄ·½Ê½£¬Èçͨ¹ýÓαêÈ¡»òÕßETL¹¤¾ßLOOKUP×é¼þʲôµÄ£¬ÔÚÒ»ÌõSQLÀïʵÏÖ£¬Ä¿Ç°ÊµÏÖÓм¸ÖÖ·½·¨¡£
1.ÒÔʱ¼ä»òÆäËû×ֶηÖ×éºóÔÚ×ÔÁ¬×Ô¼º£¬ÕâÑù²»½ö¿ÉÒÔ´ø³öÐèÒªLOOKUPµÄ×ֶΣ¬»¹¿ÉÒÔ´ø³öÆäËûÐèÒªµÄ×Ö ......
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER function [dbo].[Get_StrArrayStrOfIndex]
(
@str varchar(1024), --Òª·Ö¸îµÄ×Ö·û´®
@split varchar(10), --·Ö¸ô·ûºÅ
@index int --È¡µÚ¼¸¸öÔªËØ
)
returns varchar(1024)
as
begin
declare @location int
de ......