Topics
Started by
Posts
Last post
year=2005 Month=5 day=27 time=9:30 I have these values with me and I wanted to convert this to a da…
7 replies
How can I get the first day of the month. Suppose if I get a date 5/13/2005 as my input parameter I…
6 replies
Hello, I need to connect to a remote server using stored procedure but there is one problem, I do n…
3 replies
Hi all, My question are how can I export tables to textfiles from SQL Query analyzer? I tried the b…
6 replies
Hi, I have a insert query, When I am copy & paste into some other editor it works (e.g. VS.Net …
1 replies
What the devil Is wrong with this????? Am I crazy today??? Declare @ACTION char (3) De…
4 replies
Hi, I need to create a stored procedure to do the following task. The stored procedure has to read …
6 replies
use pubs go if 99 = All (Select pub_id from publishers where pub_id = -1) print 'All equal' e…
2 replies
Hi, I have a Template table which has the template of a letter, with each row corresponding to a li…
6 replies
when I execute DBCC ShrinkFILE I am getting the following results. DbId Field Curr…
4 replies
Hi. I've got a main stored procedure that downloads files via ftp, decompresses them, drops th…
7 replies
Does any one have a script handy that gives you the rowcount of all user tables on a database. I ha…
3 replies
The procedure I've posted below raises a job in our job control system. The job number is generate…
20 replies
Hi All: I've got a table with approximately 600 records, and one field that is date time.&nb…
3 replies
Here's a seemingly simply, but somewhat annoying problem. I'd lke to see what solutions come up wit…
8 replies
Viewing 15 topics - 10,306 through 10,320 (of 17,082 total)
You must be logged in to create new topics.