Topics
Started by
Posts
Last post
In MY table for one of the column I need to create a default value.It should as shown in the follow…
3 replies
Hi If I have Select * from T1 order By NewID() can I under special conditions bring a specific row…
4 replies
I need to sumarize information for each month, and have a result for the 12 months. Is there a…
10 replies
Is it possible to save the results from a stored procedure to a text file? Thank you
3 replies
Hi, Does anybody know how to generate primary keys automaticaly without using IDENTITY Column prop…
12 replies
Have two tables tblpart (participants) and tblorg (organisations), NOT all tblpart entries have a c…
4 replies
Here is a part of procedure: BEGIN SET NOCOUNT ON DECLARE @sql varchar(600) SET …
4 replies
As a result of a data extract I have a table that holds Patient demographic details, one row for ea…
5 replies
Can anyone recommend testing tool for stored procedures and maybe provide some links to articles ab…
3 replies
Hi all, I have 2 linked servers - crm & sage I want to update information, using a DTS from one…
5 replies
Hello how are you?, i hope that you are fine, well friends , let me explain my problem with my syst…
6 replies
Is there a way to create a stored procedure to connect to a FTP server to delete a file? Please pro…
5 replies
Hi friends i need ur advise on this query.I've 2 fields in a table (patient,invoice). field invoice…
9 replies
My stored procedure always reutrns -1 ?? I am trying to test and see if the user id already exists …
6 replies
I have been using SQL for many, many years. This problem seems so simple but I am stumped. I …
8 replies
Viewing 15 topics - 9,826 through 9,840 (of 17,082 total)
You must be logged in to create new topics.