How to select Distinct columns from the table, table having 20 columns and i want all columns

Thenchinnu

 Profile Answers by Thenchinnu Questions by Thenchinnu

• May 15th, 2008

SELECT DISTINCT *FROM Tabe1

Answer Question  Select Best Answer

How to transfer data from a text file to SQL table, Which is the best method to do that?

sakthi.jaganathan

 Profile Answers by sakthi.jaganathan Questions by sakthi.jaganathan

• Aug 25th, 2008

By using OPENROWSET commandExample:                   INSERT INTO dbo.ImportTestSELECT * FROM OPENROWSET('Microsoft.Jet.OLED...

Answer Question  Select Best Answer

How do you BCP only a certain set of rows out of a large table?

snigd

 Profile Answers by snigd Questions by snigd

• Oct 7th, 2009

WHERE cluase can be used with bcp commands and all the conditions can be mentioned in the query to generate the set of rows you want to copy.

Answer Question  Select Best Answer

Write an SQL query if you want to select the data from one block which intern reflects in another block?

rshanmugaraj84

 Profile Answers by rshanmugaraj84 Questions by rshanmugaraj84

• Mar 5th, 2009

Select *from(Select *from ) a

Answer Question  Select Best Answer

How we will access a table of one server from a stored procdure in other server?

shaurya

 Profile Answers by shaurya Questions by shaurya

• Oct 9th, 2008

You can access this through the following syntax[Another Server IP].[Database Name].[Owner].[Table Name]e.g.[XXX.XXX.XX.XX].[myDB].[DBO].[EmployeeMaster]

Answer Question  Select Best Answer

How to deny delete and drop permission to the user for the particular database in SQL Server 2005.

lairdmcbride

 Profile Answers by lairdmcbride Questions by lairdmcbride

• Oct 22nd, 2008

USE [PARENTDB] GO DROP SCHEMA [USER] GO USE [DB]GO DROP USER [USER] GOor in GUI SQL SQL server Managment Studio go to your DB open it's security section up. . select users folder .. select user adn press delete on the keyboard ..

Answer Question  Select Best Answer

How to read the data from a pdf in SSIS?

Amaleswar

• Jan 23rd, 2016

Using Import transformation.

Answer Question  Select Best Answer

If a table has more than one index, how will you call a specific index in query?

psingla

 Profile Answers by psingla Questions by psingla

• Mar 19th, 2010

select * from table_name with (index(index_name))

Answer Question  Select Best Answer

How to insert bulk data into the SQL Server?

clickfreehit

 Profile Answers by clickfreehit Questions by clickfreehit

• Apr 11th, 2009

Table to table data transferselect * into targettable from tableflat file to table data transferuse bcp command bcp pubs2..publishers in pub_out -c -t , -r r 

Answer Question  Select Best Answer

You are required to design a social networking site. Set of all those people who are friend of friends your friends would be consider to be in your network. Write a SQL query to print Number of people in your network. You need to create a profile of each user and store his/her photographs. How would you go about doing the same using database?

gudluck

 Profile Answers by gudluck Questions by gudluck

• Jul 11th, 2009

Answer for ist part of the question:Create 2 tables mapidandnames and friendsTable:mapidandnamesid    name--------------  1    a  2  &n...

Answer Question  Select Best Answer

How to write query to unsort while retrieving data?

psingla

 Profile Answers by psingla Questions by psingla

• Mar 9th, 2010

No need to do so. the data  fetched by the sql query returns the unsorted data unless the order by clause is not used.

Answer Question  Select Best Answer

Which TCP/IP port does SQL Server run on? How can it be changed?

sonalimajumdar

 Profile Answers by sonalimajumdar Questions by sonalimajumdar

• Jul 17th, 2009

SQL server works on 1433 port and DAC (dedicated admin connection ) works on 1434 port. You can change the port number SQL server should use through SQL net configuration manager.

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

How to secure data in the SQL Server Database?

psingla

 Profile Answers by psingla Questions by psingla

• Mar 9th, 2010

Revoke db_datareader and db_datawriter permission from the database.

Answer Question  Select Best Answer

How to send mail from SQL Server?

vishalparate

 Profile Answers by vishalparate Questions by vishalparate

• Mar 30th, 2010

With SQL Server 2005, there is no need to use MAPI client to send emails. Fellow developers who have used MAPI in the previous versions of SQL Server are well aware of the challenges it had. However i...

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

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 to Store Images in SQL Server 2005?

vigneshmca

 Profile Answers by vigneshmca Questions by vigneshmca

• Sep 9th, 2010

You can store images by BLOB (Binary Large object). Conversion should take place in front-end?or SQL supports image as datatype. Try it.

Answer Question  Select Best Answer

What are the steps to configure DB mirroring?

sthakk3

 Profile Answers by sthakk3 Questions by sthakk3

• Dec 9th, 2010

Database mirroring maintains two copies of a single database that must reside on different server instances of SQL Server Database Engine.Database mirroring is a primarily software solution for increasing database availability.

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