Topics
Started by
Posts
Last post
Hi, I need to compare data in the same table from two different databases. AdeptSQL Diff does a goo…
4 replies
When definining a Phone Number or SSN Field, what is the best way to provide a default format for t…
2 replies
How do i declare a cursor by executing a stored proc ??? Thanks in advance. regards Prave…
4 replies
On each table in my database of have triggers that record who inserted the record and when. I also …
3 replies
I'm trying to write this bcp to input a txt file into a table, the txt file is field delimited by t…
3 replies
All- We have a process that generates a text file for loading into a SQL table called Files. …
2 replies
Hi, I am using BCP in opeartion in a shell script for recreating & copying data of many tables.…
2 replies
Hi, Could anyone tell me how we can avoid the message "The command(s) completed successfully." in S…
2 replies
I'm trying to find a way to look out for a certain character in a CASE statement. e.g: CASE …
2 replies
Hi, How do we capture the value of a dynamic sql in a variable. For example, I have a dynami…
7 replies
I am writing a SP to send out an email. I am using a cdonts mail SP I found on the internet. The ma…
2 replies
Good Afternoon! I have two tables: tbl1 has voucher_number and payment_date tbl2 has payment_id, vo…
7 replies
Hi gurus, I need to get the list of stored procs which is using a one table name ex: ListofSP('Tabl…
8 replies
i need to add one second to this select datepart(second,Getdate()) how ?? thnks ilan
19 replies
Hi, I'm having some kind of brain fart here. I need to create a view the sums all sales from …
5 replies
Viewing 15 topics - 11,536 through 11,550 (of 17,082 total)
You must be logged in to create new topics.