Topics
Started by
Posts
Last post
I'm new in SQL server. I want to create a stored procedure for a table. suppose table has 6 column.…
1 replies
i have multiple dbs out there that i want to run a sp against. its prefered that this procedure tha…
6 replies
Hi, what I need is to Generate SQL Script. I know it is easy using Enterprise Manager -> All Ta…
18 replies
Does anyone know how I can match a newline or tab character using PATINDEX?
5 replies
Hi, i have a value say 1000 and i have atble which contains values whose sum could be 10000. I want…
7 replies
By: maffan76
Hello all, I'm trying to do nested loops and it seems I can only get one loop out of the outer lo…
2 replies
How can i use the USE inside a stored proc. i want to change the dbname using the use command insid…
1 replies
Other than by using sp_spaceused in a cursor how can I determine the size and rowcount of each tabl…
2 replies
I am trying to select a table without locking it. How come the following produces a syntax error? …
1 replies
By: Cheddar
We have an application which uses ASP.NET and C#. One particular page calls 3 stored procedure one …
3 replies
For this script "Use DELETE On Many Tables With Foreign Keys" Does anybody have more info on the pa…
3 replies
If I run this query I get a single row as I specify a specific value for col2: select distinct co…
2 replies
I have to design a Stored Procedure that imports an Excel File; (dont ask why; boss wants it that w…
11 replies
Is there anyway to code a column name as a variable in a select statement? For example: Create Proc…
3 replies
Field1 can be several values depending on the status of the record, C, X, B, R etc. However I don'…
7 replies
By: mimorr
Viewing 15 topics - 15,616 through 15,630 (of 17,082 total)
You must be logged in to create new topics.