What is T-SQL means? How it is different from SQL?

psingla

 Profile Answers by psingla Questions by 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

 Profile Answers by ajitnayak Questions by 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.

Answer Question  Select Best Answer

shabanabegum

 Profile Answers by shabanabegum Questions by shabanabegum

• Dec 9th, 2009

Exec sp_rename 'oldtablename.oldcolmnname','newcolumnname'for example Exec sp_rename 'employee.DateofBirth','DOB'Thanks

vadukiya_piyush

 Profile Answers by vadukiya_piyush Questions by vadukiya_piyush

• May 21st, 2009

Exec sp_rename 'tablename.columnname','newcolumnname'

Answer Question  Select Best Answer

jinuvarg

 Profile Answers by jinuvarg Questions by jinuvarg

• Nov 3rd, 2009

System.Data.Sqlclient

rakesh_mwisp

 Profile Answers by rakesh_mwisp Questions by rakesh_mwisp

• Aug 1st, 2008

SQLConnection is one of the class in System.Data.SqlClient Namespace.

Answer Question  Select Best Answer

How do you BCP only a certain set of rows out of a large table?

snigd

 Profile Answers by snigd Questions by snigd

• Oct 7th, 2009

WHERE cluase can be used with bcp commands and all the conditions can be mentioned in the query to generate the set of rows you want to copy.

Answer Question  Select Best Answer

zeekhan

 Profile Answers by zeekhan Questions by zeekhan

• Aug 12th, 2009

Inner Join returns matching records onlyA full outer join returns all rows in both the left and right tables

sa_dub

 Profile Answers by sa_dub Questions by sa_dub

• May 4th, 2009

Inner Join is used to join two coloumns of the same table which have some same attributes but Outer Join used for join two coloumns of different tables which have unmached attributes.

Answer Question  Select Best Answer

prathima

 Profile Answers by prathima Questions by prathima

• Jul 25th, 2009

Select top 5 avg(rank) from table_name group by rank order by rank desc

cybersavvy

 Profile Answers by cybersavvy Questions by cybersavvy

• Feb 19th, 2009

Select top 3 * from students order by average desc

Answer Question  Select Best Answer

Which TCP/IP port does SQL Server run on? How can it be changed?

sonalimajumdar

 Profile Answers by sonalimajumdar Questions by sonalimajumdar

• Jul 17th, 2009

SQL server works on 1433 port and DAC (dedicated admin connection ) works on 1434 port. You can change the port number SQL server should use through SQL net configuration manager.

Answer Question  Select Best Answer

You are required to design a social networking site. Set of all those people who are friend of friends your friends would be consider to be in your network. Write a SQL query to print Number of people in your network. You need to create a profile of each user and store his/her photographs. How would you go about doing the same using database?

gudluck

 Profile Answers by gudluck Questions by gudluck

• Jul 11th, 2009

Answer for ist part of the question:Create 2 tables mapidandnames and friendsTable:mapidandnamesid    name--------------  1    a  2  &n...

Answer Question  Select Best Answer

yatinhatkar

 Profile Answers by yatinhatkar Questions by yatinhatkar

• Jun 18th, 2009

Data objects are basic runtime entities.

Rekha

• Jan 15th, 2007

Stored procedures,views,tables,database diagrams are the data objects

Answer Question  Select Best Answer

sushilmishra

 Profile Answers by sushilmishra Questions by 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

 Profile Answers by praveen34.tit Questions by 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...

Answer Question  Select Best Answer

jannani

 Profile Answers by jannani Questions by jannani

• May 12th, 2009

SQL profiler is a graphical tool that allows system administrator to monitor in an instance of the SQL Server.Use of SQL Profiler:Monitor the performance of an instance of SQL Server.Debug Transact-SQ...

ak

• Nov 29th, 2005

It's a tool that ships with SQL Server to profile sql querie and fine tune slow performance degrading sql queries by looking at how sqlsever executes them . It contains tools like index tuni...

Answer Question  Select Best Answer

jjvetri

 Profile Answers by jjvetri Questions by jjvetri

• May 8th, 2009

CREATE TABLE dbo.SalesByQuarter ( Y INT, Q INT, sales INT, PRIMARY KEY (Y,Q) ) GO INSERT dbo.SalesByQuarter(Y,Q,Sales) SELECT 2003, 2, 479000

gvs

 Profile Answers by gvs Questions by gvs

• Jan 3rd, 2008

Using Pivot Option in MS SQL Server 2005.

Answer Question  Select Best Answer

Swapna85

 Profile Answers by Swapna85 Questions by Swapna85

• May 4th, 2009

In SQL Server, objects like tables, views, stored procedures and so on that occupy space are called data objects.

sari_pot

 Profile Answers by sari_pot Questions by sari_pot

• Oct 18th, 2007

Views,indexes,stored procedures,user-defined functions and triggers

Answer Question  Select Best Answer

srialekhya

 Profile Answers by srialekhya Questions by 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

 Profile Answers by sidver Questions by 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...

Answer Question  Select Best Answer

How to insert bulk data into the SQL Server?

clickfreehit

 Profile Answers by clickfreehit Questions by 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 

Answer Question  Select Best Answer

What are the differences between sqlserver 2000 and sql server 2005

deepintl

 Profile Answers by deepintl Questions by 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

 Profile Answers by khwaja MOhammad Sohail Questions by 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...

Answer Question  Select Best Answer

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.

charanpathania

 Profile Answers by charanpathania Questions by charanpathania

• Apr 1st, 2009

The datatype of the both the columns used in relation must be the same

Answer Question  Select Best Answer

What will you do if a trigger fails during execution?

charanpathania

 Profile Answers by charanpathania Questions by charanpathania

• Apr 1st, 2009

Rollback your transaction

bugeye

 Profile Answers by bugeye Questions by 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. 

Answer Question  Select Best Answer

mragu1986

 Profile Answers by mragu1986 Questions by 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.

Answer Question  Select Best Answer

Write an SQL query if you want to select the data from one block which intern reflects in another block?

rshanmugaraj84

 Profile Answers by rshanmugaraj84 Questions by rshanmugaraj84

• Mar 5th, 2009

Select *from(Select *from ) a

Answer Question  Select Best Answer