sql-server Archives - Page 28 of 39

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

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

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

How do I limit a SQL Server Profiler trace to a specific database? I can’t see how to filter the trace to not ...

Is a select * from myView faster than the query itself to create the view (in order to have the same resultSet): select ...

This question already has answers here: Update a table using JOIN in SQL Server? (13 answers) Closed 9 years ago. I have the ...

Please clarify two things for me: Can a Foreign key be NULL? Can a Foreign key be duplicate? As fair as I know, ...

In SQL I (sadly) often have to use “LIKE” conditions due to databases that violate nearly every rule of normalization. I can’t change ...

If I have a date 01/01/2009, I want to find out what day it was e.g. Monday, Tuesday, etc… Is there a built-in ...

In SQL Server 2005, we can create temp tables one of two ways: declare @tmp table (Col1 int, Col2 int); or create table ...