Topics
Started by
Posts
Last post
Problem..... I have found out the following issue: I run a procedure (A) in Database (A) that call …
1 replies
Hi! I wondered how to do a query that lists all the primary keys (and its data type) from the …
2 replies
Hi all, Please help. I need to write a query which picks up everything with a date greater th…
5 replies
Could some please help me with how to write this query in T-SQL? Say there is a product table with …
11 replies
Hi, Can any body tell how can alter a table by passing a parameter. I have a Table wit one field an…
4 replies
Hi I have a table t1 with cols ID and text. So when I do a select * from t1 where ID=10 I get two …
1 replies
Does anyone have a set based way to remove preceeding zeros from a varchar field? The number …
24 replies
I am building a query that will send 70 emails to users. The content of the email will be from anot…
4 replies
I know I can't use this: DECLARE @col VARCHAR(9) SET @col = 'firstname' SET @col2 = 'surname' SET @…
1 replies
Greetings! How do we suppress Error messages which comes in the resultset window when we execute a …
9 replies
Hello, I would like to find and replace all subselects in a selection query. The subselects will be…
3 replies
How do I count the frequentie of a char within a varchar? "like if we do it for: i" -> 4
3 replies
Check if file exists in folder send it by mail with (xp_SMTPSendMail80) move the file to back…
1 replies
Hi There, I have a problem in summing up the values exist in a varchar field for one of the table. …
2 replies
I have a column in the middle of a table that I would like to split into two columns. For ex…
1 replies
Viewing 15 topics - 8,566 through 8,580 (of 17,082 total)
You must be logged in to create new topics.