Hi

If you have Visual Studio (Database Professionals or Team Suite) you can create SQL Server Database projects which can handle all these things. You can configure a database and Visual...

You can enclose your current result with ROUND/CONVERT. Follow Dave's links to see how the functions work.

Greets

Flo

... or CONVERT(INT, 85.074626865671600)

Hi Vivek

The script was made for SQL Server 2005. However, if you change VARCHAR(MAX) to VARCHAR(8000) it might work, if your tables are not too wide.

In addition change:

SELECT @object_id =...

Hi Pedro

It depends...

SQL Server missing index advisor suggests way to many indexes - in my opinion. If your query is executes really often, the index might make sense. Otherwise one...

http://www.sqlservercentral.com/Forums/Topic814847-149-1.aspx

Please stop your bulk thread import...

http://www.sqlservercentral.com/Forums/Topic814847-149-1.aspx

Please stop your bulk thread import...

Hi

Since there is no sub-query in your posted statement there seem to be a sub-query within your scalar function which gets its value from a SELECT. Probably this returns more...

Hi

Er.. my first post contains a complete sample how to create a procedure, return several rows and catch the result from calling side.

Which part is missing?

Greets

Flo

http://www.sqlservercentral.com/Forums/Topic814847-149-1.aspx

Guy or gal... actually you started seven threads with general interview questions.

If you try to get information for an interview, take a book and learn.

If you are not intended to...

Hi

Try this:

DECLARE @T1 TABLE

(idno varchar(30) NOT NULL,

seqno varchar(30) NOT NULL,

Last_Name varchar(30),

First_Name varchar(30)

PRIMARY KEY (idno,seqno)

);

DECLARE @T2 TABLE

(idno varchar(30) NOT NULL ,

seqno varchar(30) NOT NULL ,

FLAG varchar(1),

PRIMARY KEY (idno,seqno)

);

INSERT INTO...

Read this article top down: Database Normalization

Start here: DBCC INDEXDEFRAG

(All your concurrent general questions sound like interview questions...)

Read this article bottom up: Normalization