What is its purpose?How to use it?

Read Best Answer

Editorial / Best Answer

suji  

 Profile Answers by suji Questions by suji

• Member Since Sep-2005 | Nov 5th, 2011

---

Here are multiple ways to get the table information. The DESCRIBE command does not exist in MS SQL SERVER. This is an Oracle command used to describe the structure of objects within a given database. To achieve the same task in MSSQL Server, there are a series of stored procedures with the prefix SP_ that can be used. To view the structure of a table within the current database, use the command

Code
sp_help 'TABLE_NAME';

If you would like to see more details, Create your custom procedure

Code
span style="color: #ff0000;">'order'

Here is another alternative way to get the same information

Code
span style="color: #ff0000;">'TableName''Employee'

Here is the usage :

Code
span style="color: #ff0000;">'Department''sa''TableName'

Contributors for the editorial answer : Kewlshiva, srilakshmi.b, raaghav,kevaburg

Rooshi

• Oct 17th, 2014

Sp_help will give all the details about the table columns, indexes, partitions etc.

Saket Kale

• Oct 24th, 2012

Sp_help dbo.customers;

worked for me just fine.

Thanks to the OP, this runs perfectly on SQL 2008 R2, do not know about other versions

Improve Answer

murali chennupati

• Jul 5th, 2014

From jobs->new->step->categories->ssis->select db->select the package & schedule.

Answer Question  Select Best Answer

mbhsye786

 Profile Answers by mbhsye786 Questions by mbhsye786

• Jan 13th, 2014

Your answer is incorrect
Sql Server runs only on windows platform and is hardware dependent
where as
Oracle runs in any platform and hardware independent such as can run on unix and windows.

Sivaram

• Dec 31st, 2006

Basic DifferenceSql Server:Runs only on windows platform,Hardware independentoracle:Runs in any platform and hardware dependent..

Answer Question  Select Best Answer

What is the difference between the full, simple and bulk log recovery models?

mbhsye786

 Profile Answers by mbhsye786 Questions by mbhsye786

• Jan 13th, 2014

Full recovery model: This model requires log backups, no data is lots due to lost of data file, can be recover data up to point of failure. Bulk Log recovery model: Requires log backups. It is simila...

LGSGEEK

 Profile Answers by LGSGEEK Questions by LGSGEEK

• Mar 29th, 2008

SIMPLE: Uses full or differential copies of the database. Truncates the transaction logs automatically. Does not backup the transaction log file(s). Changes made after the last backup cannot be re...

Answer Question  Select Best Answer

How to create restore point in Server 2003?

In which scenario I can use the unique key and primary key in SQL Server .
I mean in real life database how can I judge where I have to use the unique key and primary key.

sunil neha juhi singh

• Jun 28th, 2012

Primary key=not allow null values,create cluster index by default.
unique key=allow only one null values and by default it create non cluster index

kushgudseva

 Profile Answers by kushgudseva Questions by kushgudseva

• May 29th, 2012

A Unique ID and Primary Key Constrain perform the ability to allow unique data in the column but only the Unique constrain allows NULL values in the field along with the unique data. Primary Key constrain fields allow Unique and Not NULL values.

Answer Question  Select Best Answer

Vijay

• May 10th, 2012

SELECT ID FROM TBLSAMPLE GROUP BY ID OR SELECT DISTINCT (ID) FROM TBLSAMPLE

Code
 

Mally

• Feb 13th, 2012

Good Code...however the code will delete all the duplicates... you may want to add:

delete top(n) clause in your delete statement to exactly delete the required number of records.

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: Hanif

• Apr 12th, 2006

---

we have to use the group by with having command to get the duplicate values. this query shall show the result of only the users have duplicate values in the employee table.

Syntex:
Select columnName From Table_name
Group By columnName
Having count (*) > 1

Example:
SELECT  UserID FROM employee
GROUP BY userid
HAVING count( * ) > 1

nandu

• Apr 26th, 2012

SELECT YourColumn, COUNT(*) TotalCount
FROM YourTable
GROUP BY YourColumn
HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESC

Ramakant Sahoo

• Dec 24th, 2011

Code
span style="color: #ff0000;">"REPETED EMAIL"

Improve Answer

Read Best Answer

Editorial / Best Answer

santanukd  

 Profile Answers by santanukd Questions by santanukd

• Member Since May-2008 | May 14th, 2009

---

Just replace "[your-schema-name-here]" in the following query with your schema name. Hope it comes handy to some of you out there.

Select OBJECT_TYPE,OBJECT_NAME
FROM
(
Select 'TABLE' as OBJECT_TYPE, TABLE_NAME as OBJECT_NAME, TABLE_SCHEMA as OBJECT_SCHEMA from information_schema.VIEWS
Union
Select 'VIEW' as OBJECT_TYPE, TABLE_NAME as OBJECT_NAME, TABLE_SCHEMA as OBJECT_SCHEMA from information_schema.VIEWS
Union
Select 'INDEX[Type:Name:Table]' as OBJECT_TYPE, concat(CONSTRAINT_TYPE,' : ',CONSTRAINT_NAME,' : ',TABLE_NAME) as OBJECT_NAME,TABLE_SCHEMA AS OBJECT_SCHEMA from information_schema.TABLE_CONSTRAINTS
Union
Select 'Procedure/Functions' as OBJECT_TYPE, ROUTINE_NAME as OBJECT_NAME, ROUTINE_SCHEMA as OBJECT_SCHEMA from information_schema.ROUTINES
) R

