Click here to Skip to main content
14,775,690 members
Home » Discussions » Database
   

Database

 
GeneralRe: Visual Studio Database Projects and General Use Pin
cjb11019-Oct-16 21:56
Membercjb11019-Oct-16 21:56 
GeneralRe: Visual Studio Database Projects and General Use Pin
Matt U.20-Oct-16 6:01
MemberMatt U.20-Oct-16 6:01 
SuggestionIncrease the Execution time or Connection Time out property of SSIS package from C# code Pin
indian14312-Oct-16 14:40
Memberindian14312-Oct-16 14:40 
QuestionTo run a SSIS package outside of SQL server data tools you must install populate filecollection of integration services or higher Pin
indian14310-Oct-16 7:39
Memberindian14310-Oct-16 7:39 
AnswerRe: To run a SSIS package outside of SQL server data tools you must install populate filecollection of integration services or higher - resolved Pin
indian14312-Oct-16 13:58
Memberindian14312-Oct-16 13:58 
QuestionExport Access db to Sql Server db everyday Pin
meeram396-Oct-16 16:09
professionalmeeram396-Oct-16 16:09 
AnswerRe: Export Access db to Sql Server db everyday Pin
Eddy Vluggen10-Oct-16 7:58
professionalEddy Vluggen10-Oct-16 7:58 
QuestionIdentity_Column Pin
Member 111616253-Oct-16 20:43
MemberMember 111616253-Oct-16 20:43 
Hi,

I am getting the following error,while creating identity column in sql ???

This is the code:

Create Table Myschema.Employee_Demo
(
Emp_ID int constraint pk_con Primary Key Identity(1,1),
Emp_Name varchar(55),
Emp_Sal decimal(10,2)
)
Insert Myschema.Employee_Demo(Emp_Name,Emp_Sal)values('Puja',20,000),('Tira',10,000),('Serrma',15,000),('Airrwari',12,000),('Shyyjina',13,000)

ERROR:

Msg 110, Level 15, State 1, Line 1

There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.

SO,

how to solve this error???Please help.......

Thanks...

AnswerRe: Identity_Column Pin
Chris Quinn4-Oct-16 0:11
MemberChris Quinn4-Oct-16 0:11 
AnswerRe: Identity_Column Pin
Swinkaran4-Oct-16 2:17
professionalSwinkaran4-Oct-16 2:17 
QuestionSQL Server Reporting Services Query to Get Stored Procedure Name for Shared Dataset Pin
David_4129-Sep-16 12:48
MemberDavid_4129-Sep-16 12:48 
AnswerRe: SQL Server Reporting Services Query to Get Stored Procedure Name for Shared Dataset Pin
Mycroft Holmes29-Sep-16 13:43
professionalMycroft Holmes29-Sep-16 13:43 
GeneralRe: SQL Server Reporting Services Query to Get Stored Procedure Name for Shared Dataset Pin
David_4129-Sep-16 13:51
MemberDavid_4129-Sep-16 13:51 
QuestionExecuting SSIS Package from C# Console App Pin
indian14328-Sep-16 5:51
Memberindian14328-Sep-16 5:51 
AnswerRe: Executing SSIS Package from C# Console App - resolved Pin
indian14328-Sep-16 13:09
Memberindian14328-Sep-16 13:09 
Question.mdb file problem Pin
Member 1275753624-Sep-16 7:19
MemberMember 1275753624-Sep-16 7:19 
AnswerRe: .mdb file problem Pin
Mycroft Holmes24-Sep-16 15:49
professionalMycroft Holmes24-Sep-16 15:49 
GeneralRe: .mdb file problem Pin
Richard Deeming26-Sep-16 3:12
mveRichard Deeming26-Sep-16 3:12 
GeneralRe: .mdb file problem Pin
Mycroft Holmes26-Sep-16 13:33
professionalMycroft Holmes26-Sep-16 13:33 
AnswerRe: .mdb file problem Pin
Victor Nijegorodov25-Sep-16 4:31
MemberVictor Nijegorodov25-Sep-16 4:31 
QuestionHow to update Oracle DB from SQL server through link server? Pin
hmanhha22-Sep-16 21:20
Memberhmanhha22-Sep-16 21:20 
AnswerRe: How to update Oracle DB from SQL server through link server? Pin
Richard MacCutchan22-Sep-16 21:53
mveRichard MacCutchan22-Sep-16 21:53 
GeneralRe: How to update Oracle DB from SQL server through link server? Pin
hmanhha22-Sep-16 22:28
Memberhmanhha22-Sep-16 22:28 
GeneralRe: How to update Oracle DB from SQL server through link server? Pin
Richard MacCutchan22-Sep-16 22:30
mveRichard MacCutchan22-Sep-16 22:30 
GeneralRe: How to update Oracle DB from SQL server through link server? Pin
Mycroft Holmes22-Sep-16 22:33
professionalMycroft Holmes22-Sep-16 22:33 

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.