Viewing 15 posts - 3,301 through 3,315 (of 13,469 total)
it's going to look a lot like this:
the only thing i could not determine was the primary key that woudl related the INSERTED to the DELETED ; your example did...
June 7, 2013 at 6:19 am
Sean Lange (6/6/2013)
June 6, 2013 at 3:31 pm
here's a start to finish example, where i create a user, grant just the permissions Perry identified in his posts, specifically impersonate that user for testing, and then read from...
June 6, 2013 at 3:18 pm
Sean mine was just a lazy adaptation of something that already existed; it was easier than from- scratch script to find them; this adapted snippet from the middle of your...
June 6, 2013 at 3:06 pm
bslchennai (6/6/2013)
June 6, 2013 at 2:55 pm
my verison is kinda of wordy but works with a case statement:
SELECT
CASE
WHEN RTRIM(ISNULL(col1, '')) <> ''
AND RTRIM(ISNULL(col2, '')) <>...
June 6, 2013 at 1:21 pm
Jerome it seems to me you are leaving a lot out.
your example must be coming inside a cursor, right? why don't you show that part too?
your code(so far) is adding...
June 6, 2013 at 7:52 am
Ratheesh.K.Nair (6/6/2013)
Thanks Lowell,I want the process to keep running. Creating a recurring job wont help me.
Since am trying on test server DBCC CHECKDB wont take more than few seconds.
i...
June 6, 2013 at 7:29 am
SQLSACT (6/6/2013)
ikonrao (6/6/2013)
Or if we can get create table statement for that...
June 6, 2013 at 7:09 am
Ratheesh.K.Nair (6/6/2013)
Hi experts,Can anyone please help me create a job that should run indefinitely i mean the the script should keep on running.
Thanks in Advance
have you created a job at...
June 6, 2013 at 7:04 am
zip184 (6/6/2013)
I have the same problem in 2008. I never used to but I re-installed it recently and this started happening.Have you found anything yet?
Maybe the autoclose proeprty is...
June 6, 2013 at 6:57 am
i think the issue is your second statement; you only select if your variable is empty string, but you already created it?
i would do it all in a single command,...
June 6, 2013 at 6:52 am
We support an app that connects to either SQL or Oracle as well, and trip over the which-data-types-are-equivalent questions as well;
for your second question,
NUMBER(10) = int
this is my go to...
June 6, 2013 at 6:08 am
ikonrao (6/6/2013)
Or if we can get create table statement for that table,...
June 6, 2013 at 5:20 am
I'd recommend starting with some of hte articles in the "stairways" series, here on SQL Server Central:
http://www.sqlservercentral.com/stairway/
those articles are on subjects and build up from basic information to more and...
June 5, 2013 at 3:05 pm
Viewing 15 posts - 3,301 through 3,315 (of 13,469 total)