Forum Replies Created
Viewing 15 posts - 1,936 through 1,950 (of 5,356 total)
-
RE: Last() in SQL Server 2000?
While there is no "last record", you might have a look at MAX(), which should be the equivalent.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Insert daily records from one table to individual merchant tables
May I ask why you have a separate table for each merchant?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Dropping and re-creating indexes
When you think some time about it, there is actually only one way to do this efficiently.
Remember that the leaf level of a nonclustered index contains the RID when there...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Upgrate from SQL7 to SQL2K or not
Not quite right!
It does run, however it is not supported. See here:
http://www.microsoft.com/sql/howtobuy/windowsnetsupport.asp
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Restoring database tables from a database backup
Me too!
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Does table field allow nulls?
I guess, nobody will laugh when you can (and should) use the INFORMATION_SCHEMA views.
Anyway, there might be an even easier way to determine this property.
SELECT COLUMNPROPERTY( OBJECT_ID('authors'),'au_lname','AllowsNull')
returns 1, if...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: need function to return username regardless of sysadmin role
What about SUSER_SNAME()?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Tracking database size
This one might proabably be interesting to you:
http://vyaskn.tripod.com/track_sql_database_file_growth.htm
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Create trigger & set a foreign key in system table
Yes and no.
While it is technically possible to create a trigger on some system tables of msdb, it is not possible to create trigger on tables in master. And it...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Help with creating first trigger
You might want to have a look at BOL for IF UPDATE to test in your trigger if your column is updated.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: sorting problem
One possible way would be
set nocount on
/* cut here */
use tempdb
create table #the_table(the_value varchar(10));
insert into #the_table(the_value) values('a1');
insert into #the_table(the_value) values('a2');
insert into #the_table(the_value) values('a21');
insert into...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: What will happen if I delete the MSDB?
See, if this helps:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;307487
for shrinking tempdb. And this
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
how to move it
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Finding datetime range intersections and durations
I'll help a little bit with the URL
http://www.cs.arizona.edu/people/rts/tdbbook.pdf and
http://www.cs.arizona.edu/people/rts/cdrom.zip
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Can Alerts REALLY be emailed to me from SQL Server?
See, if this helps:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;315886
http://support.microsoft.com/default.aspx?scid=kb;EN-US;312839
http://support.microsoft.com/default.aspx?scid=kb;EN-US;263556
http://support.microsoft.com/default.aspx?scid=kb;EN-US;311231
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: SQL Temp. Tables
Yes, every user has permissions to create temporary tables.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 15 posts - 1,936 through 1,950 (of 5,356 total)