Topics
Started by
Posts
Last post
In an order table there are Order filed in which we store the order number . Now here is my questio…
1 replies
I have two tables with customerID number, one table has null padding in front of the number which I…
16 replies
I'm creating a #tmptbl table based on a query. I want to create a sort order column so I can join …
4 replies
By: Sergiy
Hi, I'm looking to see if there is a way of determining whether or not a foreign key has Enforce Re…
2 replies
When I try to run the following code I get an error message: " Server: Msg 8122, Level 16, State 1…
5 replies
By: GSquared
We have 2 databases with the same table structures. We created a view on both the databases. One of…
2 replies
My developers have a question regarding the performance of a query they're trying to write. For exa…
4 replies
Background: a questionnaire. we count he number of 'A' or 'B' or 'C' or 'D' selected by a user in o…
3 replies
By: Sergiy
Hi, I have the following SP. create proc Sample ( @sample varchar(10) ) as Begin print @sample E…
1 replies
By: Sergiy
Hi guys, Basically, this is what I'm doing: DECLARE @SearchedRecs TABLE ( nJobIDPK int, nSupID int,…
5 replies
Is there any way in SQL Server 2000 to do a partial backup and/or restore (e.g. of selected tables)…
3 replies
By: ChiragNS
Experts, I have come accross a column that contains all paid orders but the amounts have a negative…
3 replies
By: Maique
Posted - 01/14/2008 : 20:18:48 -------------------------------------------------------------------…
6 replies
By: Sergiy
Hi. I wrote this sql as below. But it doesn't work as I want. I want to filter by with dbo.fDeterm…
1 replies
Hi guys, I am trying to increase the size of a numeric field already existing in my table1. Current…
4 replies
Viewing 15 topics - 3,406 through 3,420 (of 17,082 total)
You must be logged in to create new topics.