sql-server-2008 Archives - Page 4 of 7

SQL Server. How to refresh the intellisense? [duplicate]

This question already has answers here: Closed 10 years ago. Possible Duplicate: Lost the IntelliSense SQL Server 2008 Intellisense problem I’m new to ...

May 21, 2022
0 Comments

SQL Server Configuration Manager not found

After installing SQL Server 2008, I cannot find the SQL Server Configuration Manager in Start / SQL Server 2008 / Configuration Tools menu. ...

May 21, 2022
0 Comments

How to write UPDATE SQL with Table alias in SQL Server 2008?

I have a very basic UPDATE SQL – UPDATE HOLD_TABLE Q SET Q.TITLE = 'TEST' WHERE Q.ID = 101; This query runs fine ...

May 21, 2022
0 Comments

Check if a row exists, otherwise insert

I need to write a T-SQL stored procedure that updates a row in a table. If the row doesn’t exist, insert it. All ...

May 21, 2022
0 Comments

How to update Identity Column in SQL Server?

I have SQL Server database and I want to change the identity column because it started with a big number 10010 and it’s ...

May 21, 2022
0 Comments

What is the maximum characters for the NVARCHAR(MAX)? [duplicate]

This question already has answers here: What is the maximum number of characters that nvarchar(MAX) will hold? (3 answers) Closed last year. I ...

May 21, 2022
0 Comments

“Prevent saving changes that require the table to be re-created” negative effects

Preamble I was modifying a column in SQL Server 2008 today, changing the datatype from something like currency(18,0) to (19,2). I got the ...

May 20, 2022
0 Comments

How can I group by date time column without taking time into consideration

I have a bunch of product orders and I’m trying to group by the date and sum the quantity for that date. How ...

May 20, 2022
0 Comments

Unique constraint on multiple columns

CREATE TABLE [dbo].[user]( [userID] [int] IDENTITY(1,1) NOT NULL, [fcode] [int] NULL, [scode] [int] NULL, [dcode] [int] NULL, [name] [nvarchar](50) NULL, [address]...

May 19, 2022
0 Comments

SQL Server principal “dbo” does not exist,

I am getting the following error Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal ...

May 19, 2022
0 Comments