Un-Answered Questions { SQL Server }

plss anybody specify tha constrian management system in dbms

1564


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

1298


sql database suspect We have a sql database that is showing as suspect. How can we recover?

1395


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?

1287


how to overcome kernel isssues

1166


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.

1087


what is checksum in sql server.........???

1196


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1049


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

1207


What is Lock table in SQL?

995


Call by value and call by reference in procedure and function, with NOCOPY.

827


If we delete pack Spec what will be the status of pack Body ?

961


Delete duplicate rows without using rowid.

1061


Explain few examples of stored procedure over triggers?

507


What are the different types of backups that exist?

674