4
Answers

zeroes ommitted in the ID column

boycoto

boycoto

12y
2.1k
1
I have csv file that if I open it using EXCEL file, it ommitted the zeroes at the begginning of the text whereas if I am going to view using notepad, the ID is correct.  For example, the value of the ID is 000102233, if I am going to view it using Excel it displays as 112233, which is also the value that my program gets if I extract it from the csv file and store it to database. How am I going to deal with it?
Answers (4)
0
tejal bhesaniya
NA 53 13.2k 12y
SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[YourTable]') if it exist then it will display the result,,,with table name ,,,tpe and everything
0
Naresh Avari
NA 811 1.6m 12y
Select your database and open new query window and

EXEC sp_tables @table_type = "'table'"


0
Jignesh Trivedi
NA 61k 14.2m 12y
hi,

there are two tables sys.tables and sys.objects, in which data base maintain table information
please try.

select * from sys.tables where name = 'Table1'

select * from sys.objects where type = 'U' and type_desc = 'USER_TABLE'


hope this will help you.