Forum Replies Created
Viewing 15 posts - 106 through 120 (of 663 total)
-
RE: Binary data
Step 1
quote:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Test]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[Test]
GO
CREATE TABLE [dbo].[Test] (
[A] [int]...
-
RE: Binary data
Sorry did not read the full article.
A better solution is to use textcopy.exe
See usable example at http://www.mssqlcity.com/Articles/KnowHow/Textcopy.htm
-
RE: Binary data
If you restore the database under another name, retrieve and save the object to disk.
-
RE: The results that fn_get_sql() returns.
Side attraction but noticed the 'SELECT *'
-
RE: INSENSITIVE CURSOR
May in crease the tempdb size intially but should have less potential locking issues.
-
RE: By author search...
Plus by category, like a hierarchy.
Ok, maybe a checkbox, etc.
-
RE: Debugging Stored Procedures
quote:
Troubleshooting the Transact-SQLDebuggerhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_servtools_5cfm.asp
quote:
http://www.windows2000faq.com/Articles/Index.cfm?ArticleID=14347September 22, 2003 at 6:10 pm
-
RE: CREATE RULE
BOL 2000:
LEN
Returns the number of characters, rather than the number of bytes, of the given string expression, excluding trailingblanks.
DATALENGTH
Returns the number of bytes used to represent any expression.
-
RE: CREATE RULE
[1-9] doesn't work
BOL 2000:
[] = Any single character within the specified range ([a-f]) or set ([abcdef]).
Then the next become 'hardcoded', first character must be a 0 and the second must...
-
RE: Slow running query
Beath, just interest sake, how many characters per row, plus minus, just to get an idea of the total amount of bytes being send to the client.
-
RE: Using File Groups
I'll go with Allen_Cui, first try and determine what is causing the problem
Reminder: Make sure your backups have been done regularly, just in case.
-
RE: Problem BCP (Format File) with NULL Fields
One way is to specify a select statement and for the character based columns use IsNull(Col1,Space(10)).
-
RE: Database log size a problem
Wondering if there maybe an open transaction hanging around. When last did you rebooted the server
Viewing 15 posts - 106 through 120 (of 663 total)