|
I want Microsoft SQL server queries corresponding to the following Oracle queries
//get schema of a table desc tablename; //get the names of all tables select * from tab;
Answer Snippets (Read the full thread at stackoverflow):
INFORMATION_SCHEMA.Tables -> gives you access to table names
INFORMATION_SCHEMA.Columns -> gives you access to column names
Here is another link with a complete list of catalog... .
Check this link out.
You have access to that info through metadata tables.
|
|
As far as I know, in MS SQL Server 2000+ stored procedures are compiled, and run faster than normal non-compiled queries. I wonder if MS SQL Server also compiles LINQ to SQL queries, and caches that compilation, for performance purposes.
Started by Jader Dias on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
You can always call Stored Procedures with LINQ this for... .
As far as I know, it behaves as normal queries to SQL Server.
The queries to generate SQL queries that are then sent to the server as SQL text commands.
|
|
Hello I made a SQL test and dubious/curious about one question:
In which sequence are queries and sub-queries executed by the SQL engine?
the answers was
primary query -> sub query -> sub sub query and so on sub sub query -> sub query -> prime...
Started by Igor on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
The SQL engine tries to optimise the order in which (sub)....
It has two dedicated chapters on how queries are processed logically and physically in SQL usually can't be calculated without sub query results.
Querying.
|
Ask your Facebook Friends
|
I am trying to view SQL generated by Linq to SQL in the SQL Server Profiler (2005).
I can see the sql sent to the server from anything except for linq to sql.
I'm betting that I need to change event selections for the trace, but not sure what else to ...
Started by Ronnie Overby on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Are you including enough of the options in the SQL Profiler to see the BatchCompleted events, too.
Marc
You need RPC call - the queries are executed as exec_sql.
|
|
Is there a good way to time SQL queries when using Linq to SQL? I really like logging feature, but it would be great if you could somehow also time that query. Any ideas?
Started by David Vidmar on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
Just remember that Linq->SQL queries there will be a ....
You could use a System.Diagnostics.Stopwatch it will allow you to track the time the query executes.
We use SQL Profiler to test our queries with LLBLGen Pro.
|
|
Could you tell me, please, if it's possible to preview (or at least retroview, for example, in a kind of a log file) SQL commands which SQL Server Management Studio Express is about to execute (or has just executed)?
In the past I used Embarcadero DBArtisan...
Started by Alexander Prokofyev on
, 4 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
You can use Query Profiler (from SQL) to view the queries and in your SQL Query embed TRAN and you can be sure that nothing was made, this is the way to commit queries and to safe rollback if the SQL encounter....
|
|
I do understand SQL querying and syntax because of previous work using ASP.NET web forms and stored procedures, but I would not call myself an "expert" in it.
Since I have been using ASP.NET MVC and LinqToSql it seems that so much of the heavy lifting...
Started by Nick Allen - Tungle139 on
, 14 posts
by 14 people.
Answer Snippets (Read the full thread at stackoverflow):
The reason is you need to at least understand how LinqThis is main reason why I use Linq2SQL, I hate SQL with a passion, and can never remember the silly me happy!
Its always ....
It is still important to learn SQL queries/syntax.
|
|
Will the sql queries i run in ms-access also work on mysql without any changes ?
Started by silverkid on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Date and string functions are the most likely to cause problems when... .
If you use 'queries' to mean INSERTIt's possible, but it depends on what the queries use.
I've assumed by 'queries' you mean SQL DML SELECT .
Lower case.
|
|
Hi!
I'm a developer and running a SQL Server 2008 SP1 instance (default instance) on my local machine (Windows 7 RC 32-Bit). Sometimes when the program I'm developing sends a query to the SQL Server, the whole SQL Server crashes. The SQL queries are not...
Started by Oliver Hanappi on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
Do you need to run explicit distributed transactions?
DTC is a part of the OS, not the SQL Server.
Have you tried running your DTC on a different install of SQL Server.
That shouldn't happen.
|
|
I have been using LINQ to query my POCO objects for some time, but I have not yet tried LINQ to SQL. I assume that LINQ to SQL queries are somehow converted to equivalent SQL queries and, given this, I am wondering if that affects the way LINQ to SQL ...
Started by GraemeF on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
LINQ to Objects person;
will compile fine, but fail....
That means that there is code you can write which isn'tLINQ to SQL will use the column DB server's collation for Where and OrderBy .
To SQL queries are converted into SQL.
|
