Nov 26, 2008 · The SQL Server equivalent to Oracle's describe command is the stored proc sp_help The describe command gives you the information about the column names, types, length, etc.

Jun 18, 2012 · I want to describe a table in SQL Server 2008 like what we can do with the DESC command in Oracle. I have table [EX].[dbo].[EMP_MAST] which I want to describe, but it does not work.

May 4, 2011 · 49 According to Itzik Ben-Gan, author of T-SQL Fundamentals for MS SQL Server 2012, "By default, SQL Server sorts NULL marks before non- NULL values. To get NULL marks to sort last, …

3 DESC is not an SQL command, it's an SQL*Plus function - i.e., it won't work on other tools, especially if they are used to mange non-oracle databases. You can use EXEC sp_help 'my_table' as a way of …

Aug 26, 2005 · Hi all, I am desperately looking for a Equivalent Command to Oracle command of ‘DESC’ OR ‘DESCRIBE’ in SQL SERVER. Can anyone help me with an information as to what is the …

Jul 29, 2010 · 86 It depends from the database you use. Here is an incomplete list: sqlite3: .schema table_name Postgres (psql): \d table_name SQL Server: sp_help table_name (or sp_columns …

And, if you specify DESC, it works like NULLS LAST. So you only need to do change the behavior for NULLS FIRST in DESC order, and for NULLS LAST in ASC order. IMHO, the best solution for …

Jun 10, 2009 · I'm trying to do something like : SELECT * FROM table LIMIT 10,20 or SELECT * FROM table LIMIT 10 OFFSET 10 but using SQL Server The only solution I found looks like overkill: …

Jan 20, 2012 · I have an Oracle query select max(m.id), m.someId keep (DENSE_RANK FIRST ORDER BY m.UpdateDate desc) from MyTable m groupBy m.someId which for data like this: id UpdateDate …

I have this query with MySQL: select * from table1 LIMIT 10,20 How can I do this with SQL Server?