How we can pulish the connectivity of SQL query to the HTML file or web page? Please Explain.

Mena1710

 Profile Answers by Mena1710 Questions by Mena1710

• Jan 30th, 2008

Normally connection of SQL file to a web page can be done in two ways1. Through the code2. In web config fileIf we give through the code, we need to alter the relevant pages, where as if we give throu...

Answer Question  Select Best Answer

How many levels a trigger can be nested? Explain about nested triggers.

quietguy999

 Profile Answers by quietguy999 Questions by quietguy999

• Jan 23rd, 2008

There are up to 32 nested trigger levels.

Answer Question  Select Best Answer

How to deny insert, update, delete, update permissions for a specific user of a specific user database?

bugeye

 Profile Answers by bugeye Questions by bugeye

• Mar 15th, 2008

So what context is the user in?  A role a datareader? Datawriter?You want no permissions?USE <your db>Drop USER <your  user> In a role?EXEC sp_droprolemember 'rolename&#...

Answer Question  Select Best Answer

What is tail log backup? Where can we use it?

Kiran Patil

 Profile Answers by Kiran Patil Questions by Kiran Patil

• Mar 26th, 2008

Tail Log Backup is the log backup taken after data coruption (Disaster). Though there is file corruption we can try to take log backup (Tail Log Backup). This will be used during point in time re...

Answer Question  Select Best Answer

How to join same fields of four tables at SQL Server?

psingla

 Profile Answers by psingla Questions by psingla

• Mar 19th, 2010

There are 5 types of join in sqlservercross joininner joinleft outer joinright outer joinfull outer joincross joinselect * from table1cross join table2cross join table3cross join table4inner joinselec...

Answer Question  Select Best Answer

ramaniy

 Profile Answers by ramaniy Questions by ramaniy

• Jun 2nd, 2008

Prefix column name with table name like tableName.columnName

Answer Question  Select Best Answer

There is a problem in creating relationship between two tables using SQL Server Database.What are the requirements and data that should be had before creating table relationship.

charanpathania

 Profile Answers by charanpathania Questions by charanpathania

• Apr 1st, 2009

The datatype of the both the columns used in relation must be the same

Answer Question  Select Best Answer

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