Topics
Started by
Posts
Last post
select * from tblBillDetail where bdUidBillID= 7267049 and bdCdeGroup0 = 1 and bdCdeGroup1 = 1…
4 replies
I want to create a procedure where each time I add a new record to a table I want to set the field …
4 replies
I've created an INSERT trigger on my table. It is firing even when 0 rows are INSERTED w/ the…
1 replies
ok perhaps I am going crazy but from everything I have read about sql server this query should not …
3 replies
Hello, I'm trying to set up a proc in which the parameter value would actually be the name of …
5 replies
Firstly, let me apologise for the question i'm about to ask! It's soooo basic i'm sure it wil…
8 replies
I have a table containing the following (example) data A B 20000 0 NULL…
20 replies
Is there a way to get a new line within a SQL string? 'some text' + (what do I need here for a…
5 replies
Hi All (SQL Server 2000) I need to allow the user to store up to 5 fields of almost unlimited lengt…
2 replies
No other way to describe this, I have three columns, A, B and C, C = A/B, A = 4, B = 4, C = 0, the …
2 replies
Not too sure if the subject of this post accurately reflects the nature of the question, but it is …
14 replies
Using a sp. I have a small sql dilemma. I’m using dynamic sql to obtain some column_nam…
1 replies
I'd like to do a select off of a table and add a field that assigns a row number in the results.&nb…
6 replies
Which method is more efficient? (strDate between @startDate and @endDate) or (strDate >= @s…
2 replies
I am trying to create a view where define a field as the first 100 characters of an NText type fiel…
4 replies
Viewing 15 topics - 6,121 through 6,135 (of 17,082 total)
You must be logged in to create new topics.