sql-server Archives - Page 5 of 16

How to get a float result by dividing two integer values using T-SQL?

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

May 25, 2022
0 Comments

What’s the longest possible worldwide phone number I should consider in SQL varchar(length) for phone

What’s the longest possible worldwide phone number I should consider in SQL varchar(length) for phone. considerations: + for country code () for area ...

May 25, 2022
0 Comments

Execute stored procedure with an Output parameter?

I have a stored procedure that I am trying to test. I am trying to test it through SQL Management Studio. In order ...

May 25, 2022
0 Comments

Add a column to a table, if it does not already exist

I want to write a query for MS SQL Server that adds a column into a table. But I don’t want any error ...

May 25, 2022
0 Comments

SQL Server: What is the difference between CROSS JOIN and FULL OUTER JOIN?

What is the difference between CROSS JOIN and FULL OUTER JOIN in SQL Server? Are they the same, or not? Please explain. When ...

May 24, 2022
0 Comments

How do you view ALL text from an ntext or nvarchar(max) in SSMS?

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

May 24, 2022
0 Comments

An explicit value for the identity column in table can only be specified when a column list is used and IDENTITY_INSERT is ON SQL Server

I’m trying to do this query INSERT INTO dbo.tbl_A_archive SELECT * FROM SERVER0031.DB.dbo.tbl_A but even after I ran set identity_insert dbo.tbl_A_archive on I ...

May 24, 2022
0 Comments

How can I generate an INSERT script for an existing SQL Server table that includes all stored rows?

I’m looking for a way to generate a “Create and insert all rows” script with SQL Management Studio 2008 R2. I know that ...

May 23, 2022
0 Comments

How do I format a number with commas in T-SQL?

I’m running some administrative queries and compiling results from sp_spaceused in SQL Server 2008 to look at data/index space ratios of some tables ...

May 23, 2022
0 Comments

How can I determine installed SQL Server instances and their versions?

I’m trying to determine what instances of sql server/sql express I have installed (either manually or programmatically) but all of the examples are ...

May 23, 2022
0 Comments