Hello!

Did you need help in identifying system & user databases?

For example, given a database name, do you want to tell if it is a system database or a user database?

If...

Does this help you?

http://www.sqlservercentral.com/Forums/Topic881813-338-1.aspx

Speaking of other workspace improvements that Steve wrote about in the editorial, I like to write and think. I therefore use the whiteboard and/or the notebook a lot and one...

White noise/very light music works great for me. I work in an office with 5-foot tall cubicles and the discussions happening all around distracts me a bit. Very light music...

jane47 (12/2/2010)

---

hi

I have a table that contains records that identified by a number. When a new record is inserted, I need to generate the next number in sequence. (was going...

Straight-forward, simple, yet important question.

Thanks!

The question missed the version of SQL Server targetted, however, this behaviour is still confusing.

From books online:

However, the text will be available to privileged users that can either access system...

You are welcome!

How does this look?

DECLARE @Table1 TABLE (empid INT,name NVARCHAR(50),contact_num NVARCHAR(50))

INSERT INTO @Table1 VALUES (1111,'U1',9119),

...

da.drew (11/25/2010)

---

Hi thanks for your reply, that all makes good sense. What would you suggest for Dates, I read on a website that SQL Server has:

datetime - From January...

How does this look?

FYI - I have created the table variables in SQL 2008 and have hence used row constructors.

DECLARE @Table1 TABLE (wh INT,item NVARCHAR(10),stock INT)

INSERT INTO @Table1 VALUES...

From BOL (http://msdn.microsoft.com/en-us/library/ms175046.aspx):

command_string cannot contain more than one set of double quotation marks.

Also, "If you have trouble with embedded spaces, consider using FAT 8.3 file names as a workaround."

You can also use @@FETCH_STATUS - again, please refer BOL for further details.

Are your QUOTED_IDENTIFIERs ON?

Try using SET QUOTED_IDENTIFIER OFF at the beginning of the query.

Happy Thanksgiving to one and all! Happy shopping to all as well!