Forum Replies Created
Viewing 9 posts - 1 through 9 (of 9 total)
-
RE: Reading txt file then creating new table
Can you use SSIS? If yes, you can create a parameter to pass the file name and you can create a table from flat file, do anything you want and...
-
RE: Question of the Day for 15 Jan 2007
And I'm thirding that!!! Here is the explanation from the link in that question:
By default, SQL Server does not allow ad hoc distributed queries using OPENROWSET and OPENDATASOURCE against providers...
-
RE: How to solve this problem with numeric data
So how about if you do this:
select
convert ( real ,2.5000 )
-
RE: Can VIEWs bring better performance for our queries?
We have used partinoined tables and performance is MUCH better than before. I think this is the best option you have.
-
RE: Developers and DBAs
I'm a SQL developer too and have been in that situation, however I learned from my mistakes. I admit it, it wasn't always other people's fault! The thing is that they...
-
RE: Need help with simple delete and insert with the input parmeter
You can add these queries before the first insert into
just an example for the first part which is TotalCount) select...
-
RE: Question of the Day for 27 Oct 2004
OK, correct me if I'm wrong. The only reason query comes back with 1900... date in second row is that insert statement for that row was the second insert statement....
-
RE: Finding all views
Thank you for all your help.
Actually the result of JM's query, was the the script of all views in the server and I searched for my table name in the...
-
RE: Finding all views
Thank you for all your help.
Actually the result of JM's query, was the the script of all views in the server and I searched for my table name in the...
Viewing 9 posts - 1 through 9 (of 9 total)