Topics
Started by
Posts
Last post
Using SQL Server 2000 See below for a oversimplified example. I am asked to drop a column, which mi…
4 replies
This is intended as more of a discussion issue rather than a request for help. There have been many…
18 replies
By: maffan76
Anyone know why you can't see the execution plan used for the statements inside a function? Or numb…
3 replies
I wanted to create a new table 'A1' from table 'A2' with only structue,not the data of the table 'A…
4 replies
By: sahana
Hey.... I'm easily able to use the SUM aggregate function to "SUM" data from row 1 to row N.. But w…
3 replies
Hi, I declared cursor and fetch ID and some columns in a table.I want to change value of ID column(…
1 replies
Hello, I need to delete records from a table that match the results of the following query: *******…
2 replies
By: cdun2
You may learn the syntax of SELECT statement and expand skills by means of executing the exercises …
2 replies
By: richsera
Hello All, A Crystal reports writer by training, so I'm new to all this so please bear with me. I …
2 replies
By: jodasher
hello everybody, I am trying to create a temporary table in my stored procedure and use the result …
4 replies
i want to select the values based on the selected year month i have one table with RegisterDate fie…
1 replies
By: jpipes
Hi, I would like to add a column to a table...What is wrong and how to solve problem? DECLARE @pom …
1 replies
I am trying to detect which procedure a user has just created and have written the sql below as a t…
4 replies
Scenario Table1 - all employee names Table2 - hours for all employees I need to create a list (whic…
4 replies
I need to lock standard users out of my SQL2K servers on a nightly basis so that I can perform load…
9 replies
Viewing 15 topics - 15,586 through 15,600 (of 17,082 total)
You must be logged in to create new topics.