Hi

select count(*) from master..sysprocesses where spid > 50 will give you

a rough number. This will include logins from SQL Agent. Note that the

same user can be using multiple connections from...

Hi

create function Split (

@StringToSplit varchar(2048),

@Separator varchar(128))

returns table as return

with indices as

(

select 0 S, 1 E

union all

select E, charindex(@Separator, @StringToSplit, E) + len(@Separator)

from indices

where E > S

)

select...

Hi

update scheme.stockm

set packaging = ''

In your first query inatead of updating, rename this packaging to DUMMY and just add one column and rename this column to packaging . This is...

HI,

You can also try out Dyanmic SQL query in T-SQL

Check out the below link

http://www.sommarskog.se/dyn-search.html#dynsql

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi,

If you have '%' in your column values then you need to implement this in special way. I tought i woule like to give you some information on this.

There are...

HI,

If you setup the VSS or any Code control process the it would have been very easier to do it.

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi

Check out the below link

http://oracle.ittoolbox.com/groups/technical-functional/oracle-dev-l/update-statement-with-case-854527

Thanks -- Vj

http://dotnetvj.blogspot.com

HI

My best advice is to use one of the following options to migrate data between SQL Server and Oracle:

Migration Workbench

You can use Oracle Warehouse Builder (OWB) or any...

Hi,

In simle words you can't do this, its something like i would like to test my C program with out having Computer :).:hehe:

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi

Check out the below link

http://searchsqlserver.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid87_gci1123229,00.html

This will slove yuor problem.

Thanks -- Vj

http://dotnetvj.blogspot.com

HI

Check out the below link

http://www.sqlservercentral.com/Forums/Topic8041-65-1.aspx

http://www.sqlmag.com/Article/ArticleID/23011/sql_server_23011.html

Thanks -- Vj

http://dotnetvj.blogspot.com

Check out thebelow link

http://www.aspfree.com/c/a/MS-SQL-Server/Moving-Data-from-SQL-Server-2000-to-SQL-Server-2005/

http://www.sqlservercentral.com/articles/Administration/installingandupgradingtosqlserver2005/1943/

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi,

One input is You dont have Force keyword in SQL Server and if you want to override the existing view then you use ALTER statement.

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi,

If you simply skip teh WHERE condition between the tables then that will go for Cross Join.

SELECT Title, Customerid

FROM Employees, Orders

Thanks -- Vj

http://dotnetvj.blogpsot.com

Hi

Check out the below link

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3501590&SiteID=17

Thanks -- Vj

http://dotnetvj.blogspot.com