Where R.OBJECT_SCHEMA=[your-schema-name-here]

Keer

• Apr 25th, 2012

Select * from sys.tables where type = U

saikiran

• Jul 22nd, 2011

Select * from sys.tables

Improve Answer

interviewer ask.. can we replace where clause by group by clause

let say

select * from table_name where some_condition

so how we replace where clause by group by clause

Mark Haynes

 Profile Answers by Mark Haynes Questions by Mark Haynes

• Feb 16th, 2012

As a basic rule of query building: 1. The WHERE clause should be used to limit the number of rows returned by or affected by the a SQL statement. 2. The GROUP BY clause is used to group a selec...

Answer Question  Select Best Answer

What is a key in SQL?

Mayank Tripathi

 Profile Answers by Mayank Tripathi Questions by Mayank Tripathi

• Jan 18th, 2012

Candidate Key, Alternate Key, Composite Key are also the parts of SQL Server: A candidate key is one that can identify each row of a table uniquely. Generally a candidate key becomes the primary ke...

psingla

 Profile Answers by psingla Questions by psingla

• Nov 8th, 2010

We have different types of keys in sql:primary key      identify record uniquely     max one per table     do not contain null values &...

Answer Question  Select Best Answer

suji

 Profile Answers by suji Questions by suji

• Jan 15th, 2012

From your SQL Server Management Studio, you open Object Explorer, go to your database where you want to load the data into, right click, then pick Tasks > Import Data. Select the options based on the excel file

Answer Question  Select Best Answer

What is fill factor?What should be the ideal value of fill factor for any index?Justify the answer.

raiyaans

 Profile Answers by raiyaans Questions by raiyaans

• Jan 12th, 2012

The fill factor simply says how large or how full to get our index pages
you can set it as 70% ,

If set to 100% it might me a bad thing if we had a lot of DML activity but if this is a read only table then
fill factor=100% is fine.

Answer Question  Select Best Answer

1 How is the error handling in stored proc of T-SQL2 What is clustered index and non-clustered index? How many clustered indexes and non-clustered indexes can be created in one table? 3-what is disconnected mode?

Pradeep Kumar Sharma

• Dec 25th, 2011

Begin Try

--
--
End Try
Begin Catch

Declare @errMsg varchar(1000),@errSev int
select @errMsg=error_message(),@errSev=error_severity()
RaisError(@errMsg,@errSev,1)

End Catch

kirangiet

 Profile Answers by kirangiet Questions by kirangiet

• Aug 17th, 2010

1) CLR is integrated in SQL Server 2005. Hence we can use below code for Exception Handling. BEGIN TRY SELECT * FROM Employees; END TRY BEGIN CATCH SELECT ERROR_NUMBER() ...

Answer Question  Select Best Answer

How do represent objects in SQL Server? Is it possible? If yes, how?If not? Why?

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Dec 12th, 2011

Try using Server Management Objects (SMO) classes

Answer Question  Select Best Answer

List down the advantage and disadvantages of Covering indexes.

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Dec 12th, 2011

Covering Indexes are useful for Input / Output intensive workloads.
Covering indexes are smaller in size
Covering Indexes are sorted by values
It is easier to cache date in Covering Indexes

Covering Indexes cannot be used to select all the columns / entire table.

Answer Question  Select Best Answer

how do you run PL/SQL block from SQL Server

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Dec 12th, 2011

Try these and see...

Go To Options -> Run SQL
Set "Statement Delimiter" to None

Go To Options -> Technical Parameters
Tick "Use SQLExecDirect"

Answer Question  Select Best Answer

what is high water mark? Give an example where it can be useful ?

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Dec 12th, 2011

High Water Mark (HWM) represents total number of extent blocks used by a table. The value of High Water Mark could sometime be more then the actual size required/used by a table. This is because, some...

Answer Question  Select Best Answer

What is the difference between Subqueries and Joins? Which is better and Why? Give an example of each.

Hiren

• Nov 29th, 2011

Its true, I would like to add some more information about it, Subquery take separate temp table and checking condition .. Besides join is checks conditions first and then put it into tabl...

abdullah

• Sep 12th, 2011

I am software engineer and iam working on oracle mysql and sql so i have lot of experience on this ,basically joins are using there should be connection two or more than two tables ,joins are always o...

Answer Question  Select Best Answer

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Nov 28th, 2011

Steps to set / modify Global Setting for Query Studio: 1. Stop the Cognos 8|ReportNet server. 2. On the Cognos 8|ReportNet Server, go to the directory /c8|crn/templates/ps/async/ 3. Either create a n...

Answer Question  Select Best Answer