Viewing 15 posts - 2,611 through 2,625 (of 3,655 total)
I seem to remember that there was a thread about it once before but can't find it now.
The E is something to do with powers of 10. 1E1 =...
December 12, 2005 at 12:29 pm
Basically NVARCHAR is a double-byte version of VARCHAR.
Some procedures demand that an NVARCHAR is passed and sp_executesql is one of them
If you run
sp_executesql 'SELECT * from sales'
you get an error...
December 12, 2005 at 5:53 am
SmallDateTime stores date/time value accurate to the minute
DateTime stores date time values accurate to 3 milliseconds.
December 9, 2005 at 2:23 pm
Putting your code in stored procs is best practice.
Putting your SELECT DISTINCT into CommandText means that you have to grant read access to your table therefore someone with a valid...
December 6, 2005 at 9:52 am
Create a temporary table that holds the extracted IP Address from MT then do an inner join between status and your temp table
December 6, 2005 at 2:05 am
If you are using ADO to connect to the database have a look at the ADO Stream object.
If you are using .NET use a file stream and Binary reader...
December 5, 2005 at 8:35 am
I believe that SQL Clustering has a limit on the number of nodes but assume a server per node plus some form of centralised storage that is available to all...
December 2, 2005 at 1:48 pm
Well you are likely to get more than one "Chris Smith" as well as more than one "Chris" and more than one "Smith".
ALTER TABLE dbo.MyTable
ADD CONSTRAINT unq_MyTable UNIQUE (FirstName,LastName)
December 2, 2005 at 1:43 pm
If I get a vague definition of what an update on a table is supposed to do I carry out something similar to the SQL below:
CREATE PROC dbo.setTable @id Int,...
November 29, 2005 at 2:19 am
I wish that the editorial was included in the home page of the site.
It adds a bit of variety and is a reminder that there is a human...
November 29, 2005 at 2:12 am
If all your tables have a clustered index then
SELECT object_name(id),SUM(rows)
FROM sysindexes
WHERE indid=1
GROUP BY object_name(id)
WITH ROLLUP
indid=1 is the clustered index
November 25, 2005 at 4:29 pm
I don't have BOL to hand but I seem to remember that you can do something like SELECT @@SERVERNAME
November 25, 2005 at 4:25 pm
Developer edition is supposed to be limited to 5 connections but apart from that they should be identical.
November 25, 2005 at 4:48 am
Viewing 15 posts - 2,611 through 2,625 (of 3,655 total)