sql Archives - Page 33 of 45

How to replace a string in a SQL Server Table Column

I have a table (SQL Sever) which references paths (UNC or otherwise), but now the path is going to change. In the path ...

May 9, 2022
0 Comments

How to set variable from a SQL query?

I’m trying to set a variable from a SQL query: declare @ModelID uniqueidentifer Select @ModelID = select modelid from models where areaid = ...

May 9, 2022
0 Comments

Oracle: If Table Exists

I’m writing some migration scripts for an Oracle database, and was hoping Oracle had something similar to MySQL’s IF EXISTS construct. Specifically, whenever ...

May 9, 2022
0 Comments

SQL statement to get column type

Is there a SQL statement that can return the type of a column in a table? 26 Answers 26

May 8, 2022
0 Comments

Best database field type for a URL

I need to store a url in a MySQL table. What’s the best practice for defining a field that will hold a URL ...

May 8, 2022
0 Comments

SQL to find the number of distinct values in a column

I can select all the distinct values in a column in the following ways: SELECT DISTINCT column_name FROM table_name; SELECT column_name FROM table_name ...

May 8, 2022
0 Comments

Difference between numeric, float and decimal in SQL Server

What are the differences between numeric, float and decimal datatypes and which should be used in which situations? For any kind of financial ...

May 8, 2022
0 Comments

How to SELECT FROM stored procedure

I have a stored procedure that returns rows: CREATE PROCEDURE MyProc AS BEGIN SELECT * FROM MyTable END My actual procedure is a ...

May 8, 2022
0 Comments

Selecting data from two different servers in SQL Server

How can I select data in the same query from two different databases that are on two different servers in SQL Server? 15 ...

May 8, 2022
0 Comments