sql database suspect
We have a sql database that is showing as suspect. How can we recover?
No Answer is Posted For this Question
Be the First to Post Answer
How to test odbc dsn connection settings?
Why do you need a sql server?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
what is the information that can be stored inside a bit column? : Sql server database administration
what are the disadvantages of cursors? : Sql server database administration
Write a SQL queries on Self Join and Inner Join.
Hi All, I want to display all duplicate records in the table. My query has to fetch all the records which are duplicate(First Name or Last Name). Also I want the ability to also pull names where there might be a middle initial placed in the end of the first name field, (i.e., "Maria Z. " vs. "Maria") as well. Please guide me to find this. Table: ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 4 Shawn Livermore 5 Prem S 6 Jony Hoffman H 7 Zach Modan I need the query to filter......... ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 6 Jony Hoffman H 7 Zach Modan I hope this example will give you clear idea..... Thanks in Advance Prem
Explain about SQLOS?
Why we need to use secondry database file? though, we can do same work using primary database file also.
What is the difference between temp table and table variable?
Diff between Composite key, Alternate Key, Candidate Key, Primary Key, Unique Key, Super Key, Foreign Key
What is sql injection? How to protect against sql injection attack?