1
Answer

Best Method to get data from SQL

Space Ghost

Space Ghost

14y
1.7k
1
Hi all,

Does anyone have some solid info on what is the best/fastest method to take when querying a database and writing back to it? What I mean with this is, for performance wise. 

If anyone has any info, please tell me why you would say that. Currently I am using the SQLClient, butt still I would like to know if there is no catch22 that I should know about that might increase the turnaround time for the reading and writing to the DB.

Thanks,
SG
Answers (1)
0
tejal bhesaniya

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

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

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.