Which system tables contain information on privileges granted and privileges obtained1 5199
Which system table contains information on constraints on all the tables created?2 4949
what command is used to create a table by copying the structure of another table?7 9388
What is the advantage of specifying WITH GRANT OPTION in the GRANT command?2 7219
What is the use of CASCADE CONSTRAINTS?3 7813
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...936
What are the type of Indexes? which one is best, why?6 5428
I have student marks in a student table. I need second highest mark .Then what will the query for this?34 36940
Difference between writing SQL query and stored procedure ?15 62264
Working with TLogs
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
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
OPTIMIZATION OF SP,CURSOR,TRIGGERS
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
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?
New concepts of sql server 2005 use in your project.
your distribution database is full what will u do
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
What is best institute to Learn DotNET And SQL in chennai?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that