sql-server-2008 Archives - Page 3 of 7

I just installed SQL Server 2008 Express on my Vista SP1 machine. I previously had 2005 on here and used it just fine ...

Using T-SQL and Microsoft SQL Server I would like to specify the number of decimal digits when I do a division between 2 ...

How do you view ALL text from an NTEXT or NVARCHAR(max) in SQL Server Management Studio? By default, it only seems to return ...

I am trying to compare two tables, SQL Server, to verify some data. I want to return all the rows from both tables ...

I have an existing table called Persion. In this table I have 5 columns: persionId Pname PMid Pdescription Pamt When I created this ...

This question already has answers here: How to create table using select query in SQL Server? (4 answers) Closed 8 years ago. I ...

I have a backup of Database1 from a week ago. The backup is done weekly in the scheduler and I get a .bak ...

I would like to write a query on a sql 2008 that will report all the users that have access to a specific ...

I’m trying to write a script that will completely empty a SQL Server database. This is what I have so far: USE...

When I submit a batch (e.g., perform a query) in SSMS, I see the time it took to execute in the status bar. ...