I have created a union view using a script. I know a script is the only way to create or modify this type of view, however, I unintentionally attempted to modify the view without using a script whi...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2284...
I would like to create a database in SQL server that will support both english and foreign language.
Most of the database will be in english, but i would like to create a couple of tables that ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22892484.html
I am having a brain freeze on the join where you see every combination of both tables. Here is what I have:
Table of valid Stages
Table of valid Status
Table of statisctics
I need to see all...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22905222.html
When I click on a Table properties in Enterprise manager it show 5,132,000 records however when I do a query against this table and use count(*) It show 5,132,414 records. Any ideas?
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22932162.html
if isnumeric( substring( @CODE , 2, 4 ) ) = 1
Can someone please break this down for me and tell me what it means...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22955597.html
I need to find the best possible server/hosting solution for a website client who as part of their website sends out newsletters to many of its members. Each of these newsletters go out to around ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22983565.html
I encountered a situation where I was using Management Studio on my workstation to execute a statement on a remote SQL Server. We lost network connectivity for a moment and I received an error in ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23003919.html
Hi all, i need to make a backup of a SQL Express database on a regular basis. The machine itselt is not a server hence doesn't get backed up as part of a regular job. I'm taking backups at present ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23021320.html
I am trying to write a function to accept a heading in degrees (0-360) and convert it to text lik NE or SW. The included code compiles but when I try to use it, I get unexpected results. It seems ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23022141.html
I am trying to pass parameters to a store proc from my C# form. I am trying to output some values after the store proc is run and so when i declare the sql params this is what i do (see the attache...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2305...
