Goodspeed

摘要： DECLARE @a table(i int)DECLARE @b table(i int)INSERT INTO @a SELECT 1 UNION ALL SELECT 2INSERT INTO @b SELECT 1 UNION ALL SELECT 3SELECT a.i,b.i FROM @a AS a INNER JOIN @b AS b ON a.i =b.iSELECT a.i,... 阅读全文

摘要： SQL语句导入导出大全 /******* 导出到excel EXEC master..xp_cmdshell ’bcp SettleDB.dbo.shanghu out c:\temp1.xls -c -q -S"GNETDATA/GNETDATA" -U"sa" -P""’ /*********** 导入Excel SELECT * FROM OpenDataSource( ’Micro... 阅读全文