-
Which is the best option used to move database from one server to another serve on same network?a) Import - Exportb)Backup-Restorec)Detach-AttachWhy?
kirandba
- Apr 1st, 2010
Backup and Restore works well and its also faster when compare to copying data and log file. Impoert/Export works well if your dealing with very small databases. If we have few million rows its takes minutes to copy when compared to seconds using backup and restore.
-
Define Unique Key in SQL Server
How to define unique key in table? Is it possible to define one primary key and one unique key in a single table?
asifeqbal
- Mar 19th, 2015
UNIQUE key constraint enforce uniqueness of the column on which they are defined. It allows the column to have distinct & one NULL values. We can make one or more columns unique in a table by defining...
erik
- Jul 21st, 2012
SQL UNIQUE key... The UNIQUE constraint uniquely identifies each record in a database table. The UNIQUE and PRIMARY KEY constraints both provide a guarantee for uniqueness for a column or set of col...
-
I have a table in sql server with two fields named 'start_time' and 'stop_time'. both fields have datatype set as 'datetime'. now I want to subtract the 'start_time' from 'stop_time'? I have tried datediff() fuction,but no use. I want the correct outpput of date as well as time . Need help as early as possible.
satheyaraaj
- Jul 9th, 2011
Select DATEDIFF(MI,FromTime,ToTime) From ShiftMaster -- between no of minutesselect DATEDIFF(HH,FromTime,ToTime) From ShiftMaster -- between no of Hours
swathi660
- Jan 15th, 2009
Select starttime,stoptime,datediff(day,starttime,stoptime) as newtime from date.try this...........
-
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.
-
Can we call trigger inside stored procedure?
badri
- Dec 9th, 2015
Can I write a trigger within Stored Procedure?
psingla
- Mar 19th, 2010
No.Its automatically fired on DML statements.these can not be triggered manually.
-
Table Name Alias
Why do we use alias for the table name? What is its importance?
psingla
- Mar 3rd, 2010
Alias is a alternate name given to a table for multiple purposes.The scope of the Alias is within the queryAlias is?used to give short name to the table.Used when same table is used n number of times in a query. Alias is used in such queries to give unique name to each table reference.?
goksn
- Sep 23rd, 2009
-is a shorthand notation-Will be used along with column name if same colum name present in more than one table (while joining those tables)-Must in self join
-
How do you change column names in SQL Server ?
shabanabegum
- Dec 9th, 2009
Exec sp_rename 'oldtablename.oldcolmnname','newcolumnname'for example Exec sp_rename 'employee.DateofBirth','DOB'Thanks
-
How is the error handling in stored proc of T-SQL ?
1 How is the error handling in stored proc of T-SQL2 What is clustered index and non-clustered index? How many clustered indexes and non-clustered indexes can be created in one table? 3-what is disconnected mode?
Pradeep Kumar Sharma
- Dec 25th, 2011
Begin Try
--
--
End Try
Begin Catch
Declare @errMsg varchar(1000),@errSev int
select @errMsg=error_message(),@errSev=error_severity()
RaisError(@errMsg,@errSev,1)
End Catchkirangiet
- Aug 17th, 2010
1) CLR is integrated in SQL Server 2005. Hence we can use below code for Exception Handling. BEGIN TRY SELECT * FROM Employees; END TRY BEGIN CATCH SELECT ERROR_NUMBER() ...
-
Can i update views in SQL
Can i update views in SQL if yes in what scenarios?
if your view is joining multiple tablesAyushi
- May 7th, 2015
We can update simple views(having data from one table) and complex views(having data from multiple tables) but columns should be taken from one base table for update.
asifeqbal
- Mar 18th, 2015
Yes, we can update view when view is created by single table (simple view). If we want to Update view that are based on multiple tables using Joins, Update does not work. So we used "Instead of Triggers" for updating Complex view.
-
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.
-
How to find out duplicate records in sql server?
Read Best Answer
Editorial / Best Answer
Answered by: Hanif
- Apr 12th, 2006
we have to use the group by with having command to get the duplicate values. this query shall show the result of only the users have duplicate values in the employee table.
Syntex:
Select columnName From Table_name
Group By columnName
Having count (*) > 1Example:
SELECT UserID FROM employee
GROUP BY userid
HAVING count( * ) > 1nandu
- Apr 26th, 2012
SELECT YourColumn, COUNT(*) TotalCount
FROM YourTable
GROUP BY YourColumn
HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESCHow many column maximum we can add in one table and how many foreign key maximum we can use in one table?
venkat.rbs
- Feb 12th, 2008
We can define up to 1024 columns. in one table....And 253 forignkeys we can assign for 1 table...
Can we generate a trigger for two tables? if so what is the query to generate a trigger for two tables employee table and department table with employee having department no.
sreyas kvm
- Feb 3rd, 2008
Yes we can generate....CREATE TRIGGER Tgr2Tab ON dbo.employee FOR INSERT AS INSERT INTO dbo.department(SELECT departmentno FROM INSERTED )
chauhan_anilit
- Jan 10th, 2008
Usha G, your code is right but it only for first (SampleMainTable) table and execute whn you insert a record in the SampleMainTable tabe so its only for SampleMainTable table
What is the difference among "dropping a table”,” truncating a table" and deleting all records" from a table?
psingla
- Mar 8th, 2010
Truncate:Deletes all the record from the table.keeps no entry in log file.so rollback is not possiblefast in operation than delete.Its a DDL statementReset the identity column value to 1 (specific to ...
vasumathi.sridharan
- May 26th, 2009
Delete is a DML StatementTruncate is a DDL StatementDelete can be rolledbackTruncate cannot be rolledback The memory occupied by the table will be released in Truncate.That is Not the case with DeleteTruncate cannot use a where clauseDelete can use a where clauseTruncate is faster than Delete.
Difference between a "where" clause and a "having" clause?
Read Best Answer
Editorial / Best Answer
Answered by: Ankush Sharma
- Sep 14th, 2011
Though the HAVING clause specifies a condition that is similar to the purpose of a WHERE clause, the two clauses are not interchangeable. Listed below are some differences to help distinguish between the two:
1. The WHERE clause specifies the criteria which individual records must meet to be selcted by a query. It can be used without the GROUP BY clause. The HAVING clause cannot be used without the GROUP BY clause.
2. The WHERE clause selects rows before grouping. The HAVING clause selects rows after grouping.
3. The WHERE clause cannot contain aggregate functions. The HAVING clause can contain aggregate functions.
for Example: if for an "Select" statement we use the "where" clause then the the result based on the "where" condition results and then we can use "group by" clause to arrange in some order, Now if we want to impose the condition on that group then we use "having" clause.
The main reason for using WHERE clause is to select rows that are to be included in the query. For example, assume table Test.Suppose I want the names, account numbers, and balance due of all customers from California and Los Angles. Since STATE is one of the fields in the record format, I can use WHERE to select those customers.
Using the codeCode- span style="color: #ff0000;">'CA', 'LA'Suppose I want the total amount due from customers by state. In that case, I would need to use the GROUP BY clause to build an aggregate query.
Using HavingCodeCode
Ankush Sharma
- Sep 14th, 2011
Though the HAVING clause specifies a condition that is similar to the purpose of a WHERE clause, the two clauses are not interchangeable. Listed below are some differences to help distinguish between ...
Ankush Sharma
- Sep 14th, 2011
Though the HAVING clause specifies a condition that is similar to the purpose of a WHERE clause, the two clauses are not interchangeable. Listed below are some differences to help distinguish between ...
What is the difference between "procedure" and "function"?
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
- 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...
What is query of display the all tables in SQL server ?
Read Best Answer
Editorial / Best Answer
santanukd- Member Since May-2008 | May 14th, 2009
Just replace "[your-schema-name-here]" in the following query with your schema name. Hope it comes handy to some of you out there.
Select OBJECT_TYPE,OBJECT_NAME
FROM
(
Select 'TABLE' as OBJECT_TYPE, TABLE_NAME as OBJECT_NAME, TABLE_SCHEMA as OBJECT_SCHEMA from information_schema.VIEWS
Union
Select 'VIEW' as OBJECT_TYPE, TABLE_NAME as OBJECT_NAME, TABLE_SCHEMA as OBJECT_SCHEMA from information_schema.VIEWS
Union
Select 'INDEX[Type:Name:Table]' as OBJECT_TYPE, concat(CONSTRAINT_TYPE,' : ',CONSTRAINT_NAME,' : ',TABLE_NAME) as OBJECT_NAME,TABLE_SCHEMA AS OBJECT_SCHEMA from information_schema.TABLE_CONSTRAINTS
Union
Select 'Procedure/Functions' as OBJECT_TYPE, ROUTINE_NAME as OBJECT_NAME, ROUTINE_SCHEMA as OBJECT_SCHEMA from information_schema.ROUTINES
) R
Where R.OBJECT_SCHEMA=[your-schema-name-here]Keer
- Apr 25th, 2012
Select * from sys.tables where type = U
saikiran
- Jul 22nd, 2011
Select * from sys.tables
Fetching records from attributes
How will you fetch records having underscore ( _ ) in the middle of of strings, from columns having attributes as "amit_6", "t_mit06", "am_06", "m_t", "j_x_t" ?
How will you copy the structure of a table without copying the data?
Read Best Answer
Ans