Can a stored procedure call another stored procedure. If yes what level and can it be controlled?2 6164
Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?2 15596
How do you find the number of rows in a table?7 13174
Difference between Cluster and Non-cluster index?32 123342
What is a table called, if it does not have neither Cluster nor Non-cluster Index?2 6854
Explain DBMS, RDBMS?6 19412
Explain basic SQL queries with SELECT from where Order By, Group By-Having?3 17573
Explain couple pf features of SQL server2 3967
Explain fundamentals of Data ware housing & OLAP?2 5557
Explain the new features of SQL server 2000?1 4514
Explain sp_configure commands, set commands?3 9125
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
where the connection string store in the database
How we create SQL Server 2005 Reporting Services ? Give me Sample
application server is slow what may be the problem
Which is the best place or learning center for MS SQL?????In Bangladesh?????
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
Scalability, Availability, Integration with internet, etc.)?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
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
If we delete pack Spec what will be the status of pack Body ?
what is package and it uses and how can u call a package
how can u get last observation in an unknown dataset ?
how to take backup bcp out for a column in table in sql server?
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
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