I have 4 After triggers and i want to give the order for them in which they fired..
i can do that with the help of sp_setordertrigger but with this i can only specify which one will be fired first and which one will be last but what abut the rest of triggers how can i order them..please help me..in this i m new for trigger...
SqlConnection conn = new SqlConnection(connectionString);
errors at the line:
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
Putting aside the obvious answer ( google can tell you in seconds ), why would you want to ? MPEGs are big, and no media player can play them without a physical file, so storing paths to files seems to make more sense to me.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
str+="CREATE TABLE ";
str+="(ID INTEGER,FangWei TEXT,FuYang TEXT,QingXie TEXT)";
when debug to here, the following appear:
Unhandled exception in SerialRecieve.exe(KERNEL32.DLL):0xE06D7363:Microsoft C++ Exception.
str is a CString variable,which is the table name, the program passed the compile and the build, but when debug, it can not go through.
maybe it is a easy problem, but i can not resolve it
I want to use bulk insert in order to insert information from a CSV to the database.
The CSV contains fewer fields than the DB.
I don't want to use a format file, I want to specify all the options within the with clause.
I need to map the fields in the CSV to the fields within the Database table.
I am using Sql server 2005 reporting services. I have created reports on server. I want to connect reportserver from client's PC and the Reports should come with Records as logged in User wise. This I want to place on different panes after calling them, as this happens with Google Analytics and msn sites. To place the records, I will use AJAX controls.
Can any one help me.
I appreciate the assistance that all of you have provided so far. However, I have encountered a slight glitch with the CreateQueryDef() method. The problem is that it seems to take a while for the QueryDef to be actually created and available for use in the following code.
After I create a QueryDef, I need to use it in the very next subroutine, a point in which it might not actually become available in MS Access. Is there a way to pause execution of the subroutine until the QueryDef is actually created and available for use?
Here is what I did, and interestingly enough...it works.
I created code that essentially does nothing but execute a loop and pass a counter to a control. Then I added a control to the form, left it visible, but essentially hid it from the form by making the textbox's background color, border color, and fore color the exact same as the underlying form color. This provided something for the processor to do while the QueryDef was being created. I essentially needed to count to 10000.
Here is the code:
'Provides time to create QueryDef qryFinalResult
Dim intCount As Integer
intCount = 0
For intCount = 1 To 10000
txtCounter.Text = "Count: " & intCount & "."
intCount = intCount + 1
Does anybody have a more elegant way to do this? This code prevents that error message from coming up indicating that the QueryDef that I had just created does not exist. When I step through the code myself, the processor has enough time to create the QueryDef object, but when I run it as an application, it does not have time to create it in time to use it.
I created a function to check if a table exists, as I need to check for this sort of thing frequently.
Here is the function code:
CREATE function dbo.DoesObjectExist(@Name varchar(200), @Type char(1))
declare @Result varchar(7)
if exists (select * from sysobjects
where name = @Name
and xtype = @Type)
select @Result = 'present'elseselect @Result = ''return @Result
This is how you check if the OffVansQtyOrdered table exists using this function:
if dbo.DoesObjectExist('OffVansQtyOrdered','u') = 'present'
I hope this is of help...
You always pass failure on the way to success.
Last Visit: 31-Dec-99 19:00 Last Update: 31-Jan-23 16:00