Do I need to assign values to my strings here?
sField is set by the event ( AllRadioButtons_CheckedChanged), when you click radiobutton.
select PHONE.HWMODEL, SIM.PHONENUM , SIM.USER_ID
where LTRIM(RTRIM(PHONENUM))<> '' ) as SIM
//I am trying to pass the 4 values of @Field to my 'If else statement' here: If (radiobutton1.checked), then sField = ServedBy_CertNum'...
If I understand your question , the query is:
select max (hwtype) hwtype , max (PHONENUM) PHONENUM , user_id "user"
BTW, Avoid using sp_ as a prefix for naming stored procedures :)
In SQL Server, the sp_ prefix designates system stored procedures.
If you use that...
The procedure returns data (select .. from ) , so you should use ExecuteReader not ExecuteNonQuery
Using ExecuteNonQuery is intended for UPDATE,...
The SQL server may not be uninstalled successfully.
Try to manually remove programs , for details read:
it may be insufficientpermissions.
please, try to grant Execute permissions for the procedures to the RSExecRole role
for more details read:...
I'm happy that you solved the problem and thanks for feedback.
ASYNC_IO_COMPLETION wait type is normal when backup is running .
Check if any Other Jobs /process are running during the backup that cause I/O...
The problems in the query are:
The namespace in the Resultado node is not valid.
modify it to be: xmlns="" instead of...
you can use DMV viiews and run the following query and get information needed to know what sql script -user -ip- many others:
You can't update multiple tables in one statement.
you have to execute two separate update statements in a batch
Use a unit of transaction to make...
Run the test on the edition similar to the production environment.
There are different performance capabilities based on edition which may effect the...
I expect the problem may be in the SAN, please can i know:
The type of disks used in SAN SATA/ SAS/ Fiber and speed of disk.
The number of disks...
The differential backup is based on the most recent, previous full backup.
As you rebuild all indexes, the database is completely modified,so the...
Connection pooling can be used by an ODBC application exhibiting ODBC 2.x behavior, as long as the application can call SQLSetEnvAttr.
your database is 3GB , memory is 64GB , 24 processor , so database should swim in cache , and server should be faster, so it may HW problem:
broadband connection with 2-10 mbit/s
the client in LAN run with speed 100 mbit/s (may 1Gb/s)
so you should expect slow for data from server to...
- what the size of datbase?
-How many record in the tables included in the query?
-can you check the execution plan of the query in the two servers?...
Separate names with a comma.