Click here to Skip to main content
15,889,462 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
hi......
plz give me fast answer yar........
Posted

When you define the columns, you can set a default value for each.
If you then omit that column from the SQL INSERT statement, the default value will be applied.
 
Share this answer
 
1) No one is going to give a 'fast' answer. People will answer as and when they see your post.

2) Avoiding using words like 'yaar' on a global forum. You are bound to get downvoted.

3) Always search on the internet before posting a question.
You will get tons of links for your question. I came up with this[^] as the first answer.
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900