GeekInterview.com
  I am new, Sign me up!
 

SQL Server FAQs


SQL Server FAQs

Questions: 68
Comments: 104
 SQL Server FAQs Tags
 Showing Questions 31-40 of 68 Questions
<< Previous 1 2 3 [4] 5 6 7 Next >>
 Sponsored Links

 
 SQL Server FAQs
Sorting Options :  

Latest Answer: For primary key if that record is being refered by some other (Child Table)  sql server won't let you to delete that record.While creating relationship if you had mention "Delete Cascade" option and then if you delete the ...

It's working in MySQL but not in SQL-Server. 
Latest Answer: Use a procedure which will delete record from child table first and then it will delete the same record from parent tableSame thing can be achieved using cascade delete and cascade update, this feature was not there in sql server 7.0 ...
Read Answers (3) | Asked by : kathir

Latest Answer: select * from sysdatabases ...
Read Answers (2) | Asked by : Gokul


Latest Answer: Take a full backup and restore or dettach 2000 db copy .mdf and ldf to 2005 server.  Attach then switch compatiblity mode to 90 then update statistics.  Once you go to 2005 you can go back. ...
Read Answers (1) | Asked by : santanu

Latest Answer: select * into new table name from old table name where 1=0 ...
Read Answers (2) | Asked by : mvkrishna

Latest Answer: Architecture is the frame work of the Database Management System. They are simply classified into logical and physical. ...
Read Answers (1) | Asked by : dharmendra
Tags : DBMS

Latest Answer: We can copy the Table structure also from one table to another tableExample:                   CREATE table emp1 as                    ...
Read Answers (3) | Asked by : penchal

Suppose you create a students record with 5 marks, total and average.How to filter the top 3 students which are getting high average.
Read Answers (3) | Asked by : P.Prabhakaran

How to use the pivot option in MS SQL Server 2005 and How to convert the regular columns into pivoted columns explain with an example

View page << Previous 1 2 3 [4] 5 6 7 Next >>

Ask A Question
Go Top
 Sponsored Links

 
Sponsored Links

 
Ask Question
You must login to Ask Question or Register your free account

Category:

 
Question Title:


Question in Detail:

Add this to my Subscribed Questions (?)
Send me email when new answer is posted (?)

 
Subscribe
Get Latest Updates Via RSS Reader or by Email
 Forum Discussion Subscribe to Forum Discussions Via E-Mail Latest Forum Discussions Subscribers
 Knowledge Base Subscribe to Knowledge Base Series Via E-Mail Knowledge Base Subscribers
 Learning Series Subscribe to GeekInterview Learning Series Via EMail Learning Series Subscribers
 Freelance Jobs Subscribe to GeekInterview Freelance Jobs Via EMail Latest Freelance Jobs Subscribers
 GeekInterview Blog Subscribe to GeekInterview Blog Via EMail GeekInterview Blog Subscribers
 Testing Interview Questions Subscribe to Testing Interview Questions Via EMail Testing Interview Questions Subscribers
 Oracle Interview Questions Subscribe to Oracle Interview Questions Via EMail Oracle Interview Questions Subscribers
 Java Interview Questions Subscribe to Java Interview Questions Via EMail Java Interview Questions Subscribers
 Latest Placement Papers Subscribe to Latest Placement Papers Placement Papers Subscribers
 Free Training Subscribe to Free Training Via EMail Free Training Subscribers
 Learn AJAX Subscribe to AJAXwith.com Via EMail AJAXwith Subscribers
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape