How do I escape a single quote in SQL Server?
I am trying to insert some text data into a table in SQL Server 9. The text includes a single quote ‘. How … Read more
sql-server
What do Clustered and Non-Clustered index actually mean?
I have a limited exposure to DB and have only used DB as an application programmer. I want to know about Clustered and … Read more
Difference between JOIN and INNER JOIN
Both these joins will give me the same results: SELECT * FROM table JOIN otherTable ON table.ID = otherTable.FK vs SELECT * FROM … Read more
SQL Server – Best way to get identity of inserted row?
What is the best way to get IDENTITY of inserted row? I know about @@IDENTITY and IDENT_CURRENT and SCOPE_IDENTITY but don’t understand the … Read more
Altering a column: null to not null
I have a table that has several nullable integer columns. This is undesirable for several reasons, so I am looking to update all … Read more
Check if table exists in SQL Server
I would like this to be the ultimate discussion on how to check if a table exists in SQL Server 2000/2005 using SQL … Read more
How can I remove duplicate rows?
What is the best way to remove duplicate rows from a fairly large SQL Server table (i.e. 300,000+ rows)? The rows, of course, … Read more
How can I do an UPDATE statement with JOIN in SQL Server?
I need to update this table in SQL Server with data from its ‘parent’ table, see below: Table: sale id (int) udid (int) … Read more
Find all tables containing column with specified name – MS SQL Server
Want to improve this post? Provide detailed answers to this question, including citations and an explanation of why your answer is correct. without … Read more
Get size of all tables in database
I have inherited a fairly large SQL Server database. It seems to take up more space than I would expect, given the data … Read more