sql-server Archives - Page 37 of 39

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 ...

April 14, 2022
0 Comments

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 ...

April 14, 2022
0 Comments

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 ...

April 13, 2022
0 Comments

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 ...

April 13, 2022
0 Comments

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 ...

April 13, 2022
0 Comments

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 ...

April 13, 2022
0 Comments

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, ...

April 13, 2022
0 Comments

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) ...

April 12, 2022
0 Comments

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 ...

April 12, 2022
0 Comments

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 ...

April 12, 2022
0 Comments