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

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


SQL Server Interview Questions
Questions Answers Views Company eMail

what is performance tunning in sql server ? explain.

Thomson Reuters,

1 3253

CTE(common table expression)

Thomson Reuters,

1 7304

how to find maximum identity number in a table ?

JPMorgan Chase, Thomson Reuters, Wipro,

2 11434

what is Covering Index ?

Thomson Reuters,

3 5619

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

Satyam,

1533

Diffrences between sql server 2000 vs 2008

TCS,

1482

please give me query code of unique fuction select UNIQUE (name) from emp_info Incorrect syntax near the keyword 'UNIQUE'.

TCS,

1 5465

how can we know that how many users are connected in perticuler server??????

 2 4334

how to delete duplicate rows in sql server2005

Cisco, CTS, HCL, IBM,

7 10504

how to insert the values in 5 table at a time with triggers . if u have any solution then co-operate me ?

 1 2712

how to insert the values in 5 table at a time Using any single statement ?

Infosys, Value Labs,

6 9065

hi ..i am working as a sql dba.....now i want to learn more about t-sql..... is it possible to learn online.... plz refer any site ..thankq

IBM,

2373

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

 1232

If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

Ness Technologies,

1 3763

What are the benefits of using stored procedures over sql statements?

Ness Technologies,

3 6736

Un-Answered Questions { SQL Server }

What are policy management terms?

402

Can another user execute your local temporary stored procedures?

383

What is the xml datatype?

466

What is checkpoint process in the sql server?

402

What is the difference between cube operator and rollup operator? : SQL Server Architecture

411




What is the difference between functions and scalar functions?

417

What does the on update no action do?

453

How to add the custom code in Report?

69

Which are the new data types introduced in sql server 2008?

358

How to filter records of table in SQL SERVER?

449

What is the difference between varchar and varchar types?

399

What are the approximate numeric data types?

388

Why do you need a sql server?

363

How to create a new login name in ms sql server?

391

How do I find my localdb version?

338

For More Un-Answered { SQL Server } Questions Click Here