Can a stored procedure call another stored procedure. If yes what level and can it be controlled?2 6218
Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?2 15763
How do you find the number of rows in a table?7 13289
Difference between Cluster and Non-cluster index?32 123856
What is a table called, if it does not have neither Cluster nor Non-cluster Index?2 6944
Explain DBMS, RDBMS?6 19488
Explain basic SQL queries with SELECT from where Order By, Group By-Having?3 17750
Explain couple pf features of SQL server2 4024
Explain fundamentals of Data ware housing & OLAP?2 5609
Explain the new features of SQL server 2000?1 4556
Explain sp_configure commands, set commands?3 9263
what are the Prerequisites for Replication?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
how to take backup bcp out for a column in table in sql server?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
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.
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
what is checksum in sql server.........???
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
how can you attach more than 20 ldf files in sql server
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
Does any body please help me what question's have asked for SSRS in the interview?
If a stored procedure is taking a table data type, how it looks?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?