Description:
Microsoft SQL Server newsgroup.
|
|
|
milliseconds in datetime variable.
|
| |
Hi, I am wondering how to compare 2 datetime values so that milliseconds are taken into account. as an example I have the following script. it appears that if I compare two datetime variables then milliseconds are not taken into account, however if I compare two datatime2 variables then milliseconds are taken into account.... more »
|
|
creating table on secondery filegroup
|
| |
hello there i have database with two filegroups and for each filegroup there is diffrent file name How can I use Select .. into and create new table on secondery filegroup?
|
|
Sql Server on VMWare
|
| |
Hi, Can anybody give me some right direction or usefull link 1. About VMware environment 2. How to Install and configure Sql Server 2005 on VMware. 3. Is there any performance change on VMware. Regards Rahul
|
|
Free Tools for SQL Server - SQLsoft.co.uk
|
| |
Hi All, We've written a number of (I think!) handy tools over the past few months which are available from here: [link] Newly released is SQLscripta, which both searches _and_ scripts sprocs, functions, views and triggers, with searches being performed across multiple databases - it's quick and makes a great alternative... more »
|
|
Transaction load
|
| |
Hi there, I have an app that needs to upload a lot of files into my DB, where each file will typically be perhaps 400K but can max out at 16MB (though that would be very rare). Can anyone comment on whether it will heavily tax my system if I wrap each file's upload in its own transaction. There will... more »
|
|
Modify statement to run sp_executesql
|
| |
To learn sp_executesql, I create a small code. It works fine as below. CREATE TABLE [dbo].[#A]( [authno] [nchar](10) NULL, [Authname] [nvarchar](50) NULL ) ON [PRIMARY] INSERT INTO #A (AUTHNO, AUTHNAME) VALUES('444' + '~', 'EEE') Once run sp_executesq, got an error said Incorrect syntax near '444'. How to fix it?... more »
|
|
SQL 2008 - FILESTREAM OpenSQLFilestream invalid handle
|
| |
SQL 2008 Express running in Virtual PC on Windows XP Pro, accessed from a "real" machine with Windows XP Pro via TCP/IP and sql authentication (the server has enabled mixed mode). FILESTREAM is enabled for remote client streaming, database allow for Full Access with FILESTREAM. The table is created properly and there's no problem with "traditional" reading/writing... more »
|
|
Database Table Design
|
| |
I have a [user] who belongs to a [group] and writes an [article] using a certain [computer]. The user can move to a different group and a computer can be assigned to a different person. Also, we rent the computers from a company that charges us per hour usage. So we receive a [bill] monthly for a [user] of certain... more »
|
|
Output only 255 characters
|
| |
I have a stored procedure that builds insert statements for the table I pass. This procedure works perfect at my office. But at my client site, it doesn't seem to work correctly. Both are Sql 2008. But one is on a server the other is on a desktop. Not sure why that would be. I was confused as to why my insert statements were getting cut off until I... more »
|
|
|