Using OPENROWSET to read large files into SQL Server
OPENROWSET is a T-SQL function that allows for reading data from many sources including using the SQL Server’s BULK import capability.
2008-12-29
6,687 reads
OPENROWSET
Using SQL Servers OPENROWSET to break the rules
Many times I would like to insert the results of a stored procedure into a table so I can do some extra processing with the result set. I always have to create the table first in order to perform an Insert Into Exec on the desired stored procedure since Exec Into is not an option. Is there a way to do this without having to manually create the table each time?
2008-08-14
4,696 reads
2005-03-01
RE: The Case for GUIDs
I think everyone is losing the point about using GUID on sql server... I have a problem with this before because one in 20 milion or so I got duplicate record .... Let's just say out of 50 milion GUID there are about 30-50 duplicate record generated and Microsoft hasn't really fix this problem yet. mom
2005-02-23
RE: Extended Stored Procedures
You can post them here, most of the people that scan the forums use a page that brings them new posts since their last login, so it will be found.
2005-01-27
RE: Idera software (any good)
Question, in what way was the reporting weak? Do you mean to say that you can't print the reports or there are not enough of them. If this is the case then it will affect my decision to recommend this product.
2004-12-15
Converting a varchar
Hi,Im trying to create a varchar based on quarter and year putting them together then, using that string as an identifier for a database for an insert in a trigger, for example: DECLARE @quarterSET @quarter = 'Q1' + '2004'INSERT INTO [dbo].[@quarter] -- whatever you want to insert i cant figure out how to convert that name because the […]
2004-07-13
RE: Using a stored procedure parameter as a column name
I'm curious as to why you say this. Of course, I am making the assumption that the mechanism used to identify which rows should be updated is essentially static, possibly identifying a single row via a primary key, or a set of rows via a piece of a logical primary key. Nothing in the original […]
2004-03-29
RE: Question of the Day for 10 Feb 2004
RAID 5 is fast and reliable. RAID 5 is THE choice of all major hardware manufactures and corporate consumers. If it’s good enough for them, it’s good enough for me. I'm sure RAID 1 is fine for some small shops.
2004-02-10
Denying access to both master and msdb databases
Hello everyone,This might sound like a dumb question but I just want to get everyone's opinion on this. When I initially setup SQL Server I noticed that both the master and the msdb database grant public access to all tables, views and stored procedures.Is this a good idea ? I really don't think users should […]
2004-01-29
3 reads
Blogs
New Pluralsight Course – Securing Azure Kubernetes Service (AKS) Clusters
My new course “Securing Azure Kubernetes Service (AKS) Clusters”, co-authored with my good friend...
Join Denny Cherry and Associates at SQL Bits 2023
I am very excited and lucky to be speaking once again at SQLBits along...
Daily Coping 27 Jan 2023
By Steve Jones
Today’s coping tip is to try something new to get out of your comfort...
Forums
Case statement with time
Hello everyone I hope everyone's ok. I have this query and I'm trying to...
what are the best books to become a SQL developer?
what are the best books to become a SQL developer?
what are the best books to become a DBA SQL?
what are the best books to become a DBA SQL?
Ask SSC