-
Are there any Commands, can be used to calculate the performance of a Querry?
sapna
- Sep 20th, 2006
set showplan onset showplan_text on
-
How to join four same fields of different tables at sql server?
-
What is the query used to display all tables names in SQL Server (Query analyzer)?
srikanth tirunagari
- May 25th, 2007
select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_TYPE = 'BASE TABLE'
-
How we can make sure that the SQL query does not return NULL values?
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
-
Explain about Dead-locks in Sql Server database
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 ...
-
Creating SQL Server GUID
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
- Aug 7th, 2008
Create a out parameter.Set?value with NewId() which return a guid.then insert it into a table.
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...
-
How do you optimize stored procedures ?
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
- 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...
-
How to copy one table data into another table directly?
sakthi.jaganathan
- Aug 25th, 2008
We can copy the Table structure also from one table to another tableExample: CREATE table emp1 as &nbs...
srivani123
- Nov 15th, 2007
select into statement will work heresyntax: select column1,column2,....into table2from table1
-
Types of authentications supported SQL Server
What are the types of authentications supported SQL Server
gopi2008
- Apr 18th, 2008
Sql Server supports two types authentications1)Windows Authentication2)SQL Server Authentication
-
Deny Delete and Drop Permission
How to deny delete and drop permission to the user for the particular database in SQL Server 2005.
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 ..
-
Stored Procedure
How we will access a table of one server from a stored procdure in other server?
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]
-
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"
-
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 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)...
-
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
-
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.
-
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)
-
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.
-
Which index is created with primary key linear indexbinary indexclustered indexnon clustered index
Badri
- Jun 18th, 2007
Clustered index
-
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;
SQL Server Interview Questions
Ans