๐Ÿš€ go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: chile.comp.programacion
Article #3522

Re: Consulta SQL

#3522
From: illkufe
Date: Mon, 07 Feb 2005 05:25
22 lines
1565 bytes
Herrynet escribi๏ฟฝ:
> Salu2
>  
> He estado googleando para saber si existe alguna forma de hacer que un 
> campo al crear una tabla esta sea de auto incremento, al igual como 
> sucede con mysql pero llevado a sql-server
>  
> ej: CREATE TABLE prueba (campo1 int not null *auto_increment*,campo2 text)
>  
> Esto lo quiero llevar a Sql-server....
> Cualquier ayuda se agradece de Antemano
>  
> ATTe
>  
> Herrynet
CREATE TABLE dbo.Prueba
	(
  	CampoAutoIncremento int NOT NULL IDENTITY (1, 1),
	CampoTextoPrueba varchar(50) NULL
	)

Espero te ayude
Technical Details
Message-ID: <cu9ie9$v2f$1@news1.nivel5.cl>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!newsread.com!news-xfer.newsread.com!news.glorb.com!nntp-server.pubsub.com!news1.nivel5.cl!not-for-mail
References: <cshee2$9dl$1@news1.nivel5.cl>

Show Full Headers
Complete Article Headers
X-Google-Thread: 1593cb,820b62b9f5b6ab97
X-Google-Attributes: gid1593cb,public
X-Google-Language: SPANISH,ASCII
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!newsread.com!news-xfer.newsread.com!news.glorb.com!nntp-server.pubsub.com!news1.nivel5.cl!not-for-mail
From: illkufe <enunezf@vtr.net>
Newsgroups: chile.comp.programacion
Subject: Re: Consulta SQL
Date: Mon, 07 Feb 2005 02:25:33 -0300
Organization: Varios
Lines: 22
Message-ID: <cu9ie9$v2f$1@news1.nivel5.cl>
References: <cshee2$9dl$1@news1.nivel5.cl>
NNTP-Posting-Host: pc-93-32-104-200.cm.vtr.net
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-Trace: news1.nivel5.cl 1107840265 31823 200.104.32.93 (8 Feb 2005 05:24:25 GMT)
X-Complaints-To: news@news1.nivel5.cl
NNTP-Posting-Date: Tue, 8 Feb 2005 05:24:25 +0000 (UTC)
User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913)
X-Accept-Language: es-es, es
In-Reply-To: <cshee2$9dl$1@news1.nivel5.cl>