Topics
Started by
Posts
Last post
Hi, I have a procedure in SQL server 2000 that checks for two errors after an insert into a table. …
24 replies
I have two tables one which may or may not have data related to the primary table contest. When I…
11 replies
Hi all! I have a MySQL linked server (MYSQLLNKD) in my SQL Server 2005. I need to get the xml outpu…
1 replies
Hi all, I am getting error when running the following script if object_id('dbo.tbl_photos') is not …
2 replies
Hi all, We have an application that uses a standard 24 hours period for a reporting 'day', but the …
7 replies
Hi I would like to find out an easy way with out using temp tables to see if the result of one tabl…
5 replies
i need the following query in 2000.please look into this. Select * from ( SELECT MED_NAME AS MEDICA…
1 replies
When I execute below SQL statement in SQL server 2000, I get the same value of 128414903 for the CH…
11 replies
I want to create a search on Address field of xyzTable If my searching string is “A B C D” XyzTable…
2 replies
Hi, Please let me know how to find out or display only the duplicate entries in table. Thanks in ad…
5 replies
Hi, I have couple of questions on using transactions inside a stored procedure. Can any one tell me…
4 replies
Dear Friends, I have hourly data with Date as "2008-11-30 00:00:00:000" format. I want to convert t…
7 replies
hi expects i want to alter the table existing column to int to identity, using alter query it's sho…
5 replies
Hi, I have a cursor declared for some columns from a table. The values of the cursor is the input p…
1 replies
I'm planning to make a trigger with this condition CREATE TRIGGER [TRIGDelete] ON [dbo].[tempEmp] F…
11 replies
Viewing 15 topics - 1,411 through 1,425 (of 17,082 total)
You must be logged in to create new topics.