Topics
Started by
Posts
Last post
I have the following function but it is taking 23 seconds to process 50 records. We have over 300,0…
7 replies
Hello I am using the following query: set rowcount 20 select datename(MM,t.OrderDate) as 'Month', …
3 replies
Select * from customer CustomerID CustomerName ----------- -------------- 1 TestC…
2 replies
Select * from customer CustomerID CustomerName ----------- -------------- 1 TestC…
2 replies
I have a table that has the following field [LOGDATETIMESTAMP] [datetime] NULL , which basically co…
3 replies
Hi, I am using sqlserver 2005, one of my database tables "searches" has a column "xmltext" whic…
14 replies
Hi, Is it possible to create a uniqueidentifier datatype column as increment by 1 as like identity…
4 replies
I've been asked to add a field to a table and the type should be "uniformkey" Not sure what that is…
4 replies
I have a table with a nvarchar field named Violation number that contains data in the following fo…
7 replies
How do you SQL guru's handle rules in your queries? I have about 20 rules to apply to each column i…
1 replies
Hi, From asp.net c# application I am passing the user identity parameter to a stored procedure for…
2 replies
In the Northwind database. Using the employees table as an example. There are currently 9 rows in t…
3 replies
Hi, I need to return a row number in a query result set eg: if there were three rows in the table w…
5 replies
I am trying to run update using CASE statement which is not working.. create table T1 (F1 int, f2 …
1 replies
I have an execution plan and pretty much understand how to tune basic stuff; however, I am curious …
3 replies
Viewing 15 topics - 8,791 through 8,805 (of 12,230 total)
You must be logged in to create new topics.