Topics
Started by
Posts
Last post
Table_A col_a = \server1\joeblow, janedoe, \server2\jerrydoe Table_B col_b = joeblow, janedoe…
2 replies
Hi, My query is..... DECLARE @t timestamp SET @t=(select @@DBTS) Print @t But the follow…
1 replies
: Hi, I have a string in field (in any table). Suppose string is -- 'I Love India'(string can be of…
4 replies
I have inherited a sql 2005 cluster and am far from a dba. I am trying to understand the below sp..…
2 replies
Hi, I have an excel worksheet - sheet 1 renamed as 'test' I am trying to use openrowset in my sele…
2 replies
I am struggling with the HAVING clause trying to get a row selected using the max function.&nb…
4 replies
Hi I am creating SP's for my Team to use when we run analysis jobs. i.e. Table audit scripts, check…
1 replies
Have a stored procedure with a single input parameter that returns a data set from an linked Oracle…
7 replies
hi all my select statement is something like this select name from table result is O'Shea O'Connor …
1 replies
I have renamed an old table with a backup name and created a new table with the original name of th…
2 replies
I read an article the other day that advised against the use of the NOT IN and NOT EXISTS statement…
3 replies
I'm trying to COMPLETELY!! lock down the guest & public accounts so that when I create a new us…
3 replies
Hello All: I'm trying to set up some re-usable T-SQL for a task that I will likely use repeatedly i…
2 replies
Hi, In one column I've a binary data = 0x098F6BCD4621D373CADE4E832627B4F6 I'll put in an other colu…
3 replies
I want to delete all stored procedures that contain a certain line of text. What is blocking …
10 replies
Viewing 15 topics - 12,106 through 12,120 (of 12,230 total)
You must be logged in to create new topics.