GeekInterview.com
Series: Subject:

SQL Server FAQs

Showing Questions 61 - 79 of 79 Questions
First | Prev | | Next | Last Page
Sort by: 
 | 

Nested trigger levels

Asked By: Kal_CSharp | Asked On: Jan 22nd, 2008

How many levels a trigger can be nested? Explain about nested triggers.

Answered by: quietguy999 on: Jan 23rd, 2008

There are up to 32 nested trigger levels.

Optimisation and performance

Asked By: venugopal.pss | Asked On: Jan 10th, 2008

How optimisation and performance in SQL server 2000 can be achieved?What are the steps involved?

Which one is better windows authentication mode or a SQL server authentication mode?

Asked By: A.Gnanasekaran | Asked On: Apr 17th, 2007

Answered by: debasis.yours on: Dec 14th, 2007

Definitely Windows Authentication Mode. Firstly, the Windows security policy is used to authenticate is employed at user login reducing extra overhead. Secondly, if we implement any extra group policy...

SQL server backup error

Asked By: Ramesh.M | Asked On: Jun 3rd, 2007

Error while creating backup:i am creating fullbackup for one database named postings.I executed below query and I am getting the below error message.Use mastergoexec sp_addumpdevice 'disk','postingsbac','e:backuppostingsbac.Bak'backup database postings to postingsbacerror:'device created'one row effected.Server:...

Answered by: debasis.yours on: Dec 14th, 2007

This is basically a problem with the physical path of the Backup device, I suppose. Be sure the physical path that you are giving has full access from your Windows user Account or not.

How logical architecture of DBMS differs from physical architecture

Asked By: dharmendra | Asked On: Oct 9th, 2007

Answered by: vijaya_pitta on: Dec 12th, 2007

Architecture is the frame work of the Database Management System. They are simply classified into logical and physical.

When I am starting MySQL server ,dbserver is not getting initialized ?How to check that.

Asked By: Sharad | Asked On: Jan 18th, 2007

Answered by: teju on: Nov 5th, 2007

You have to connect your database first than you can open asly.....

On which tcp/ip SQL server works and how can it be changed

Asked By: raghukanth | Asked On: Aug 21st, 2007

Answered by: Chetna on: Oct 16th, 2007

SQL Server runs on port 1433. It can be changed from the Network Utility TCP/IP properties > Por number, both on client and the server.

What is a nested trigger?

Asked By: Sangeeta | Asked On: Jul 6th, 2007

Answered by: Chetna on: Oct 16th, 2007

If a Trigger is having Insert/Update/Delete statement of a table which is also having a trigger defined on it for Insert/Update/Delete, then Trigger1 would cause Trigger2 to get fired when a data Manipulation has occured. This is called nested trigger.

How to make all the field values to sentence case

Asked By: Nadeem | Asked On: May 25th, 2007

Ex. Smith,john,india

Answered by: Chetna on: Oct 16th, 2007

Save the query results to .csv file.

Assume that I have created a employees table which has 10 records. How to create a stored procedure to export all the records into the log file.

Asked By: vani | Asked On: Dec 14th, 2006

Answered by: dheeruchakri on: Oct 10th, 2007

Create Procedure TestExport
as
Begin

xp_cmdshell 'bcp "SELECT * from YourDatabase.dbo.YourTable" QueryOut d:Temptest.xls -S alexissqlsrv01 -U dpi -P Value*() -c -T'

End

All the Best.

- Dheeraj.

Answered by: Dheeraj Chakravarthy on: Oct 10th, 2007

Create Procedure TestExport
as
Begin

xp_cmdshell 'bcp "SELECT * from YourDatabase.dbo.YourTable" QueryOut d:Temptest.xls -S alexissqlsrv01 -U dpi -P Value*() -c -T'

End

All the Best.

- Dheeraj.

Where do we use @@rowcount

Asked By: sreevidya | Asked On: Jul 28th, 2007

Answered by: askvenki on: Aug 13th, 2007

It is to know the no of rows feched from cursor
It is used in situations like

We have to do the modifications up to five rows

Their is some situations to print up to no of rows fetched from cursor

In pl/sql table it is used like an array index to store values

Answered by: waqarali on: Jul 30th, 2007

In the stored procedures to the total counts of the rows affected by the query.

How is a database table managed, if it is being modified by two or more user's simultaniously?

Asked By: techmind | Asked On: Nov 27th, 2006

Answered by: genie_cool on: Jun 6th, 2007

use TableLocks or RowLocks to prevent the other user from modifying the data when the previous user is using the same data.

Answered by: vmandviya on: Feb 5th, 2007

See if two user are updating same time at same time it will affect one by one!! it means 1st user changes will accept then 2nd user changes it iwll accept

How can we implement caching in SQL server?

Asked By: gopikrishna | Asked On: Apr 10th, 2007

Large stored procedure formatting

Asked By: Pandian S | Asked On: Mar 21st, 2007

We have used a stored procedure having large code in it. If we try to alter the sp again then the entire code seems to be scrambled - why ?

First | Prev | | Next | Last Page

 

 

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Ads

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.