rho_pooka (1/11/2014)

---

Greetings! On chapter four looking at inline table valued functions. Can someone translate this code into English? I see this at the beginning of a lot...

If you are routinely using cursors in your production code you are more than likely doing things wrong. Cursors should be avoided for most database activity. The only...

I'm trying to figure out why you would want to restrict your developers from using a valid construct for solving user requests.

Any answer you get here will be opinion. You really should be talking to your SQL Server vendor or Microsoft.

mwitthoft (1/10/2014)

---

I am battling a similar "self-restarting cursor" . The defect

(a) occurs 100% on one server

(b) occurs 0% on another server

Pseudocode

Declare cursor as..

Open cursor

Fetch next

while @@FetchStatus

...

Trying to figure out how a UNION (or UNION ALL) could be used to append malicious code to a SQL query. Can you provide a couple of examples?

SQLSteve (1/10/2014)

---

Stored Procedure which creates a scheduled backup job to run the SP that backs the database up..

To run this

Exec dbo.createbackupProc [Database name], [Number of stripes]

/****** Object: StoredProcedure [dbo].[CreateBackupProc]...

Just for s & g's could you post a sample of what the final script generated looks like?

SQLSteve (1/10/2014)

---

Declare @backupcommand varchar(2000)

select @backupcommand = 'Backup database [' + @Databasename + '] to '

while @splits < @splits1

begin

select @backupcommand = @backupcommand +

'disk = ''' + @Subdir +...

Luis Cazares (1/9/2014)

---

Oh my, so much code! My laziness wants to write less.

declare @SSDate datetime = '20140109'

declare @CharSSDate char(10)

SELECT CONVERT( char(10), @SSDate, 103), --4-digit year

STUFF( CONVERT( char(10), @SSDate, 103),...

Just a note to all planning to attend PASS 2014, I may NOT be there this year. It all depends on what transpires here in Afghanistan. Since I...

That version does not include SSIS or SSAS. If you want to learn these areas I would recommend purchasing the Developer Edition of SQL Server 2012. This will...

hjvegt1960 (1/6/2014)

---

Hi all

I have recently installed SQL Server 2012 (from a download from the SQL Server pages)

After a lot of practising with queries I would like to start with the...

Okay, you are missing the point. Even though SQL Server Express can be used as a Desktop database system, it is a full blown RDBM system. It is...

tamer.h (1/5/2014)

---

good day for everybody,

please advice regarding the below query, I've got an error

"Arthimatic overflowerror converting expression to data type datetime"

SELECT nEventLogIdn, DATEADD(s, nDateTime, '1970-01-01 00:00:00')...