SQLserverÉú³Éinsert into´øÊý¾Ý½Å±¾.
ÓÐʲô¹¤¾ß¿ÉÒÔ°ÑsqlserverµÄÊý¾ÝÉú³Éinsert intoµÄ½Å±¾?ÏñmysqlÄÇÑùµ¼³ö.sqlÎļþ.
mssqlÖ»¿ÉÒÔÉú³É±í½á¹¹µÄsqlÎļþ.²»´øÊý¾ÝµÄ.
Èç¹û±íÉٵĻ°
×Ô¼ºÆ´°É
Â¥Ö÷˵µÄÊÇÒª°ÑÊý¾Ý¿âÄÚµÄÒѲåÈëµÄÊý¾ÝתΪSQL½Å±¾?
SQL×Ô´øµÄ¹¤¾ß¿ÉÒÔÉú³É±í½á¹¹ÐÅÏ¢½Å±¾.
SQL code:
****************************************************************************
Èí¼þÃû³Æ: May Flower Erp
°æȨËùÓÐ: (C) 2005-2006 May Flower ERP ¿ª·¢×é
¹¦ÄÜÃèÊö: »ñÈ¡Ö¸¶¨±íµÄ´´½¨½Å±¾,°üÀ¨±íºÍ×ֶεÄÊôÐÔ¡¢Íâ¼ü(×¢Ê͵ôµÄ)
----------------------------------------------------------------------------
²ÎÊýÁбí:
1: @TableName ÐèÒª´´½¨½Å±¾µÄ±íµÄÃû³Æ
****************************************************************************
|</PRE>*/
CREATE PROCEDURE [dbo].[sp_HelpTable](@TableName sysname)
AS
SET NOCOUNT ON
DECLARE @ObjectID int
DECLARE @TableScript table(Iden int IDENTITY(1, 1), ScriptLine nvarchar(4000))
SET @ObjectID = object_id(@TableName)
IF @ObjectID IS NULL OR OBJECTPROPERTY(@ObjectID, 'IsTable') = 0
BEGIN
RAISERROR('Ö¸¶¨µÄ¶ÔÏó²»ÊDZí¶ÔÏó', 16, 1)
RETURN
END
--»ñÈ¡±íµÄ´´½¨½Å±¾
--²åÈë±íÍ·
INSERT INTO @TableScript(ScriptLine)
SELECT N'CREATE TABLE [' + USER_NAME(OBJECTPROPERTY(@ObjectID, N'OwnerId')) + N'].[' + object_name(@ObjectID) + N']('
--²åÈë×Ö¶Î
INSERT INTO @TableScript(ScriptLine)
SELECT N'
Ïà¹ØÎÊ´ð£º
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥ÁË°¡£¿
......
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......
ÓÐÈËÊÔ¹ýÔÚwin7ÉÏ°²×°sqlserverÂð£¿
Ìý˵sql2000×°²»ÉÏÈ¥£¬²»ÖªµÀÆäËû°æ±¾Ðв»ÐС£
ºÃÏñ²»ÐÐ,²»¼æÈÝ,ÉÏ´ÎÒ²ÓÐÈËÎʹýѽ
ºÇºÇ£¬ÓÐÍøÓÑÓÐÏà¹ØµÄ¾ÑéÂð£¿
Õâ¸ösqlserverÒª¾¡Á¿×°ÔÚwin7ÉÏ¡£
SQLSERVER 2000Ã ......
sqlserverÖж¨Òå×Ö¶Îʱ£¬ÓбêʶÖÖ×Ó¡¢±êʶºÍ¹«Ê½µÈ£¬ÊÇʲôÒâ˼£¿
Ó¦¸Ã˵µÄÊÇidentity°É
identity?ɶÒâ˼£¿
IDENTITY£¨º¯Êý£©
Ö»ÓÃÔÚ´øÓÐ INTO table ×Ó¾äµÄ SELECT Óï¾äÖУ¬ÒÔ½«±êʶÁвåÈ뵽бíÖС£
¾¡¹ ......
ÈçÌâËùʾ
СµÜʹÓÃDelphi7»·¾³½øÐÐÊý¾Ý²É¼¯£¬²É¼¯µ½µÄÊý¾Ý·ÅÈëSQL Server2000Êý¾Ý¿âÖУ¬µ«ÊÇÏë²»°²×°SQLServer2000À´ÊµÏÖ´ÓÆäËü¼ÆËã»úÉÏÔËÐд˳ÌÐò£¬²»ÖªÈçºÎʵÏÖ£¿Íû¸÷λ´óϺ¸æÖªÒ»¶þ¡£
ÁíÍ⣬ÏÖÔÚСµÜÓöµ½ÁËÒ»¸ö ......