且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在SQL Server2005中创建选择,插入,更新,删除查询

更新时间:2022-11-26 20:11:20

在这里:
选择 [删除 [更新 [插入 [
Here you go:
SELECT[^]
DELETE[^]
UPDATE[^]
INSERT[^]

They are same for SQLServer 2005 & SQLServer 2008.


每个SQL命令都包含表源,因此您只需要引用它即可:
Each SQL command contains the table source, so you just have to refer to it:
SELECT <fields> FROM <tablename> WHERE <condition>


例如:


E.g.:

SELECT id, name FROM myTable WHERE name='John Smith'



如果您需要SQL命令的语法,那么 W3Schools [



If you need the syntax for SQL commands, a good place to start is W3Schools[^]


通过以下链接.. ,这里还有您想要的

http://java2s.com/Code/SQLServer/CatalogSQLServer.htm [
Go through the below link .., Here more that you want

http://java2s.com/Code/SQLServer/CatalogSQLServer.htm[^]

Try in Google Before Posting a Question Here.:rose::rose: