Topics
Started by
Posts
Last post
i got a piecec of code from 3rd party app, which looks like: select * from table_1 a join table_2 b…
2 replies
Am I doing something wrong. It runs fine in master, but if I try and run it out of our dbadmin data…
7 replies
Hello, I'm trying to read a folder located on another server. 1. I have created a credential (Ident…
6 replies
Dear, After looking at several options, (I have to read files from a file server to populate a DB),…
3 replies
Hi, Is there anybody can help me take a look? I want to create one temp tble by using the query l…
4 replies
BEGIN DISTRIBUTED TRAN tran03092011 UPDTE srvrn.dbn.dbo.tbl1 SET name='test' WHERE number=1 IF @@ER…
30 replies
How can I include in a query a single value and a total value. I have order table, OrderDate, Custo…
1 replies
Msg 547, Level 16, State 0, Line 2 The ALTER TABLE statement conflicted with the FOREIGN KEY constr…
3 replies
hi i got ten column names like #gorge, H#res, Er#es like that now i want to replace all the '#' val…
4 replies
I have Two table's called O3 and o5 and contains s.no and O3 & O5 in the Table (i.e..in O3 �…
4 replies
I need to modify a job that is on multiple servers and includes the servername in the job. I have t…
3 replies
Tks for your input !
1 replies
Why does this: DATEPART(MILLISECOND,cast('2011-03-14 17:43:52.134' as datetime)) return 133? and D…
4 replies
Hi All, I am unable to sort the following table, which is viewed through a view, by column C. Table…
12 replies
Hello, i am trying to convert a binary value to a varchar and I am getting incorrect results. Here…
4 replies
Viewing 15 topics - 8,566 through 8,580 (of 10,635 total)
You must be logged in to create new topics.