擅长:python、mysql、java
<p>以下语法适用于SQLServer2008,但不适用于SQLServer2005。在</p>
<pre><code>CREATE TABLE Temp (id int, name varchar(10));
INSERT INTO Temp (id, name) VALUES (1, 'Anil'), (2, 'Ankur'), (3, 'Arjun');
SELECT * FROM Temp;
id | name
1 | Anil
2 | Ankur
3 | Arjun
</code></pre>