OPENROWSET

External Article

Using SQL Servers OPENROWSET to break the rules

  • Article

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

Technical Article

RE: The Case for GUIDs

  • Reply

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

Technical Article

RE: Idera software (any good)

  • Reply

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

Technical Article

Converting a varchar

  • Topic

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

Technical Article

Denying access to both master and msdb databases

  • Topic

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

By

My new course “Securing Azure Kubernetes Service (AKS) Clusters”, co-authored with my good friend...

Join Denny Cherry and Associates at SQL Bits 2023

By

I am very excited and lucky to be speaking once again at SQLBits along...

Daily Coping 27 Jan 2023

By

Today’s coping tip is to try something new to get out of your comfort...

Read the latest Blogs

Forums

Case statement with time

By pedroccamara

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?

By vpmaciel

what are the best books to become a SQL developer?

what are the best books to become a DBA SQL?

By vpmaciel

what are the best books to become a DBA SQL?

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers