How To Define Unique Key in SQL Server

cybersavvy

 Profile Answers by cybersavvy Questions by cybersavvy

• Feb 19th, 2009

CREATE TABLE product(pid INT PRIMARY KEY,pname VARCHAR(10),invoiceid INT UNIQUE)

sivasangari_2006

 Profile Answers by sivasangari_2006 Questions by sivasangari_2006

• Jan 30th, 2009

Create table (field1 datatype contraint constraint-name constraint_type,fields2,field3.........)(or)alter table add constraint constraint constraint_name constraint_type(fieldname)Eg:create table emp(eno int constraint uni1 unique,ename varchar(20)

Answer Question  Select Best Answer

How to insert data in multiple tables at same time. using SQL Server 2000

krishna8081

 Profile Answers by krishna8081 Questions by krishna8081

• Feb 24th, 2009

Here is the example for you question.

USE YourDB
GO
INSERT INTO
MyTable (FirstCol,
SecondCol)
SELECT First
,1
UNION ALL
SELECT Second
,2
UNION ALL
SELECT Third
,3
UNION ALL
SELECT Fourth
,4
UNION ALL
SELECT Fifth
,5
GO

swathi660

 Profile Answers by swathi660 Questions by swathi660

• Jan 15th, 2009

Insert into t1 values(,,,) insert into t2 values(,,,) insert into t3 values(,,,,)......try this ........

Answer Question  Select Best Answer

I was asked in an interview..."Suppose u have a field with UNIQUE KEY. can u leave two or more cells NULL in SQL Server 2005...If Yes then Why...if NOT then Why.....

slimtech

 Profile Answers by slimtech Questions by slimtech

• Feb 27th, 2009

In case of SQL Server : No and so is for DB2. But in case of Oracle : Yes.. Oracle supports multiple null values in the unique key column whereas SQL Server allows only one null value in the unique key column..

nirajkvinit

 Profile Answers by nirajkvinit Questions by nirajkvinit

• Dec 17th, 2008

Yes! We can have multiple values in a unique key based column. Because Null mean unspecified/undefined value. Which means, no two null values are the same.

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

mragu1986

 Profile Answers by mragu1986 Questions by mragu1986

• Mar 16th, 2009

Oracle is more secure than MS Access.Oracle stores unlimited data while MS
Access is not.Sequence creation is not possible in MS Access.Oracle is scalable but not
MS Access.

Shoby

• May 9th, 2006

Oracle is ORDBMS (Object Oriented Relational DataBase) while Access is RDBMS(Relational DataBase) only.

Answer Question  Select Best Answer

What will you do if a trigger fails during execution?

charanpathania

 Profile Answers by charanpathania Questions by charanpathania

• Apr 1st, 2009

Rollback your transaction

bugeye

 Profile Answers by bugeye Questions by bugeye

• Mar 14th, 2008

Does it fail all the time?  Did it run before?  Most trigger issuses are with datatype mismatches or constraint voiolations .  Run the DML statement in a SSMS query to see what the error message is. 

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

What are the differences between sqlserver 2000 and sql server 2005

deepintl

 Profile Answers by deepintl Questions by deepintl

• Apr 1st, 2009

1)-In SQL SERVER 2000 there where maximum 16 instances, but in 2005 you can have up to 50 instances.2)-Database mirror concept supported in SQL SERVER 2005 which was not present in SQL SERVER 2000.3)-...

khwaja MOhammad Sohail

 Profile Answers by khwaja MOhammad Sohail Questions by khwaja MOhammad Sohail

• Jul 14th, 2008

There are Many Differences like 1.Replication Management: Replication monitor is way usless when compared to the 2000 interface (lots and lots of screens and can not even handle pull subscriptions ent...

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

srialekhya

 Profile Answers by srialekhya Questions by srialekhya

• Apr 22nd, 2009

Windows authentication is highly secure than SQL Server authentication why because we need not provide any login details. So the chance of tracing login details from code by the unauthorized?persons will be less. Windows?authentication uses the default windows login credentials.

sidver

 Profile Answers by sidver Questions by sidver

• Jul 16th, 2008

Windows authentication will uses the credentials of the currently logged user to login in to the sql server database. Your application need not to supply the user name and password. for SQL server...

Answer Question  Select Best Answer

Swapna85

 Profile Answers by Swapna85 Questions by Swapna85

• May 4th, 2009

In SQL Server, objects like tables, views, stored procedures and so on that occupy space are called data objects.

sari_pot

 Profile Answers by sari_pot Questions by sari_pot

• Oct 18th, 2007

Views,indexes,stored procedures,user-defined functions and triggers

Answer Question  Select Best Answer

jjvetri

 Profile Answers by jjvetri Questions by jjvetri

• May 8th, 2009

CREATE TABLE dbo.SalesByQuarter ( Y INT, Q INT, sales INT, PRIMARY KEY (Y,Q) ) GO INSERT dbo.SalesByQuarter(Y,Q,Sales) SELECT 2003, 2, 479000

gvs

 Profile Answers by gvs Questions by gvs

• Jan 3rd, 2008

Using Pivot Option in MS SQL Server 2005.

Answer Question  Select Best Answer

jannani

 Profile Answers by jannani Questions by jannani

• May 12th, 2009

SQL profiler is a graphical tool that allows system administrator to monitor in an instance of the SQL Server.Use of SQL Profiler:Monitor the performance of an instance of SQL Server.Debug Transact-SQ...

ak

• Nov 29th, 2005

It's a tool that ships with SQL Server to profile sql querie and fine tune slow performance degrading sql queries by looking at how sqlsever executes them . It contains tools like index tuni...

Answer Question  Select Best Answer

sushilmishra

 Profile Answers by sushilmishra Questions by sushilmishra

• Jun 8th, 2009

* Stored procedure contains all DML stmt to perform operation With permanent table where user define function does not contain insert, update, delete stmt to modify the permanent table.* Stored proc...

praveen34.tit

 Profile Answers by praveen34.tit Questions by praveen34.tit

• Apr 2nd, 2009

The major difference between procedure and function is that 1. Procedure can be compiled only once and vice versa. 2. Execution of procedure is faster then function 3. Function can be used in select Q...

Answer Question  Select Best Answer

yatinhatkar

 Profile Answers by yatinhatkar Questions by yatinhatkar

• Jun 18th, 2009

Data objects are basic runtime entities.

Rekha

• Jan 15th, 2007

Stored procedures,views,tables,database diagrams are the data objects

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

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

prathima

 Profile Answers by prathima Questions by prathima

• Jul 25th, 2009

Select top 5 avg(rank) from table_name group by rank order by rank desc

cybersavvy

 Profile Answers by cybersavvy Questions by cybersavvy

• Feb 19th, 2009

Select top 3 * from students order by average desc

Answer Question  Select Best Answer

zeekhan

 Profile Answers by zeekhan Questions by zeekhan

• Aug 12th, 2009

Inner Join returns matching records onlyA full outer join returns all rows in both the left and right tables

sa_dub

 Profile Answers by sa_dub Questions by sa_dub

• May 4th, 2009

Inner Join is used to join two coloumns of the same table which have some same attributes but Outer Join used for join two coloumns of different tables which have unmached attributes.

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