SQL Server Errors Interview Questions And Answers

The Transmission Control Protocol (TCP) is one of the
central protocols of the Internet Protocol Suite. TCP is
one of the two original components of the entire Internet
Protocol Suite, commonly referred to as TCP/ IP. IP
manages the lower-level transmissions from machine to
machine and TCP functions at a higher level, concerned only
with the two end computers.

TCP (Transmission Control Protocol) is the major transport
protocol utilized in IP networks. The TCP protocol exists
on the Transport Layer of the OSI Model. The TCP protocol
is a connection-oriented protocol which provides end-to-end
reliability.


By connection-oriented, we mean that before two network
nodes can communicate using TCP, they must first complete a
handshaking protocol to create a connection. When we say
that TCP provides end-to-end reliability, we mean that TCP
includes mechanisms for error detection and error
correction between the source and the destination.

These properties of TCP are in contrast to UDP, which is
connectionless and unreliable.Higher layer protocols which
utilize TCP include HTTP, SMTP, NNTP, FTP, telnet, SSH,
and LDAP.

UPDATE temp SET = REPLACE(Policyno,'134527','R-KT-SK-EA-134527') WHERE Policyno = '134527'

UPDATE temp SET = 'R-KT-SK-EA'+ Policyno WHERE Policyno = '134527'

UPDATE temp SET = 'R-KT-SK-EA'+ Policyno WHERE policyno not like 'R-KT-SK-EA-%'

Struggled with this one for 2 days and went through tons of
forums till I found this one:

http://social.msdn.microsoft.com/Forums/en-
US/sqlsetupandupgrade/thread/84b399b5-7d7b-46fa-8f86-
8c9af2cbf641

SokSa.Icy had the right idea.

My particular problem also involved going through the
registry to remove all instances of Visual Studio 2008 as
well as a .Net 3.5 hotfix that I could not get rid of.

Once I uninstalled and did everything this guy did, I also
went through the registry and searched/deleted all
instances of the framework hotfix to get it out of the
add / remove dialog box in control panel.

I also used wise registry cleaner to make sure I got all
inconsistencies out of the way, rebooted, and
installed .net 2.0 Express.

After a successful installation, I rebooted again and ran
sql server 2005 express installation and presto - back in
business...

HTTP means HyperText Transfer Protocol and 500 is internal
server error if there is no proper proxy defined if it is
required.

If you have 321 field,
followed this steps
1)open sql.
2)change dir. if ncecessary.
3)then give command
SQL>desc table_name.
4)check the fields.
5)select or copy that field name.
6)and then use that field in like select empno,empname from
emp.
7) use same script in procedure
8) and show your feilds in your screen.

virus means very important resource under seize
it is a programm written by some one which makes ur system
corrupt

CREATE TABLE Sample
(
Col1 varchar(5)
)
insert into Sample values('j')

TABLE:
Col1
j
r
c
r
e
f
g
h
x
j

USING CURSOR: ANSWER

DECLARE @COL1 VARCHAR(5)
DECLARE @COUNT VARCHAR(5)
SET @COUNT=0
DECLARE c1 CURSOR
FOR
SELECT COL1 FROM SAMPLE
OPEN C1
FETCH NEXT FROM C1
INTO @COL1
WHILE @@FETCH_STATUS=0
BEGIN
SET @COUNT=@COUNT+1
IF @COUNT>=5
BEGIN
SELECT @COL1
END
FETCH NEXT FROM C1
INTO @COL1
END
CLOSE C1
DEALLOCATE C1

Reason why SQLcode -922 generated:

Authorization failed because of the error indicated by error-type

It can be any of the following..

* User authorization.
* Plan access
* connect
* Installation error
* Duplicate exit requested.

Reason code: DB2® reason code associated with authorization failure

if you know about database then yau can simply solve this
problem .and if you don't know about database then you
can't solve this problem.

in c and c++ there will be a compilation error.if when we declared an array size of 10 and tries to access 11th item.