sql-server-2008 Archives - Page 2 of 7

Programming, sql

IT Nursery

I encountered an odd situation where appending OPTION (RECOMPILE) to my query causes it to run in half a second, while omitting it ...

Programming, sql

IT Nursery

like when I do SELECT [Date] FROM [FRIIB].[dbo].[ArchiveAnalog] GROUP BY...

Programming, sql-server-2008

IT Nursery

I need to check when function was changed last time. I know how to check creation date (it is in function properties window ...

Programming, sql-server

IT Nursery

In SQL Server 2008 Management Studio, when I right click on a database table and choose “Select Top 100 Rows“, I can then ...

Programming, sql

IT Nursery

I have an error at Column 'key' in table 'misc_info' is of a type that is invalid for use as a key column ...

Programming, sql

IT Nursery

What I’m trying to do is use more than one CASE WHEN condition for the same column. Here is my code for the ...

Programming, sql-server

IT Nursery

I have SQL Server database and I just realized that I can change the type of one of the columns from int to ...

Programming, sql

IT Nursery

How to change one attribute in a table using T-SQL to allow nulls (not null –> null)? Alter table maybe? 8 Answers 8

How does one cause a delay in execution for a specified number of seconds? This doesn’t do it: WAITFOR DELAY '00:02'; What is ...

I’m trying to update the length of a varchar column from 255 characters to 500 without losing the contents. I’ve dropped and re-created ...