sql Archives - Page 38 of 45

Also, when is it appropriate to use one? 13 s 13 An index is used to speed up searching in the database. MySQL ...

I need to retrieve all rows from a table where 2 columns combined are all different. So I want all the sales that ...

Is it possible to specify a condition in Count()? I would like to count only the rows that have, for example, “Manager” in ...

I need to change the primary key of a table to an identity column, and there’s already a number of rows in table. ...

How can I delete duplicate rows where no unique row id exists? My table is col1 col2 col3 col4 col5 col6 col7 john ...

Using SQL Server, how do I split a string so I can access item x? Take a string “Hello John Smith”. How can ...

In SQL Server 2005 I have a table cm_production that lists all the code that’s been put into production. The table has a ...

I’ve got a table with two columns, ID and Value. I want to change a part of some strings in the second column. ...

What is the best way (performance wise) to paginate results in SQL Server 2000, 2005, 2008, 2012 if you also want to get ...

Assume you have a flat table that stores an ordered tree hierarchy: Id Name ParentId Order 1 'Node 1' 0 10 2 'Node ...