sql-server-2008 Archives

Programming, sql

IT Nursery

Select SQL Server database size

how can i query my sql server to only get the size of database? I used this : use "MY_DB" exec sp_spaceused I ...

June 4, 2022
0 Comments

Programming, visual-studio-2010

IT Nursery

How to find server name of SQL Server Management Studio

I installed Microsoft SQL Server 2008. When I start SQL Server Management Studio (SSMS), I get the Connect to Server login window with ...

June 3, 2022
0 Comments

Programming, sql

IT Nursery

How to check existence of user-define table type in SQL Server 2008?

I have a user-defined table type. I want to check it’s existence before editing in a patch using OBJECT_ID(name, type) function. What type ...

June 3, 2022
0 Comments

Programming, sql

IT Nursery

Copy data into another table

How to copy/append data from one table into another table with same schema in SQL Server? Edit: let’s say there is a query ...

June 2, 2022
0 Comments

Programming, sql

IT Nursery

How to Select Every Row Where Column Value is NOT Distinct

I need to run a select statement that returns all rows where the value of a column is not distinct (e.g. EmailAddress). For ...

June 1, 2022
0 Comments

Programming, sql

IT Nursery

How to create composite primary key in SQL Server 2008

I want to create tables in SQL Server 2008, but I don’t know how to create composite primary key. How can I achieve ...

June 1, 2022
0 Comments

Programming, sql-server

IT Nursery

nvarchar(max) vs NText

What are the advantages and disadvantages of using the nvarchar(max) vs. NText data types in SQL Server? I don’t need backward compatibility, so ...

May 31, 2022
0 Comments

Programming, sql-server

IT Nursery

Alter column, add default constraint

I have a table and one of the columns is “Date” of type datetime. We decided to add a default constraint to that ...

May 31, 2022
0 Comments

Programming, sql

IT Nursery

Saving results with headers in SQL Server Management Studio

I am using SQL Server Management Studio. I wish to save the results of a query to an excel file. I choose “save ...

May 30, 2022
0 Comments

Programming, sql

IT Nursery

Multi-statement Table Valued Function vs Inline Table Valued Function

A few examples to show, just incase: Inline Table Valued CREATE FUNCTION MyNS.GetUnshippedOrders() RETURNS TABLE AS RETURN SELECT a.SaleId, a.CustomerID, b.Qty FROM Sales.Sales ...

May 30, 2022
0 Comments