如何在SQL Server2005中创建选择，插入，更新，删除查询 [英] how to create select, insert ,update,delete query in sql server2005

问题描述

当创建多个表时如何在sql server2005中创建选择，插入，更新，删除查询

how to create select, insert ,update,delete query in sql server2005 when more than 1 table created

推荐答案

在这里:
选择 [删除 [更新 [插入 [

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:

这篇关于如何在SQL Server2005中创建选择，插入，更新，删除查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！