I just installed SQL Server 2008 Express on my Vista SP1 machine. I previously had 2005 on here and used it just fine with the old SQL Server Management Studio Express. I was able to connect with no problems to my PC-NAME\SQLEXPRESS instance (no, PC-NAME is not my computer name ;-). I uninstalled 2005 and … Read more
Using T-SQL and Microsoft SQL Server I would like to specify the number of decimal digits when I do a division between 2 integer numbers like: select 1/3 That currently returns 0. I would like it to return 0,33. Something like: select round(1/3, -2) But that doesn’t work. How can I achieve the desired result? … Read more
How do you view ALL text from an NTEXT or NVARCHAR(max) in SQL Server Management Studio? By default, it only seems to return the first few hundred characters (255?) but sometimes I just want a quick way of viewing the whole field, without having to write a program to do it. Even SSMS 2012 still … Read more
I am trying to compare two tables, SQL Server, to verify some data. I want to return all the rows from both tables where data is either in one or the other. In essence, I want to show all the discrepancies. I need to check three pieces of data in doing so, FirstName, LastName and … Read more
I have an existing table called Persion. In this table I have 5 columns: persionId Pname PMid Pdescription Pamt When I created this table, I set PersionId and Pname as the primary key. I now want to include one more column in the primary key – PMID. How can I write an ALTER statement to … Read more
This question already has answers here: How to create table using select query in SQL Server? (4 answers) Closed 8 years ago. I want to create a table from select query result in SQL Server, I tried create table temp AS select….. but I got an error Incorrect syntax near the keyword ‘AS’ 6 Answers … Read more
I have a backup of Database1 from a week ago. The backup is done weekly in the scheduler and I get a .bak file. Now I want to fiddle with some data so I need to restore it to a different database – Database2. I have seen this question: Restore SQL Server database in same … Read more
I would like to write a query on a sql 2008 that will report all the users that have access to a specific database, or objects within the database such as tables, views, and stored procedures, either directly or due to roles, etc. This report would be used for security auditing purposes. Not sure if … Read more
I’m trying to write a script that will completely empty a SQL Server database. This is what I have so far: USE [dbname] GO EXEC sp_msforeachtable ‘ALTER TABLE ? NOCHECK CONSTRAINT all’ EXEC sp_msforeachtable ‘DELETE ?’ When I run it in the Management Studio, I get: Command(s) completed successfully. but when I refresh the table … Read more
When I submit a batch (e.g., perform a query) in SSMS, I see the time it took to execute in the status bar. Is it possible to configure SSMS to show the query time with millisecond resolution? Here is the bar I am talking about with the section of interest circled in red: 8 Answers … Read more
