My SQL Server 2008 is going into Single User Mode, and also I've been researching and I think that has a backup performed by a virtual machine, you must have something to do and how and reverse it?

I have the table | ID |item_code| item_name | | 1 | 12345 | abc | | 2 | 12345 | xyz | | 3 | 11221 | abc | | 4 | 19261 | www | | 5 | 12345 | abc | | 6 | 62898 | abc | | 7 | 92648 | xxx |...

i have one category table and other is product table. category id is the forigen key in product table. i want to get category name along with its count that how many time each category id exist in product table. table= category columns: categoryid,category name table = products column: produ...

Restarting the server should be enough - those worktables should clear out. But I'd probably start it up in single user mode (-m) to prevent other processes from creating worktables before you successfully remove those files. Then redefine the files required for tempdb; perhaps deleting unnecess...

Using object explorer in SSMS, find the table in question and expand the node so you see the Columns, Keys, Constraints, Triggers, Indexes, and Statistics Drag the Columns folder into the query window pane. This results in a column-space delimited list of the columns in a single line. We're goi...

Good evening stackoverflow community, I have a problem with a sql-query for my database. I want to get the last n-entries of a specific Table. Usually I would perform the following query: 'Select Top 1000 (*) FROM Table ORDER BY Column DESC', but the problem is, that the table contains a lot of ...

i am doing a mobile application project that will allow students to access question form the database and answer them and given answers at the end. the application will cover maths, chemistry, biology and physics. i want to create a MySQL database but i do not know the table names and their struc...

I'm really interested in learning SQL (SQL server or Oracle) as I already have a bit of experience with the databases at work (mostly select statements). I don't have a technical background since I was a humanities graduate in college. I'm already starting to read about SQL and maybe take a SQL s...

i'm trying to achieve the following with tsql What i have in my table looks like this A B C 3 what i want to have is A B C 1 A B C 1 A B C 1 to split it based on the quantity column 4.. Not sure what function to use. Any help would be appreciated thanks.

Joined a start up that had virtually no database documentation and was not happy with the extremely verbose SSMS auto documentation creation utilities, such as SQL Doc, so I decided to create my own that outputs text that can generate an html file and to have more control of what is included. Thi...

Using AdventureWorks, if we look at these two equivalent queries: SELECT OrderDate FROM Sales.SalesOrderHeader WHERE DATEDIFF(month,OrderDate,GETDATE()) BETWEEN 1 AND 7; SELECT OrderDate FROM Sales.SalesOrderHeader WHERE OrderDate >= DATEADD(MONTH, -7, GETDATE()) AND OrderDate <= DATEADD(MONT...

SELECT source, SUM(quoted = 1) AS quotes, SUM(solds = 1) AS solds FROM yourtable GROUP BY Source

My sql server 2008 is going into Single User mode alone every Monday when he performs a backup just that there's nothing wrong with my back but still it comes in unique User

Here's a better script. It doesn't use the awful INFORMATION_SCHEMA views. It doesn't place GO inside T-SQL, which won't work if you execute the command dynamically (since GO is a batch separator for interactive tools like SSMS, not a T-SQL keyword). It doesn't have incorrectly copied apostroph...

Here are the titles from the past two months: https://docs.google.com/a/stackoverflow.com/spreadsheets/d/1RJjQmf9v2bkEwuo39TZH_eSfpaTLWYovWFtLN67YEz8/ I cheated a bit and only listed questions that were deleted by a binding Spam flag from a moderator, but that should account for the majority of...

Is there a way to use intersect without selecting distinct values only? Something like INTERSECT ALL. For example, consider table A and B A --> 1, 1, 1, 2, 3, 4 B --> 1, 1, 2 Would result in Result --> 1, 1, 2 EDIT I think this link explains well what I want. This other link is also inte...

After a little bit of tinkering I figured that difference between MS SQL and iSeries is that iSeries allows to use alias on the table being updated, which can be used in WHERE clause: UPDATE t1 t SET a = ( SELECT t2.a FROM t2 WHERE t2.b = t.b ) And the syntax for updating multiple ...

The answer to my specific instance of this issue was permissions. The DBA had to add datareader rights to the system schema on master for my user profile. Once this was done, everything worked as intended. He tried adding dbo owner rights, and granting view definition to just sys.procedures and...

Since you are doing a union all the data type should match. try the following.... select ID, Attrib, Value from EmpDetails cross apply ( select 'DOB', CAST(DOB AS VARCHAR(10)) union all select 'Name', Name union all select 'Salary', CAST(Salary AS NVARCHAR(100)) union all select 'Email', ...