SQL题
wyklis
这个作者很懒,什么都没留下…
展开
-
T-SQL面试题(补充中~)
1.Write one T-SQL script to get employees with the top 10 in salary amount and whose name is started with character ‘L’ (for example Liu, Li…) from the employee table. (Employee table includes “ID”, “name”, and “Salary” columns)SELECT TOP(10) ID, Name, Sal原创 2010-09-10 21:50:00 · 675 阅读 · 0 评论 -
SQL Server 2008 插入多行数据
SQL Server 2005 插入2行INSERT dbo.UserTable(UserName) VALUES ('Fred')INSERT dbo.UserTable(UserName) VALUES ('Barney')SQL Server 2008 插入2行INSERT dbo.UserTable(UserName) VALUES ('Fred'),('Barney')原创 2010-09-16 21:07:00 · 985 阅读 · 0 评论