Using MS SQL Server
in [Microsoft SQL Server]
|
PHP/MS SQL - automatic formatting: varchar, datetime Hi, I want to change 2 default behaviors of ms-sql server within a connection. 1. All varchar (etc.) fields should be returned as UTF-8. I know about field attribute collation and convert function, but I want simple query like: SELECT * FROM table; to return all varchars as UTF-8, no matter... 11 Apr 2008 20:40
Data Shifting Between Records > They say they enter data in the record, check it, everything's fine. Then, sometime later, they go back and look at the record, and it has data from another record in one or two fields. It's happening about once or twice a month now. With this description I would guess, that two users are entering the ... 9 Apr 2008 23:40
xSQL Profiler - monitor multiple SQL Servers from one central location xSQL Software has just released a public beta of xSQL Profiler, an easy to install, easy to use, agent-less SQL Server monitoring tool that can be utilized for performance, auditing and compliance related tasks. xSQL Profiler utilizes the same underlying technology as Microsoft SQL Profiler. SQL Server DBAs will... 9 Apr 2008 17:55
How can I avoid using a cursor here? In my client's timesheet system (Intranet-hosted ASP.NET application) there are three tables (see below for DDL). In normal use a client can enter data into the tblTimesheetInputDetail directly for an Employee, identified by the Employee's PinNo. However, they want to be able to enter timesheet information for m... 9 Apr 2008 17:07
How do I make a backup device file smaller ? Hi I have a backup device file ... ".bck" whick has grown pretty large. Is there any way I can reduce its size ? Thanks David Greenberg ... 11 Apr 2008 17:29
Update including Top, Orderby and updating 2 columns in an update query using TOP (rshivaraman(a)gmail.com) writes: Now The TableA is populated with a lot of CustomerRecNos. I have to update the rows in TableA with corresponding officersids and officernames from TableB for their respective cusotmerrecnos in TableA The rules for assigning an officersid and officername to a customerrecno... 7 Apr 2008 18:20
Update including Top, Orderby and updating 2 columns in an update query using TOP Hi All : I have a TableA with a columns CustomerRecNo, A_ID, A_Name There is a tableB with columns,CustomerRecNo, OfficerSID, OfficerName, OfficerRank Now The TableA is populated with a lot of CustomerRecNos. I have to update the rows in TableA with corresponding officersids and officernames from TableB for t... 7 Apr 2008 17:48
list of services how to get a list of services running on a remote machine ServiceController class works gr8 on my local machine i dont see how to get the services running on another computer thanks ... 7 Apr 2008 11:27
help with DDL trigger. Moved from other newsgroup. > Were you able to get yourtriggerworking, by the way? -- Erland Sommarskog,SQLServerMVP, esq...(a)sommarskog.se Erland, Yes, thank you very much for you help. (I just got back from vacation). Your last recommendation about the GO was the key. Actually, I now want to enhance my process. If you recall ... 7 Apr 2008 17:48 |