Topics
Started by
Posts
Last post
How do I format the result returned by getdate() into mm/dd/yy format? I've gotten as far as: PRINT…
6 replies
I have the following stored procedure which works fine but it's pulling every occurrence of the Tas…
1 replies
Hello, If you have a stored procedure like: create proc testProc as select * from myTable Is there …
4 replies
Under sa login, I am NOT able to create a function in a particular database (Let us call it 'X'). I…
4 replies
I wnat to modify the datatypes of several columns in a table. Can someone help me with the syntax? …
2 replies
Help! I am attempting to run the following stored procedure in SQL Server 2000. The view in the s…
3 replies
Hello. I'm trying to use CASE in my code but I couldn't managed to use it right. Can you tell me wh…
4 replies
Hello. I have a problem with one of my columns. While I was trying an asp page I had the following …
6 replies
I have this table that has a date and time in 2 sepearte fields and I want to put them into 1 field…
1 replies
HI all, I am using SQL 2000 (yay!) and I haven't really come across this before. I have an sp whi…
2 replies
I need a dynamic IN for my search page. There is a "select section to search" with checkboxes as pa…
8 replies
Hello! I'm totally new to triggers. I'm trying to make a trigger that fires when you delete somethi…
3 replies
Management is requiring that our personnel run a Crystal Report query every hour against the SQL da…
3 replies
hi, I'm trying to change the default value of a group of columns. I've tried ALTER TABLE users ALTE…
1 replies
I've got a SP that runs a query to get a list of users. I then pass a userid to a function only if …
1 replies
Viewing 15 topics - 16,411 through 16,425 (of 17,082 total)
You must be logged in to create new topics.