Click here to Skip to main content
15,917,320 members
Home / Discussions / Database
   

Database

 
AnswerRe: SQLBulkCopy with ODBC Pin
Wendelius30-Oct-08 8:10
mentorWendelius30-Oct-08 8:10 
QuestionExtract number from string Pin
kyi kyi29-Oct-08 15:36
kyi kyi29-Oct-08 15:36 
AnswerRe: Extract number from string Pin
Meysam Mahfouzi29-Oct-08 17:26
Meysam Mahfouzi29-Oct-08 17:26 
GeneralRe: Extract number from string Pin
kyi kyi29-Oct-08 18:06
kyi kyi29-Oct-08 18:06 
GeneralRe: Extract number from string Pin
Meysam Mahfouzi29-Oct-08 20:02
Meysam Mahfouzi29-Oct-08 20:02 
QuestionUsing SQL as categorized tagging backend Pin
jchalfant29-Oct-08 4:36
jchalfant29-Oct-08 4:36 
AnswerRe: Using SQL as categorized tagging backend Pin
Wendelius29-Oct-08 8:12
mentorWendelius29-Oct-08 8:12 
GeneralRe: Using SQL as categorized tagging backend Pin
jchalfant29-Oct-08 8:37
jchalfant29-Oct-08 8:37 
GeneralRe: Using SQL as categorized tagging backend Pin
Wendelius29-Oct-08 8:53
mentorWendelius29-Oct-08 8:53 
AnswerRe: Using SQL as categorized tagging backend Pin
Ashfield29-Oct-08 9:53
Ashfield29-Oct-08 9:53 
GeneralRe: Using SQL as categorized tagging backend Pin
Wendelius3-Nov-08 9:19
mentorWendelius3-Nov-08 9:19 
QuestionAlternative to SOUNDEX? Pin
Richard Jones29-Oct-08 3:54
Richard Jones29-Oct-08 3:54 
AnswerRe: Alternative to SOUNDEX? Pin
Wendelius29-Oct-08 8:05
mentorWendelius29-Oct-08 8:05 
GeneralRe: Alternative to SOUNDEX? Pin
Richard Jones29-Oct-08 9:15
Richard Jones29-Oct-08 9:15 
GeneralRe: Alternative to SOUNDEX? Pin
Wendelius29-Oct-08 9:36
mentorWendelius29-Oct-08 9:36 
GeneralRe: Alternative to SOUNDEX? Pin
Richard Jones29-Oct-08 9:40
Richard Jones29-Oct-08 9:40 
GeneralRe: Alternative to SOUNDEX? Pin
ChandraRam30-Oct-08 1:23
ChandraRam30-Oct-08 1:23 
QuestionSSIS - Multiple packages using the same sharepoint path Pin
notes4we29-Oct-08 3:03
notes4we29-Oct-08 3:03 
Questionhow to get in report watermark text Pin
imranafsari28-Oct-08 23:56
imranafsari28-Oct-08 23:56 
QuestionEmbedded Fire Bird - Programmatically creating a new database [solved] Pin
Harvey Saayman28-Oct-08 23:54
Harvey Saayman28-Oct-08 23:54 
Questionincrement number Pin
susanhalim28-Oct-08 21:35
susanhalim28-Oct-08 21:35 
AnswerRe: increment number Pin
notes4we29-Oct-08 3:09
notes4we29-Oct-08 3:09 
In SQL Server Management Studio (SSMS), in the Object Explorer, connect to your Database Engine, Databases, Expand your Database Name, Expand Tables, Right - click the Table Name in which you wish to have the increment number and select Modify from the context menu.

You will see the column names in that particular table.

Just select the column where you want the increment number and in the bottom in the Column Properties window, Expand Identity Specification. In the (Is Identity) from the drop down list select Yes and you will see the Identity Increment as 1 by default. That is what you need. If you wish you can change it also to 2 or some other number as you wish.

Hope this helps.
I was to descriptive to answer this simple question, but I am not sure how much do you know about it, so I thought of starting from the scratch.

Good Luck.
AnswerRe: increment number Pin
PIEBALDconsult29-Oct-08 5:05
mvePIEBALDconsult29-Oct-08 5:05 
AnswerRe: increment number Pin
mahsa shahi1-Mar-14 7:09
mahsa shahi1-Mar-14 7:09 
Questioncategory tree like structure in sql Pin
S.Dhanasekaran28-Oct-08 21:13
S.Dhanasekaran28-Oct-08 21:13 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.