Topics
Started by
Posts
Last post
Two ways to determine whether to do an insert or an update are: 1. Query to see if the record exist…
5 replies
how i can find total no. of days in month in SQL Server2000?
1 replies
why does the first one work and the second does not? declare @i int set @i = 5 print @i /*go*/prin…
2 replies
Hello my friends, you know, when i was playing wiht the execution plan of the query analizer i foun…
13 replies
I have a stored procedure, which, if an insert fails because the record already exists, performs an…
3 replies
We collect data into our database every minute. But data will not be comin at some point of time du…
1 replies
Hi, MSSQL 2000/7 I'm developing a query and would like to return results based on the most recent …
2 replies
Hi - On 1 SQL 2000 table, I have a single column comprised of data representing either: - CITY, STA…
3 replies
Hello, Currently I have a table where the first and last name are stored in one column. However I n…
2 replies
I would relaly appreciate it if someone would tell me what I'm doing wrong. The stored procedure be…
12 replies
Hi, I need to perform the equivalent of a MID function (vb.. Access etc) The string is something li…
7 replies
Hi all, I'm stuck on a problem which I'd appreciate any help. Given the following table, I want to …
3 replies
Hi, I have a situation where I need to give a custom error message in an SP where I get a primary k…
1 replies
Hello All, I need to export result of a query (single column) to a text file. Simple enough-ca…
1 replies
Hi, I'm trying to write to a text file using t-sql. I've done this before in Oracle using UTL…
9 replies
Viewing 15 topics - 10,846 through 10,860 (of 17,082 total)
You must be logged in to create new topics.