sql server 2008 -在表中提取通配符

Question

我想提取产品表中product以字母N开头的所有记录，并将其保存在名为"List of N - Products"的表中

我试过Select * from product where PRODUCTS like = 'N%' ;

Answer 1

您可以像这样做一个简单的INSERT语句:

--Assuming all the column names are same in both tables
INSERT INTO [ListOfN-Products] 
SELECT p.*
FROM Product p
WHERE p.PRODUCTS like 'N%'

另外，就像@Damien_The_Unbeliever建议的那样，为什么不创建一个视图而不是一个表呢?与表不同，当新记录插入到底层表中时，视图会自动更新。

CREATE VIEW [ListOfN-Products]
AS
SELECT p.*
FROM Product p
WHERE p.PRODUCTS LIKE 'N%'

Answer 2

试试这个

  SELECT e.col
  INTO [ListofN-Products]
  FROM yourTable e
  WHERE e.col LIKE 'N%'
  SELECT * 
  FROM [ListofN-Products]

希望它能帮助你!