I encountered an odd situation where appending OPTION (RECOMPILE) to my query causes it to run in half a second, while omitting it causes the query to take well over five minutes. This is the case when the query is executed from Query Analyzer or from my C# program via SqlCommand.ExecuteReader(). Calling (or not calling) … Read more
like when I do SELECT [Date] FROM [FRIIB].[dbo].[ArchiveAnalog] GROUP BY [Date] how can I specify the group period ? MS SQL 2008 2nd Edit I’m trying SELECT MIN([Date]) AS RecT, AVG(Value) FROM [FRIIB].[dbo].[ArchiveAnalog] GROUP BY (DATEPART(MINUTE, [Date]) / 10) ORDER BY RecT changed %10 to / 10. is it possible to make Date output without … Read more
I need to check when function was changed last time. I know how to check creation date (it is in function properties window in SQL Server Management Studio). I found that in SQL Server 2000 it wasn’t possible to check modify date ( look at this post: Is it possible to determine when a stored … Read more
In SQL Server 2008 Management Studio, when I right click on a database table and choose “Select Top 100 Rows“, I can then e.g. easily add a “ORDER BY ” statement to the SQL. That works fine. But when I do choose “Edit Top 200 Rows“, I don’t have the ability to alter the SQL … Read more
I have an error at Column ‘key’ in table ‘misc_info’ is of a type that is invalid for use as a key column in an index. where key is a nvarchar(max). A quick google search finds that the maximum length of an index is 450 chars. However, this doesn’t explain what a solution is. How … Read more
What I’m trying to do is use more than one CASE WHEN condition for the same column. Here is my code for the query: SELECT Url=””, p.ArtNo, p.[Description], p.Specification, CASE WHEN 1 = 1 or 1 = 1 THEN 1 ELSE 0 END as Qty, p.NetPrice, [Status] = 0 FROM Product p (NOLOCK) However, what … Read more
I have SQL Server database and I just realized that I can change the type of one of the columns from int to bool. How can I do that without losing the data that is already entered into that table? 11 Answers 11
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 the correct format? 4 Answers 4
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 tables before but I’ve never been exposed to the alter statement which is what I believe I need to use to do this. I found the documentation here: ALTER TABLE (Transfact-SQL) however … Read more
