10.×Ö·û´®Á¬½Ó
SET @m_sql = @m_sql + ' Where F001 = ''' + @F001 + ''''
SET @m_sql = @m_sql + ' F002 = ' + CONVERT(varchar,@F002)
        11.´´½¨ÁÙʱ±í´æ´¢ÍⲿÊý¾Ý±í
        ˵Ã÷:ÁÙʱ¹ý³ÌÓà # ºÍ ## ÃüÃû£¬¿ÉÒÔÓÉÈκÎÓû§´´½¨¡£´´½¨¹ý³Ìºó£¬¾Ö²¿¹ý³ÌµÄËùÓÐÕßÊÇΨһ¿ÉÒÔʹÓøùý³ÌµÄÓû§¡£
CREATE TABLE #DMPARHED
(FMCD   int,
FMNAM  varchar(50),
MGYO1  smallint,
constraint DMPARHED_P primary key (FMCD))
SET @aSQL = ''
SET @aSQL = @aSQL + 'INSERT INTO #DMPARHED'
SET @aSQL = @aSQL + ' SELECT FMCD,FMNAM,MGYO1 FROM'
SET @aSQL = @aSQL + ' OPENQUERY(Lk_MDB_NEO32, ''SELECT FMCD,FMNAM,MGYO1 FROM DMPARHED'
SET @aSQL = @aSQL + ' WHERE SYSNO = 1'')'
execute(@aSQL)

        ´´½¨ÁÙʱ±íµÄÁíÀà·½·¨£º
select a.name,a.password from
with
as temp1
select * from emp
(select * from temp1
union
select * from temp1) a
where a.name='hao'; 
        12.´æ´¢¹ý³ÌµÄµ÷Óü°·µ»ØÖµ
£¨1£©´æ´¢¹ý³ÌµÄÉùÃ÷
CREATE PROCEDURE name_produce
    @F001  VARCHAR(20),
           @F002  SMALLINT OUTPUT£¨2£©VB.NETµ÷Óô洢¹ý³Ì
Private SqlCmd As New OleDb.OleDbCommand

SqlCmd.CommandText = "prNK3020SC03"
SqlCmd.CommandType = CommandType.StoredProcedure

Dim parampre1 As OleDb.OleDbParameter = SqlCmd.Parameters.Add( _
         New OleDb.OleDbParameter("@F001", OleDb.OleDbType.VarChar, 20, _
          ParameterDirection.Input))
Dim parampre2 As OleDb.OleDbParameter = SqlCmd.Parameters.Add( _
         New OleDb.OleDbParameter("@F002", OleDb.OleDbType.SmallInt))
parampre2.Direction = ParameterDirection.Output

SqlCmd.Parameters("@F001").Value = aF001
SqlCmd.Parameters("@F002").Value = aF002
SqlCmd.ExecuteNonQuery()
aF002 = SqlCmd.Parameters("@F002").Value.ToString()
£¨3£©´æ´¢¹ý³Ìµ÷Óô洢¹ý³Ì
DECLARE @C001       VARCHAR(20),
              @C002       SMALLINT
EXEC name_produce @C001,@C002 output

CREATE PROCEDURE dbo.getUserName
@UserID int,
@UserName varchar(40) output
as
set nocount on
begin
if @UserID is null return
select @UserName=username
from dbo.[userinfo]
where userid=@UserID
return
end

        13.UpdateÓï¾ä³£¼û´íÎó×ܽá
--¡Ì
Update name_table set
        F001 = @F181,
        F002 = @F182
Where
        F003 = @F003
--¡Á
Update name_table
        F001 = @F181,
        F002 = @F182
Where
        F003 = @F003
--¡Á
Update name_table set
        F001 = @F181,
        F002 = @F182,
Where
        F003 = @F003
--¡Á
Update name_table set
        ,F001 = @F181
        ,F002 = @F182
Where
        F003 = @F003
        14.InsertÓï¾ä³£¼ûÓï·¨´íÎó×ܽá

--¡Ì
INSERT INTO name_table(
,KEY_FIELD£¬BUSYOCD
)Values(
@F001,@F002
)
--¡Á
INSERT INTO name_table(
F001,F002
)Values(
,@F001,@F002
)
--¡Á
INSERT INTO name_table(
F001,F002
)Values(
@F001,@F002,
)
--¡Á
INSERT   name_table(
F001,F002
)Values(
@F001,@F002
)