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

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

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 display list of tables from a particular database in MS-SQLHow to display description of that particular table?

cybersavvy

 Profile Answers by cybersavvy Questions by cybersavvy

• Feb 19th, 2009

To Display list of tables in the database:SELECT * FROM INFROMATION_SCHEMA.TABLES WHERE TYPE='basetable'To describe the structure of a particular tableSP_HELP table_name;

sivasangari_2006

 Profile Answers by sivasangari_2006 Questions by sivasangari_2006

• Jan 30th, 2009

Use sp_help It displays all the tables created in that database

Answer Question  Select Best Answer

cybersavvy

 Profile Answers by cybersavvy Questions by cybersavvy

• Feb 19th, 2009

Clustered Index

Badri

• Jun 18th, 2007

Clustered index

Answer Question  Select Best Answer

cybersavvy

 Profile Answers by cybersavvy Questions by cybersavvy

• Feb 5th, 2009

Varchar2 in Oracle is equal to varchar in SQL Server. There is no varchar2 data type in SQL Server

smithanair

 Profile Answers by smithanair Questions by smithanair

• Sep 17th, 2008

VARCHAR is used to store alphanumeric values without padding unused memory locations. But VARCHAR2 is used to store alphanumeric values with padding unused memory locations. so using VARCHAR2 we are saving memory locations.

Answer Question  Select Best Answer

cybersavvy

 Profile Answers by cybersavvy Questions by cybersavvy

• Feb 5th, 2009

To take backup of the Access database, follow the steps:Alt+F --> Manage --> Backup Database -->Specify the path for the backup

Pradip Manna

• Dec 26th, 2006

Backup data from MS Sql Server to Access Database following stapes have to do:-1. Create DSN on SQL server (check Sql server Database name,server name,user name,password)2. open MS access database go to importselect ODBC (DSN name)

Answer Question  Select Best Answer

shreeprakashr

 Profile Answers by shreeprakashr Questions by shreeprakashr

• Dec 11th, 2008

Hi, In this case, We can disable the script task at the run time but we cannot disable succeeding tasks based on the variable. I tried and got to know this. Please correct me if i am wrong.RegardsShree

gnanagopal

 Profile Answers by gnanagopal Questions by gnanagopal

• Jun 19th, 2008

Hi Dhara,1. create a variable2. assign value for variable in the script task.3. Use expression to enable or disable the taks based on the variable values.let me know if you have any more details.cheers,gnanam.

Answer Question  Select Best Answer

pavalisofthard

 Profile Answers by pavalisofthard Questions by pavalisofthard

• Oct 31st, 2008

Cursor is used to eliminate the repeated(duplicate) records in a table.

anupama

• Feb 22nd, 2007

In Embedded SQl we can get

Answer Question  Select Best Answer

neel_desai

 Profile Answers by neel_desai Questions by neel_desai

• Oct 11th, 2008

There is no VARCHAR2 in SQL server.SQL Server VARCHAR = oracle VARCHAR2In SQL Server, maximum size of VARCHAR is 8000. So VARCHAR(MAX) is same as VARCHAR(8000). Also if we write VARCHAR(10000), will g...

Deepak Bhandari

• Mar 30th, 2007

varchar and varchar2: both are datatype for storing character or string type, but there are little bit difference in both, let us with following exemple if we declare a variable name as varchar(100)...

Answer Question  Select Best Answer

neel_desai

 Profile Answers by neel_desai Questions by neel_desai

• Oct 11th, 2008

You can use the PIVOT relational operators to change a table-valued expression into another table. PIVOT rotates a table-valued expression by turning the unique values from one column in the expressio...

Mitul Bahl

• Sep 24th, 2007

The PIVOT operator rotates rows into columns, optionally performing aggregations or other mathematical calculations along the way. It widens the input table expression based on a given pivot column an...

Answer Question  Select Best Answer

neel_desai

 Profile Answers by neel_desai Questions by neel_desai

• Oct 11th, 2008

A trigger is a special kind of stored procedure that automatically executes when an event occurs in the database server. There are three types of triggers: 1. DML trigger     &nbs...

sreyas kvm

 Profile Answers by sreyas kvm Questions by sreyas kvm

• Feb 3rd, 2008

Trigger is a self executing event in sql server where a relevent action is occured.triggers are useful in master-child relation ship in a table.Trigger can be created as,create trigger triggername on tablename for insert,update,delete as "necessory action"

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

What are the types of authentications supported SQL Server

ashwani.kumar

 Profile Answers by ashwani.kumar Questions by ashwani.kumar

• Sep 10th, 2008

1) Windows Authentication2) SQL Server Authentication

gopi2008

 Profile Answers by gopi2008 Questions by gopi2008

• Apr 18th, 2008

Sql Server supports two types authentications1)Windows Authentication2)SQL Server Authentication

Answer Question  Select Best Answer

sakthi.jaganathan

 Profile Answers by sakthi.jaganathan Questions by sakthi.jaganathan

• Aug 25th, 2008

We can copy the Table structure also from one table to another tableExample:                   CREATE table emp1 as      &nbs...

srivani123

 Profile Answers by srivani123 Questions by srivani123

• Nov 15th, 2007

select into statement will work heresyntax: select column1,column2,....into table2from table1

Answer Question  Select Best Answer

anjan_maity

 Profile Answers by anjan_maity Questions by anjan_maity

• Aug 7th, 2008

There is no hard and fast rule. It depends on you SQL statements.There some usefull guideline.Turn on Execution plan.Avoid cursorUse Cluster index (try to keep it small).If possible use 'If Exit'Try to avoid Rebuild option.

subhashsubramanyam

 Profile Answers by subhashsubramanyam Questions by subhashsubramanyam

• Apr 17th, 2008

Optimizing Stored Procedure involves1) Identify long runnning queries and rectify issues associated with it2) Identify whether they are resource intensive (Eg: I/O intensive ? Replace Cursor...

Answer Question  Select Best Answer

Question: Write a SQL Stored Procedure to create a GUID and add it to a table. Make that GUID an OUTPUT of that Procedure

anjan_maity

 Profile Answers by anjan_maity Questions by anjan_maity

• Aug 7th, 2008

Create a out parameter.Set?value with NewId() which return a guid.then insert it into a table.

sutanu_halder

 Profile Answers by sutanu_halder Questions by sutanu_halder

• Dec 14th, 2007

GUIDs are created by the newid() function. If the default of the primary key is set to NewID(),a new GUID is generated for any new row. In addition, the newid() function may be declared within an inse...

Answer Question  Select Best Answer

anjan_maity

 Profile Answers by anjan_maity Questions by anjan_maity

• Aug 7th, 2008

Deadlock occurs when two or more processes have?lock objects and each process is trying to acquire a lock on an object that the other processes have previously locked.? Let p1 process? has an exclu...

rup

• Jan 30th, 2007

Deadlock is a situation when two processes, each having a lock on one piece of data, attempt to acquire a lock on the other's piece. Each process would wait indefinitely for the other to release the ...

Answer Question  Select Best Answer

anjan_maity

 Profile Answers by anjan_maity Questions by anjan_maity

• Aug 7th, 2008

Use IsNULL(,value) .If query return null ,it will replace by  value.

Pandian S

 Profile Answers by Pandian S Questions by Pandian S

• Mar 5th, 2007

Hi1. Without any Null Value for Column1:Select * From Table1 Where Column1 Is Not Null2. Instead of Null values it returns as '0':Select IsNull(Column1,0) Column1,* From Table1

Answer Question  Select Best Answer