Viewing 5 posts - 1 through 5 (of 5 total)
I can see from tempdb..sysobjects that the schema of the table variable is created at the same time when a table is defined.
I used the following script:
DECLARE @tblAAAA...
October 28, 2005 at 6:49 pm
#601144
Rudy,
When you say NIC setting, you meant the NIC of my computer, or the NIC of the server? My computer is an IBM R40 laptop, while the server is...
January 13, 2005 at 7:20 pm
#537401
Thanks for all the advice. I traded the network connections with the other DBA, but the problem persists.
However, this time, I noticed that my connection from Enterprise Manager (EM)...
January 11, 2005 at 12:52 pm
#536895
thanks, "rows" column of sysindexes is what I am using now.
I just noticed that the value of "rows" different type of indexes, say idind=1 (cluster) or 2 (noncluster), for the...
March 31, 2004 at 2:01 pm
#501371
Denish/Steve,
Thanks for the reply. That was actually an interview question that I was asked last week, and I came with something like:
select CAST(a.ID AS varchar(1)) + CAST(b.ID AS varchar(1))...
February 15, 2004 at 9:49 am
#494107