Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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

HCL SQL Server Interview Questions
Questions Answers Views Company eMail

What is the difference between windows authentication and sql server authentication

7 19931

how can i store resumes in database?

3 7959

I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000

17 13961

Difference between sql server 2000 and sql server 2005?

11 47805

CLR Integration ? what is Notification services ?

1 3981





what is Constraint? How many types of constraints in SQL ?

38 73047

Why Do you want to work in this company?

4 4926

how to delete duplicate rows from table in sql server

12 17506

What is cursor ? And what is difference between Trigger ?

3 28160

how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100

6 14612

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 6912

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1230

which one will take 1st priority in case of insert statement and select statement???

2 4646

how we can use a database with php.

2 2626

Can store procedure call by user define function in SQL server?

10 14420

Post New HCL SQL Server Interview Questions




HCL SQL Server Interview Questions


Un-Answered Questions

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

281


How do you access a constant field declared in a class?

250


How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

1351


what is basic difference betmeen normal & flame proof motor??

1145


Explain about the configuration of a summary view?

25






What is property and its types?

1


What is the difference between a local and a global temporary table?

319


What do you mean by checked exceptions?

275


What about the test case if the field only takes a certain number of characters or a minimum number?

360


Is php session id unique?

253


How many categories in service contracts what are those?

908


i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

2730


Draw the E-R diagram for the database of a departmental store having the following relational database scheme Employees(e-no, address) Department(d-name) work-n(e-no, d-name) Looking-after(d-name, e-no) Item (item-no, brand-name, model-no, cost-price, sale-price)

12013


Can you have top of page and end of page ? How ?

43


In which department you would like to go : Operations or Sales?

314