If the idea is to simply dump the output to a csv file, the following powershell script will do that for you.

You'll have to parameterize the Query.

invoke-sqlcmd -Query "select...

A +1 on the Itzik TSql Fundamentals book. Money well worth spending.

Look up the ROW_NUMBER() Function in Books Online. You can use it to distinguish the rows as you see fit then select the one you want.

If you do choose...

You should be able to see it from within object explorer in management studio, if that's what you would prefer.

Go to your server node within object explorer -> Databases ->...

I believe the IDENT_CURRENT Function did exist in Sql Server 2000 but do bear in mind that it will return the last identity value generated for a specified table in...

matt_garretson (7/23/2013)

---

This is great!!! Thanks!!! I just tried to run this and yes, it takes a long time. If I wanted to turn this into a stored procedure how would...

kapil_kk (7/18/2013)

---

Instead of specifying it in parameter list you can assign GETDATE() to local variable inside stored procedure body:

CREATE PROCEDURE sp_MyProcedure

@Record_ID Varchar(12),

@OtherKey_ID Int,

@Comments VARCHAR(MAX) = NULL

AS

BEGIN

DECLARE @DateParameter DATE...

Here comes a silly question...

What product does SQL Sentry offer that does what the OP requires?

This is a difficult one to answer without access to your database or a lot more info. on it.

Maybe a database/entity relationship diagram.

Tables can be "related" without "hard coded" Foreign...

A couple of others:

http://www.haidongji.com/2008/11/20/what-does-syspolicy_purge_history-job-do/

Take a look at the Job Steps for the job then take a look at:

http://msdn.microsoft.com/en-us/library/dd795279.aspx

errr.. actually you want luis's given your requirements.

DBA24 (6/11/2013)

---

Hello,

I am new to tsql coding and I am in the process of adding a piece of code to an already existing stored proc. Here is my code

select @Count1=count(*)...

As has already been pointed out, nested transactions don't exist in Sql Server.

Infact, all it appears to do is increment or decrement @@TRANCOUNT. I don't believe, it even writes anything...

Krishna1 (6/11/2013)

---

create table remarks ( remark varchar(1000)

create procedure P1 as

begin

while loop

begin

.....

insert into remarks ()

...

Darn,...