Sign Up Login


Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

CTS SQL Server Interview Questions
Questions Answers Views Company eMail

how to retrive only second row from table in sql server 2000?

 15 23926

Can we create clustered index on non primary key column

 20 51531

What is the difference between 2-Tier architecture and 3-Tier architecture

 15 65356

What is difference between TRUNCATE and DELETE statement

 12 20266

What are the types of backup and tell me the difference between full and differential backup?

 4 12745

What is the difference between login and a user?

 13 28514

What is the difference between truncate and delete statement?

 6 7400

What is the difference between UNION and UNIONALL?

 5 12667

WHAT OPERATOR PERFORMS PATTERN MATCHING?

 2 6688

What is the order in which the SQL query is executed? list them in order.

 5 10873

Can Having clause be used without Group by clause?

 6 41636

what exactly sql injuction.how to overcome.....

 2251

what is difference between Enterprise Manager and Query Analyer

 6 8533

how to delete duplicate rows in sql server2005

 7 12334

Post New CTS SQL Server Interview Questions


CTS SQL Server Interview Questions


Un-Answered Questions

What is explain in db2?

761

Can anyone send me the what the scenario's client given in the real time,I mean functionalspecs,reporting scenarios?

1869

How do you program keyboard keys?

405

How are classes created in python?

620

What do you mean by roles based access control?

179

What are the properties of FFT? What happens when you pass a signal of 1000Hz through an FFT?????

1987

what is difference b/w "regio selectivity" & "sterio selectivity"

2207

Is the After report trigger fired if the report execution fails ?

2670

IF alternator SCR value will be high means what happen in alternator efficency at operating power factor of 0.8

3584

Can I have some basic interview questions on Cramer Development, OSS, COT etc? I am expecting an interview call from the client. I have 2 years of experience in Cramer development in a Telecom Industry.

6999

Explain the types of Managed Path

536

SELECT A~FTRMI A~AUFNR B~MATNR D~MAKTX B~PSMNG B~WEMNG C~MTART E~CHARG C~MATKL C~SPART R~BWART R~CHARG R~MATNR E~BWART R~BDMNG INTO TABLE ITAB FROM AFKO AS A INNER JOIN AFPO AS B ON A~AUFNR = B~AUFNR * INNER JOIN AFVC AS A1 ON A~AUFPL = A1~AUFPL AND B~DWERK = A1~WERKS INNER JOIN MARA AS C ON B~MATNR = C~MATNR INNER JOIN MAKT AS D ON C~MATNR = D~MATNR INNER JOIN MSEG AS E ON B~MATNR = E~MATNR AND A~AUFNR = E~AUFNR AND B~DWERK = E~WERKS INNER JOIN RESB AS R ON A~AUFNR = R~AUFNR AND E~AUFNR = R~AUFNR AND R~RSNUM = A~RSNUM AND R~WERKS = E~WERKS AND R~BAUGR = E~MATNR INNER JOIN MARA AS C1 ON R~MATNR = C1~MATNR WHERE A~FTRMI IN S_DATE AND A~AUFNR IN S_AUFNR AND C~MTART IN S_TYPE AND C~MATKL = 'T' AND R~BWART ='261' AND E~BWART = '101' AND R~XWAOK ='X' AND B~DWERK = '2000' AND R~XLOEK EQ SPACE AND E~KZBEW ='F' AND D~SPRAS = 'E' AND R~KZEAR = 'X' AND C~MATNR IN S_MATNR. This query gives repetative records from RESB.There must be some common field which i am not taking thats why its giving repetative records. If u find any solution pls lety me know ASAP. Thanks Swati Ghadge

3094

Why xml is used in web applications?

608

What is a uniformly distributed load?

858

Why can I not type in my excel spreadsheet?

431