Topics
Started by
Posts
Last post
SQL Server 2000 on W2k server. Database has 4 million records, Fulltext on an image column that con…
3 replies
I need to run a stored procedure with two parameter: spu_testing (ID_Number, DataBase) I need wha…
3 replies
Hi, I'm trying to figure out how to include *all* rows of a particular table (in this case t…
7 replies
hi i have following query SELECT COUNT( DISTINCT [SupplierID]), COUNT( DISTINCT [CompanyName…
2 replies
Hi, I have a VB application where in I would like to pass an array as parameter to a SQL stored pro…
7 replies
I am trying to create a stored procedure using the following TSQL: SELECT DISTINCT &nbs…
6 replies
Using the following VIEW DDL, can someone alter to guarantee ONLY 1 row for each Person.ID dis…
4 replies
Hi I have the below stored procedure in my database and am getting the error: Server: Msg 241, Lev…
4 replies
I could use some help resolving this problem. My app uses two temporary tables @tmpTasks and …
3 replies
I have next(part of the procedure): IF @Total > 0 &nb…
4 replies
Is there a way to find out if a foreign key is cascade on delete or update? sysforeignkeys doesn't…
4 replies
SET NOCOUNT ON /* My Table */DECLARE @MyHistory TABLE ( DataDate DATETIME, AreaCode VARC…
3 replies
Basically if i have a simple SQL statement in an app i should ALWAYS create a stored procedure for …
17 replies
Can some one tell me the syntax to set the sort order for NULLs in a column. e.g SELECT Col1 FROM …
8 replies
I have a hierarchical table like this: CatID CatName …
1 replies
Viewing 15 topics - 9,586 through 9,600 (of 17,082 total)
You must be logged in to create new topics.