Topics
Started by
Posts
Last post
Hi I am battling with an unexpected production issue. READPAST hint is working on test server but n…
2 replies
I use VB6 ad have a big headache juggling date formats in my apps. One of the issues is the combina…
11 replies
Disclaimer: I am a web developer, not a sql guy so I'll take all the help I can get! I need to upda…
2 replies
I have a question. Will use of TRUNCATE TABLE and then DROP TABLE be faster and use less resources …
2 replies
Hello, Im using this query to calculate the total number of marks in an exam per subject: SELECT ST…
3 replies
I need data from a table containing many columns including [Client ID], [SERVICE DATE], and [ROW_ID…
3 replies
Does anyone know of a function which will return the data type of a selection i.e. declare @somevar…
5 replies
SQL2000 A table contains ID, CODE, and PRIORITY(varchar). For each ID Exists codes prioritized 1..n…
8 replies
Hi Experts, I am very confused about the default length for varchar datatype. I was read an article…
4 replies
Hi Experts, How a table which contains foreign key relationship accepts more than one NULL value ? …
1 replies
A fellow developer asked me what is the difference between using the following statement as opposed…
3 replies
I am having a small issue coming up with the correct structure of an XML Doc being returned by an S…
2 replies
DECLARE @ReturnStatus bit SET @ReturnStatus = 0 SELECT @ReturnStatus = NULLIF(@ReturnStatus, '') …
24 replies
How would I format the date of a report that is currently giving something like.... 2007-08-02 09:0…
35 replies
Can I run a store proc residing on database A in multiple databases where I can select the DB name …
1 replies
Viewing 15 topics - 3,751 through 3,765 (of 17,082 total)
You must be logged in to create new topics.