I want to define a default value of "6". When I define the Default Value or Bindings in the Column Properties for my column, it gets converted to ((6)) but then does nothing. When I insert a new ro...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23458956.html
This is an urgent need, and I'd appreciate any input. This is a rudimentary question and should have a rather easy solution.
300 users hitting a heavily updated table from a vb6 desktop app.
...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23464056.html
I have two default values on two columns. One is GetDate() the other is an integer (6). I am developing a visual basic form based on my database table. When I enter a new row, be it from the form o...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23493675.html
I am working on some SQL data maninpulation using stored procedures. I have a table with the following fields:
FullName
LastName
FirstName
MiddleName
SuffixName
I have created a CLR proced...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2358...
I usually put select statements in my code but now my company has begun requiring that we put all our sql in stored procedures. My question is this, will the stored procedure act just like a sql s...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_23607925.html
Zones:
Visual BasicDate Answered: 07/30/2008 Grade: A Views: 0
OK... I changed the requirements on the app I am working on to (hopefully) make it easier. I know this shouldn't be difficult but I have been fighting this for over a week.
Platform: Visual Bas...
http://www.experts-exchange.com/Microsoft/Development/Visual_Studio_Express/Q_22459221.htm...
Does anyone know of a script that I can run that will go to a specific server on my network and return the
1. Operating System
2. Disks and space left on them
3. SQL Server Version
4. Memory ...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Studio_.NET_2005/Q_23489...
I have two hard-coded stored procedures and I would like to merge them into 1 to take a parameter instead, since they both use the same logic.
These are used by two separate reports in Reporting S...
http://www.experts-exchange.com/Database/Reporting_/Q_23683547.html
Im having trouble executing this stored procedure in SQL Server 2005:
It involves a complicated CASE statement and I can not find why it does not compile.
I get the following errors:
-----------...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23740371.html
Using sql query I want to filter an "ID" field, which is the primary key of type 'int', using a variable. The value for the variable is taken from another table's "ID" field, which is also type 'in...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2362...
