Viewing 15 posts - 2,581 through 2,595 (of 7,168 total)
A DELETE-JOIN will work well. One other option I thought I would share. After working with it more and more I find the MERGE syntax to be quite intuitive and...
January 1, 2013 at 5:24 am
GilaMonster (1/1/2013)
opc.three (12/31/2012)
January 1, 2013 at 5:02 am
SQL Server 2012 offers a lot of great new functionality but with upgrading comes cost and companies are typically slow to shell out the money if the current system supports...
January 1, 2013 at 4:50 am
pooya1072 (1/1/2013)
can i use this to restart SQL service ...like that i Right click on Server name and Choose Restart.i want do this in T-SQL.
No, unfortunately not. You could certainly...
January 1, 2013 at 4:45 am
Megha P (12/31/2012)
I have following code to execute. i want to have functionality to send email for the following query output in text attachment, please note that query...
December 31, 2012 at 5:21 pm
Sounds like homework, which is fine, I am happy to help, but please post the some table definitions (CREATE TABLE statements) and some sample data (INSERT statements) as well as...
December 31, 2012 at 5:12 pm
RTSQL (12/31/2012)
December 31, 2012 at 5:09 pm
Phil Parkin (12/31/2012)
How about this... Go find a random person, show him or her your copy of SQL Server, then ask how he or she feels about it.
I thought I'd...
December 31, 2012 at 3:06 pm
pooya1072 (12/31/2012)
hican i change the properties of a server instance with T-SQL ...like Enabling mixed mode or change the name of server ?
Have you learned about the Script button in...
December 31, 2012 at 3:05 pm
RVO (12/31/2012)
Vendor documentation (for SQL 2005) says:"assign the system administrator permission to each of the following roles:
SQLAgentUserRole,
SQLAgentReaderRole, and SQLAgentOperatorRole".
What are the equivalents of these Roles in SQL 2008?
These are...
December 31, 2012 at 2:57 pm
It depends on what you need to support. You can have an instance of both versions of the database engine and SQL Agent installed side-by-side. Just be careful when in...
December 31, 2012 at 12:24 pm
Remember that D:\ is from the perspective of the server. If you have downloaded the AdventureWorks mdf file to your own D:\ drive and are trying to attach it to...
December 31, 2012 at 12:23 pm
Those requirements are a bit vague. Are you running a select statement? An update? What will your CSV look like?
Here is some boilerplate PowerShell code to help you get...
December 31, 2012 at 12:10 pm
Scott D. Jacobson (12/31/2012)
opc.three (12/31/2012)
December 31, 2012 at 12:02 pm
Viewing 15 posts - 2,581 through 2,595 (of 7,168 total)