Viewing 15 posts - 1,831 through 1,845 (of 2,894 total)
...
If i just go with my option #2 or #3 or 4... what can go worng??
...
Nothing. But in all of your cases the error will still be returned as error,...
March 22, 2012 at 7:22 am
I wouldn't use any one of your's posted.
It is really depends on what you want your caller to get- Error or Status?
1. If error, then simpler analogue of your...
March 22, 2012 at 6:43 am
Lowell (3/22/2012)
CREATE PROCEDURE EXAMPLEINSERT(
@Value VARCHAR(30))
AS
BEGIN
BEGIN TRY
BEGIN TRANSACTION
...
March 22, 2012 at 6:23 am
itskanchanhere (3/22/2012)
March 22, 2012 at 6:21 am
If you would only post stored procedure code...
Without seeing the code it's impossible to advise anything concrete.
It may be due to:
1. Parameter sniffing
2. Tables require update statistics
3. Bad code
and many...
March 22, 2012 at 4:54 am
...
It's actually what scalar UDF's were invented for and one of the few places where RBAR actually has the advantage. Of course, I threw in a couple...
March 22, 2012 at 4:51 am
The owner of the file is account under which your SQL Server service is running.
It's pretty bad idea of creating files on remote PC's from SQL Server.
You can either create...
March 20, 2012 at 9:58 am
tom.mcginty (3/20/2012)
Over the years, I've had fits trying to update large tables via join to another table. I currently have a 46 million-record table I need to update via joining...
March 20, 2012 at 9:43 am
Try to post on MYSQL forum, it should be the one somewhere;-)
March 20, 2012 at 9:31 am
...
Since your table is a heap, you can either use the drop method or you'll need to add a clustered index.
...
You could also use TRUNCATE to clear the...
March 20, 2012 at 9:27 am
Create a DEFAULT for your column. You can do it via T-SQL or Table Design in SSMS
March 20, 2012 at 8:01 am
I guess you have this step failing due to SQLServer 2008 cannot find your ZIP providing DLL.
March 20, 2012 at 7:59 am
Viewing 15 posts - 1,831 through 1,845 (of 2,894 total)