Sounds as if the issue is with code. Specifically TSQL. Here's some. Copy and paste into SSMSE. In the case of data file, create it and make sure you've got a complete path to it (alter the path to it below before running the TSQL).
The only way to get help here in QA is to post code. Post errors when it's run; speculate on the origin of that error. Provide useful thoughts. Etc.
USE [cpqaAnswers]
GO
--CREATE SCHEMA [cpqa]
CREATE TABLE [cpqaAnswers].[cpqa].[tbl_ST_TShirt]
(
[Style] nvarchar(200),
[Description] nvarchar(300),
[Size] nvarchar(19),
[Color] nvarchar(11),
[Fabric] nvarchar(24),
[Comments] nvarchar(79),
[Price] float
)
SELECT * FROM [cpqaAnswers].[cpqa].[tbl_ST_TShirt]
INSERT INTO [cpqaAnswers].[cpqa].[tbl_ST_TShirt]
([Style],
[Description],
[Size],
[Color],
[Fabric],
[Comments],
[Price])
VALUES('crew','heavyduty','M','RED','cotton','autumnwear',29.99)
SELECT * FROM [cpqaAnswers].[cpqa].[tbl_ST_TShirt]
/*
Are not the "attributes of which you speak references to the fields in the
table?
*/
INSERT INTO [cpqaAnswers].[cpqa].[tbl_ST_TShirt]
([Style],
[Description],
[Size],
[Color],
[Fabric],
[Comments],
[Price])
VALUES('frilled','lightweight','S','BLUE','polyester','summerwear',39.55)
SELECT * FROM [cpqaAnswers].[cpqa].[tbl_ST_TShirt]
Content of bulkinsertData.txt:
crew mediumweight L GREEN cotton yearround 44.45
crew mediumweight L RED cotton yearround 44.45
crew lightweight L WHITE cotton yearroiund 44.45
BULK INSERT [cpqaAnswers].[cpqa].[tbl_ST_TShirt] FROM bulkinsertData.txt'
SELECT * FROM [cpqaAnswers].[cpqa].[tbl_ST_TShirt]
/*
crew heavyduty M RED cotton autumnwear 29.99
frilled lightweight S BLUE polyester summerwear 39.55
crew mediumweight L GREEN cotton yearround 44.45
crew mediumweight L RED cotton yearround 44.45
crew lightweight L WHITE cotton yearroiund 44.45
*/
SELECT [Style],[Color],[Price] FROM [cpqaAnswers].[cpqa].[tbl_ST_TShirt] WHERE [Price]=44.45
/*
crew GREEN 44.45
crew RED 44.45
crew WHITE 44.45
*/
Submit an article or tip