Exec master..xp_cmdshell 'bcp "Select * From CarManage..T_Car Where T_Car.Mark = ''^'' " queryout D:\DataBase\Export\Car.sql -c -S server -U sa -P '
Exec master..xp_cmdshell 'bcp "Select * From CarManage..T_Car Where T_Car.Mark = ''^'' " queryout D:\DataBase\Export\Car.sql -c -S server -U sa -P '
为什么要用两个单引号呢?上面的语句是SQL语句呀!