Viewing 15 posts - 44,896 through 44,910 (of 49,571 total)
Strange. It's as if it is in autoclose, despite not being set that way. That's certainly not normal behaviour. Strange. I'll look into this.
Some advice: CheckDB with any form of...
August 25, 2008 at 10:17 am
sugan (8/25/2008)
Is it possible to assign null value to variable.
Yes, and I showed how to do it. As for the second part, try something like this:
SET @string1 = 'insert...
August 25, 2008 at 10:11 am
Cliff Jones (8/25/2008)
Do you still need to enable trace flag -T1118 to enable the uniform allocations feature in SQL 2005 as we did in SQL 2000?
I don't believe so.
August 25, 2008 at 10:02 am
Please could you post create statements for the tables, sample data (as insert statements) and your expected output.
Having all that makes it much easier and faster for us to get...
August 25, 2008 at 5:05 am
If you have the mdf and the ldf, and the files aren't in use (ie already part of an existing database), you may be able to attach them to SQL....
August 25, 2008 at 4:59 am
pakaw_man (8/25/2008)
i had change exec with print but the error is same, can u give another solve???? thx
Very strange. The error comes from executing the dymanic SQL. If you're not...
August 25, 2008 at 4:47 am
arjun.tewari (8/25/2008)
As per the database design percepective, I would like to implement such a situation using a Trigger instead of a foriegn key percpective.(Inviting others to intervene).
I'd much prefer the...
August 25, 2008 at 1:00 am
I'm not sure I understand your question.
Setting a variable to null is as simple as SET @VariableName = NULL
select @col1 = isnull(col1,NULL),@col2 = isnull(col2,null) from table
What are you trying...
August 25, 2008 at 12:54 am
Hierachies is the classic example, when you have a parent-child relationship within a single table.
create table Employees (
EmployeeID int identity primary key,
EmployeeName varchar(50),
ManagerID int
)
ALTER TABLE Employees...
August 25, 2008 at 12:49 am
Something like this should work, provided the column in question is varchar or nvarchar. If it doesn't do what you want, could you give us more details, including some sample...
August 25, 2008 at 12:43 am
Repair should be an absolute last resort, not the first thing to try. It should also never be done without ascertaining if there is corruption and if so, how bad.
Sri:...
August 25, 2008 at 12:40 am
Can you print out the dynamic SQL instead of an execute and post the string?
August 25, 2008 at 12:15 am
August 25, 2008 at 12:13 am
Could you perhaps post the query? It's hard to say how to improve something without some code to refer to.
August 24, 2008 at 1:49 am
Viewing 15 posts - 44,896 through 44,910 (of 49,571 total)