what is interfaces in sql server 2008

Question

1.00/5 (1 vote)

See more:

HI frnds good eveng to all....

what is interface in sql server. and is there user interface and interface both are same can any one explain in detail with example. i dont know about that concept in sql-server 2008.

Regards
Krishna

Posted 23-Dec-13 23:08pm

Member 10453510

Updated 23-Dec-13 23:10pm

v2

Add a Solution

Comments

Maciej Los 24-Dec-13 5:15am

Sorry, but i really do not understand you, Krishna.

CHill60 25-Dec-13 10:22am

Notwithstanding the other comments you might find this article useful to explain interfaces in general Interfaces in C# (For Beginners)[^]

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2013-12-23T23:15:00

Solution 1

I think you are rather confused: SQL server does not have a user interface. It has an application which provides a user interface (Sql Server Management Studio, or SSMS) but it is not required in order for SQL Server to run at all.

SQL Server provides an interface to database files via various API's, is all.

Posted 23-Dec-13 23:15pm

OriginalGriff

Comments

Member 10453510 24-Dec-13 5:20am

ya... you are right iam in little bit confusion.
but what is meaning of the following line
"Interface to Create Tables in any type of Database"

OriginalGriff 24-Dec-13 5:25am

In what context?

Member 10453510 24-Dec-13 5:27am

sory i dont know.....

OriginalGriff 24-Dec-13 5:38am

"In what context?" means "where was the phrase? What lines were around it? what was the passage it was in about?"
Without the context, it is very difficult to work out what the meaning of anything is.
For example:
"I'm sorry. Did I break your concentration?"
is pretty much meaningless without the context of the film the quote is taken from:
http://www.youtube.com/watch?v=clb6bFlgTuk
Watch the clip and you realize that it's a major threat, and the person he spoke it to has just realised he is going to die in the immediate future.

We need the same context for your one line quote - or it is equally meaningless.

Member 10453510 24-Dec-13 5:46am

how to create tables in all dataproviders like sqlserver,OLEDB,MsAcess,ODBC...by using one asp.net design method(interface).

did u get what i said

Member 10453510 24-Dec-13 5:48am

for example
id=Textbox
name=TextBox
Sal=TextBox
.
.
.
.
When click the Submit button the table will create for sql,odbc,oledb,access etc.

OriginalGriff 24-Dec-13 6:13am

You can't create a single method that talks to any and all database systems: they all have different APIs, and use different assemblies to communicate - they don't even all support the same things!
For example, I use
SqlConnection - SQL Server
SQLCeConnection - SQLCE .SDF files
OleDBConnection - Access and Excel files
MySqlConnection - MySql Server
SQLiteConnection - SqLite databases.
There are others for Oracle and so forth.

Some of these do not support Stored Procedures, or command chaining.
Some of these have different SQL syntax for various commands
Some of these do not support the same datatypes as the others.

You could do it, but it wouldn't be "just one method" in all probability and it would be pretty damn complex to manage!