-
Insert Bulk Data
How to insert bulk data into the SQL Server?
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
-
Differences between sqlserver2000 and 20005
What are the differences between sqlserver 2000 and sql server 2005
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
- 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...
-
Table Relation Creation Procedure
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.
-
Failed Trigger
What will you do if a trigger fails during execution?
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.
-
Difference between "ORACLE" and "MICROSOFT ACCESS" databases?
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.
-
Data Block
Write an SQL query if you want to select the data from one block which intern reflects in another block?
-
SQL Server Multiple null values
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
- 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
- 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.
-
Insert Data in Multiple Tables
How to insert data in multiple tables at same time. using SQL Server 2000
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
- Jan 15th, 2009
Insert into t1 values(,,,) insert into t2 values(,,,) insert into t3 values(,,,,)......try this ........
-
Unique Key in SQL Server
How To Define Unique Key in SQL Server
cybersavvy
- Feb 19th, 2009
CREATE TABLE product(pid INT PRIMARY KEY,pname VARCHAR(10),invoiceid INT UNIQUE)
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)
-
To display list of tables in database
How to display list of tables from a particular database in MS-SQLHow to display description of that particular table?
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;
-
Which index is created with primary key linear indexbinary indexclustered indexnon clustered index
Badri
- Jun 18th, 2007
Clustered index
-
Difference between "VARCHAR" and "VARCHAR2" datatypes?
cybersavvy
- Feb 5th, 2009
Varchar2 in Oracle is equal to varchar in SQL Server. There is no varchar2 data type in SQL Server
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.
-
How will backup database in access?
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)
-
I have three task in my SSIS package,1. Script Task2. Execute Process Task3. FTP Task I want to enable disable Execute Process Task and FTP Task on runtime using script task, How to do that?Do we have any property of dts using which we can access property of other task iin script task like Dts.Connection("Connectionname") for Connection Controls?
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
- 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.
-
SQL Server Reporting Services Subscription
How can we dynamically assign parameters to a subscription in SQL Server Reporting Services 2005.
-
Where can i get more information on SQL Server cursors? please help...
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
-
Output Row Buffer Size
What is the buffer size of SQL query output row?
-
What is the difference between Varchar and Varchar2?
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)...
-
What is the pivot operator in MS SQL Server2005? What is the use of it and how do we use it
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...
-
What is a "trigger"?
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
- 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"
SQL Server Interview Questions
Ans