Forum Replies Created
Viewing 15 posts - 286 through 300 (of 363 total)
-
RE: DateTime parmater for sp and debug
have you tried putting single quotes around the value? i.e. 'mm/dd/yyyy mm:hh:ss'
Once you understand the BITs, all the pieces come together
-
RE: information_schema.tables
Try
master..sp_tables tables, information_schema
The views only exist in the Master db, but will use the sysobjects from the currnt db.
Once you understand the BITs, all the pieces come together -
RE: Table Design Question
If I were you, I'd make a view. Even if for right now it's just SELECT * FROM Table. This way you can more easily test various query senarios by...
Once you understand the BITs, all the pieces come together -
RE: How to test DOS "file in use" status?
Thanks David, I'll give it a try and report back.... setting up a "very slow test senario" takes me a few.
Once you understand the BITs, all the pieces come together -
RE: DateTime parmater for sp and debug
Can you provide an example of the TSQL code you are using when calling the SP?
Once you understand the BITs, all the pieces come together -
RE: Table Design Question
A good option may be to do "vertical partioning"... Create separate tables for data, then create a VIEW combining the tables. This is especially nice in SQL Server... When creating...
Once you understand the BITs, all the pieces come together -
RE: How to test DOS "file in use" status?
Found something interesting...
xp_getfiledetails [Last Written Time] has the timestamp of the mobile PC file until it has completed it's copy. After completion, [Last Written Time] shows target server time....
Once you understand the BITs, all the pieces come together -
RE: Max size of a Select statement
I do not know specifically if the "IN (...)" has a size / items limit, but I've submitted lengthy SQL statements to SQL Server without problems. One exception I have...
Once you understand the BITs, all the pieces come together -
RE: How to test DOS "file in use" status?
Brian, both are good ideas, but changing the mobile application in this manner is not feasable. WINPC deposits multiple other files also etc. and complexity of this issue is more...
Once you understand the BITs, all the pieces come together -
RE: How to test DOS "file in use" status?
Thanks David.
Seems like xp_fileexist ruturns "OK" data as soon as the file exists, but prior to the file being available to import. I'm looking for a "file property" something...
Once you understand the BITs, all the pieces come together -
RE: Elevate permissions within stored procedure
SQL Server VIEWs can even limit the data that may be inserted / updated if you use the WITH CHECK OPTION in the view.
CREATE TABLE A (ID Int,...
Once you understand the BITs, all the pieces come together -
RE: Register same SQL Server more than once in EM
Can you register it once using the servername, then again using the IP, or even multiple IPs?
Once you understand the BITs, all the pieces come together -
RE: How to test DOS "file in use" status?
File is deposited from a WINPC connected to server using a "UNC Share", then VB application performs a WINAPI "File Copy".
Each mobile WINPC deposits it's own, same name every...
Once you understand the BITs, all the pieces come together -
RE: How to get Time from Getdate()
Select SubString(Convert(Varchar(25), GetDate(), 9), 13, 8) + Right(Convert(Varchar(25), GetDate(), 9), 1) + 'M'
Once you understand the BITs, all the pieces come together -
RE: How to get Time from Getdate()
Select Convert(Varchar(8), GetDate(), 8)
Once you understand the BITs, all the pieces come together
Viewing 15 posts - 286 through 300 (of 363 total)