-
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...
-
How do I lock a column
How do I lock a column, once records are entered into the table they can not be edited. Also how can I lock the field where only certain values are accepted?
binita007
- Dec 21st, 2010
For this purpose, Views are there in SQL Server.You can Create a view by leaving the column you need to restrictUser can edit all the fields in the view except the one you restrict .Binita.
-
How to create table with same strecture of the existing table in same data base in sql server2000
ramakrishnasri
- Dec 6th, 2007
Hai,here is the example for ypour qustionselect * into emp1 from emp where 1=9execute this u can have the structure of the new table as old with out the data in the new tablei hope it will solve your problem
-
How to find the list of system databases in a SQL Instance.
-
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...
-
Data Reader or Dataset
If you are doing website project, which one is used dataset or data reader? Why?
kirangiet
- Aug 17th, 2010
There is no hard and fast rule like if it is a Web Site project we have to use Data Reader/ Dataset. Its depends on requirement. We can use both of them. We need to understand the pros and cons of bot...
sreyas kvm
- Feb 3rd, 2008
Data reader is used to fetch data from a databaseaccording to users condition.Data reader is used with the select statement.For Eg.to selecting a value from a database in our project, in c#.net w...
-
Database Attach and Restore
What is the Difference between Attach and Restore of a Database?
Kiran Patil
- Mar 26th, 2008
Database attach is faster as compaired to Database Restore. SO if you have both options then may be you can choose Database attach than Database Restore.
nbkb9hv
- Feb 13th, 2008
Both are used to restore database, we Use attach database when we have .mdf file to upload data into database while we use restore database when we have .bak file to upload data into database.
-
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.
-
Full, Simple and Bulk Log Recovery Models
What is the difference between the full, simple and bulk log recovery models?
mbhsye786
- Jan 13th, 2014
Full recovery model: This model requires log backups, no data is lots due to lost of data file, can be recover data up to point of failure. Bulk Log recovery model: Requires log backups. It is simila...
LGSGEEK
- Mar 29th, 2008
SIMPLE: Uses full or differential copies of the database. Truncates the transaction logs automatically. Does not backup the transaction log file(s). Changes made after the last backup cannot be re...
-
General Functions in SQL
What are the general functions available in SQL?
aghiad
- Sep 11th, 2011
The General function are use in SQL 1-NVL (exp1,exp2) 2-NVL2 (exp1,exp2,exp3) 3-NULLIF (exp1,exp2) 4-COALESCE (exp1,exp2,exp3,......,expn) For example: "sql SELECT last_name...
ElavarasiGophannan
- Feb 11th, 2009
Aggregate Functions: AVG() - Returns the average value COUNT() - Returns the number of rows FIRST() - Returns the first value LAST() - Returns the last value MAX() - Returns the largest...
-
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
-
What do we mean by Database Testing ? What is the exact meaning of Database Testing
I want to know what do we mean by Database Testing, as well as what role does a Database Tester plays meaning does he performs the similar role as a DBA does or what exactly?What things are performed in Database Testing?
psingla
- Mar 4th, 2010
Database is a backbone of any of the dynamic web site. It needs a through testing to make an efficient and almost error free site.Database Testing includes: Load testing ...
goksn
- Sep 23rd, 2009
There are various levels in database testing, starting from just seeing whether the database has correct value to 'SQL injection'.Generally database testing includes verification of-Accuracy o...
-
What is the difference between windows authentication and sql server authentication
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
- 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...
-
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 ........
-
T-SQL
What is T-SQL means? How it is different from SQL?
psingla
- Mar 3rd, 2010
SQL/PL-SQL/T-SQLSQL(Structured Query Language): is a ANSI complinent languge to operate a database.It includes DDL(Create,alter,drop,truncate),DML(select,insert,delete,update) and DCL(Grant,revo...
ajitnayak
- Feb 28th, 2009
As the name indicates that T-SQL means transact SQL queries developed by Microsoft. It is a programming language and the difference between SQL and T-SQL is SQL is the base class for T-SQL and T-SQL is inherited from SQL having some extra features as compared to SQL.
-
No Lock
What is 'no lock' term in SQL, like "select * from table a (no lock)". What is its purpose?
psingla
- Mar 19th, 2010
Define: By default select puts exclusive lock. Specifying no lock puts no lock on the table.Advantage: Improve the peformanceDisadvantage: Dirty reads Suggestion: Use in static table data (with fewer DML operations)
sidhuonline
- Jun 30th, 2009
It is useful to improve the performance in executing the query. However there is a disadvantage in using it. The disadvantage is that one may not be sure that they are getting the data which is curren...
-
SQL Server Transactions
Why Transactions are needed in SQL Server?
kirangiet
- Aug 17th, 2010
SQL Transactions ensure to follow ACID Properties.A-Atomicity: Using Transactions, either none or all the statements inside the transaction will execute successfully.C-Consistency: Using Transact...
sanjaykp
- Mar 12th, 2010
To guarantee the authenticity and integrity of any change to data in a database(s), be it an insert, update or delete. Transactions are a fundamental tool used by all industry standard Relation Databa...
-
SQL Key
What is a key in SQL?
Mayank Tripathi
- Jan 18th, 2012
Candidate Key, Alternate Key, Composite Key are also the parts of SQL Server: A candidate key is one that can identify each row of a table uniquely. Generally a candidate key becomes the primary ke...
psingla
- Nov 8th, 2010
We have different types of keys in sql:primary key identify record uniquely max one per table do not contain null values &...
-
Sql Server
In which scenario I can use the unique key and primary key in SQL Server .
I mean in real life database how can I judge where I have to use the unique key and primary key.
sunil neha juhi singh
- Jun 28th, 2012
Primary key=not allow null values,create cluster index by default.
unique key=allow only one null values and by default it create non cluster indexkushgudseva
- May 29th, 2012
A Unique ID and Primary Key Constrain perform the ability to allow unique data in the column but only the Unique constrain allows NULL values in the field along with the unique data. Primary Key constrain fields allow Unique and Not NULL values.
-
SqlDataAdapter ,SqlCommand and SqlDataReader
what are difference between SqlDataAdapter ,SqlCommand and SqlDataReader
asifeqbal
- Mar 19th, 2015
SqlDataReader are used to retrieve data in read-only forward-only manner from the data source. It is not used for traversing the data or writing it back to the data source. So SqlDataReader are faste...
santhosh
- Aug 6th, 2012
Sqldatareader means only read the datas in the table..
sqldataadapter means the datas read and writes
SQL Server Interview Questions
Ans