Results 1 through
10
of the
Microsoft SQL Server
discussion
board
After inserting a record, how do you correctly return it's ID assuming it's an identity field?
Lots of people use @@identity, though this is bad practice often times, as it can return values you don't expect. For example if you do and insert and the table happens to have a trigger that does another insert, @@identity will return the ID of the
[...]
http://www.rockfloat.com/board/post/?id=516
May 09, 2006 @14:41
(Replies: 0)
How do you query for user connections on mssql?
try this:
SELECT CONVERT(varchar(20),EntryDate,120) as [Date/Time]
, EntryValue as [Connected Users]
FROM UserConnections
WHERE (CONVERT(varchar(10),EntryDate,101) = '01/1/2005' AND
(DATEPART(HOUR,EntryDate)>= 5 AND
DATEPART(
[...]
http://www.rockfloat.com/board/post/?id=1
May 17, 2005 @17:08
(Replies: 0)
What is the equivalent of now() in microsoft sql server?
mssql uses getdate()
-- getdate() returns both date and time
select * from table where field >= getdate();
-- convert(varchar, GETDATE(), 101) returns just date
select * from table where convert(varchar, field, 101) = convert(varchar, GETDA
[...]
http://www.rockfloat.com/board/post/?id=52
November 29, 2004 @19:23
(Replies: 0)
how can you sort on lastname if the field your using has both first and last name in it?
this is by no means a perfect solution... but you can try something like this:
select *, right(rtrim(strFullName), (len(rtrim(strFullName)) - CHARINDEX(' ', rtrim(strFullName)))) as strLastName
but this doesn't work very well when the field als
[...]
http://www.rockfloat.com/board/post/?id=94
December 17, 2003 @18:14
(Replies: 0)
[DBNMPNTW] Access Denied when connecting to ms sql using sql authentication
this could be because your client is trying to use named pipes when it should be using sql authentication. try adding this to your connection string:
NETWORK LIBRARY=DBMSSOCN
John M.
http://www.rockfloat.com/board/post/?id=182
March 26, 2003 @16:05
(Replies: 0)
Any ideas what this error is: '80040e0c'
Microsoft OLE DB Provider for SQL Server error '80040e0c'
Command text was not set for the command object.
John M.
http://www.rockfloat.com/board/post/?id=414
October 04, 2002 @22:54
(Replies: 0)
how to installl sql server manager 2000
try this:
execute: sql2k_cdrom\english\ent\setup.exe
not finished
http://www.rockfloat.com/board/post/?id=31
September 04, 2002 @14:43
(Replies: 0)
how to install sql server 2000 on windows professsional
try this:
execute this file: sql2k_cdrom\english\ent\msde\setup.exe
--> setup will then configure itself
--> then it will prompt you to reboot
--> you now have what you need to install sql server on win2k pro
hope this helps
John M.
http://www.rockfloat.com/board/post/?id=220
September 04, 2002 @14:24
(Replies: 0)
how to backup and restore a complete ms sql database in one file using sql
try running this sql statement while logged into the "master" db as "sa" to backup a database named "whatever":
first do a backup using this sql:
--> backup database foobar TO DISK='C:\backup.bac'
then check to see exactly what's in your backu
[...]
http://www.rockfloat.com/board/post/?id=152
July 29, 2002 @20:06
(Replies: 0)
How to determine what version of sql server your running
Try these while logged in as "sa" using the Query Analyzer:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
or:
SELECT @@VERSION
hope this helps
http://www.rockfloat.com/board/post/?id=394
July 29, 2002 @19:46
(Replies: 0)
