文章分类 -  数据库技术

常用两种复制表数据SQL语句
摘要：--创建表,并复制数据到新建表中去 select * into aaa from [Table] --向表中插入数据 insert into aaa select * from [Table] 阅读全文

posted @ 2008-09-25 14:44 无忧浪子 阅读(8209) 评论(0) 推荐(1)

删除指定表的数据
摘要：--删除所有指定表中的数据 declare @sqlcmd varchar(8000) set @sqlcmd = '' select @sqlcmd = @sqlcmd + 'delete from ' + name+ char(10) from sysobjects where type='U' and name like 'A%' p... 阅读全文

posted @ 2007-11-20 15:15 无忧浪子 阅读(285) 评论(0) 推荐(0)

FROM 指定在 DELETE、SELECT 和 UPDATE 语句中使用的表、视图、派生表和连接表。
摘要：语法 [ FROM { } [ ,...n ] ] ::= table_name [ [ AS ] table_alias ] [ WITH ( [ ,...n ] ) ] | view_name [ [ AS ] table_alias ] [ WITH ( [ ,...n ] ) ] | rowset_function [ [ AS ] table_alias ] ... 阅读全文

posted @ 2007-04-19 14:24 无忧浪子 阅读(3552) 评论(0) 推荐(0)

导航