TechyGypo
Techy stuff I find out about in the world of computers and stuff like that...
SyntaxHighlighter
Wednesday, 19 December 2012
Insert Into a Table With Only One Identity Column
If you have a table that as only one column and that column is an identity column, then in order to
INSERT
into it, you need to use this statement:
INSERT INTO [MyTable] DEFAULT VALUES
This works in SQL Server 2008 and I haven't tested in earlier versions.
In SQL Server 2012, we have the introduction of a
SEQUENCE
. You could consider using one of those as an alternative.
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Blog Archive
►
2017
(2)
►
October
(1)
►
January
(1)
►
2016
(1)
►
December
(1)
►
2015
(4)
►
November
(1)
►
August
(1)
►
July
(1)
►
April
(1)
►
2014
(6)
►
October
(1)
►
August
(2)
►
March
(3)
►
2013
(6)
►
September
(1)
►
August
(1)
►
April
(2)
►
January
(2)
▼
2012
(36)
▼
December
(5)
How To Schedule Sending an Email with GMail
MSSQL: Create an Audit Structure in SQL Server
Insert Into a Table With Only One Identity Column
UTF8 / Unicoding Body of PHP PEAR Email
A Project With the Name ScriptComponent Already Ex...
►
November
(2)
►
October
(5)
►
August
(2)
►
July
(1)
►
June
(4)
►
May
(8)
►
April
(3)
►
March
(3)
►
February
(1)
►
January
(2)
►
2011
(41)
►
December
(1)
►
November
(1)
►
October
(4)
►
September
(2)
►
August
(6)
►
July
(3)
►
June
(7)
►
May
(1)
►
April
(4)
►
March
(2)
►
February
(3)
►
January
(7)
►
2010
(19)
►
December
(4)
►
November
(7)
►
October
(1)
►
August
(7)
Labels
.net
(7)
ajax
(1)
android
(7)
apache
(1)
asp.net
(3)
asus
(2)
blogger
(2)
blogspot
(3)
c#
(16)
compact framework
(2)
cron
(1)
css
(1)
data
(1)
data recovery
(2)
dns
(1)
eclipse
(1)
encryption
(1)
excel
(1)
font
(1)
ftp
(1)
gmail
(5)
google
(4)
gopro
(1)
html
(1)
iis
(3)
internet explorer IE
(1)
iphone
(1)
javascript
(3)
kinect
(1)
linux
(1)
macro
(1)
mail
(9)
mercurial
(1)
microsoft
(3)
microsoft office
(3)
monitoring
(1)
mootools
(1)
ms access
(1)
mssql
(13)
mysql
(2)
open source
(1)
openvpn
(1)
pear
(2)
permissions
(1)
php
(12)
plesk
(4)
proxy
(1)
qr codes
(1)
rant
(4)
reflection
(3)
regex
(1)
replication
(1)
reporting services
(5)
security
(2)
signalr
(1)
sql
(11)
sqlce
(1)
sqlexpress
(1)
ssis
(1)
ssl
(1)
stuff
(1)
svn
(2)
syntax
(1)
tablet
(2)
telnet
(3)
tools
(1)
twitter
(1)
unix
(3)
vb script
(3)
vb.net
(9)
vba
(1)
visual studio
(2)
vpc
(2)
vpn
(1)
windows
(4)
woff
(1)
xbox 360
(1)
No comments:
Post a Comment