如何在sqlserver 2008中插入默认值

本文介绍了如何在sqlserver 2008中插入默认值的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

嗨...... 请给我快速答案yar .........

hi...... plz give me fast answer yar........

推荐答案

定义列时，可以为每个列设置默认值. 如果随后从SQL INSERT 语句中忽略该列，则将应用默认值. 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.

1)没有人会给出快速"的答案.人们在看到您的信息时会回答. 2)避免在全球论坛上使用"yaar"之类的词.您注定会被淘汰. 3)在发布问题之前，请务必先在互联网上进行搜索. 您将获得大量的问题链接.我想出了此 [ ^ ]作为第一个答案. 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.