RE: date format in stored procedure
Select Convert(char(8),GetDate(),101) Or then Select Convert(char(8),HDate,101)
2003-04-28
security
RE: Problem working with nvarchar over 6 digits
Could you provide a sample patient id that does work, a sample one that doesn't and the exact code that executes doQuery() prcoedure. There has to be something in the ASP code that is stripping/converting the value passed in the QueryString.
2003-04-28
1 reads
RE: Problem working with nvarchar over 6 digits
Here's the DDL: patidpri,int,no,4,10 ,0 ,no,(n/a),(n/a),NULL ClientID,int,no,4,10 ,0 ,yes,(n/a),(n/a),NULL CProviderID,int,no,4,10 ,0 ,yes,(n/a),(n/a),NULL PhysicianID,int,no,4,10 ,0 ,yes,(n/a),(n/a),NULL PatientID,nvarchar,no,100, , ,yes,(n/a),(n/a),SQL_Latin1_General_CP1_CI_AS Birthdate,datetime,no,8, , ,yes,(n/a),(n/a),NULL PriDiag,ntext,no,16, , ,yes,(n/a),(n/a),SQL_Latin1_General_CP1_CI_AS SecDiag1,nvarchar,no,100, , ,yes,(n/a),(n/a),SQL_Latin1_General_CP1_CI_AS SecDiag2,nvarchar,no,100, , ,yes,(n/a),(n/a),SQL_Latin1_General_CP1_CI_AS Medications,ntext,no,16, , ,yes,(n/a),(n/a),SQL_Latin1_General_CP1_CI_AS Allergies,ntext,no,16, , ,yes,(n/a),(n/a),SQL_Latin1_General_CP1_CI_AS NANDA,ntext,no,16, , ,yes,(n/a),(n/a),SQL_Latin1_General_CP1_CI_AS Notes,ntext,no,16, , ,yes,(n/a),(n/a),SQL_Latin1_General_CP1_CI_AS Dev_100_Start,datetime,no,8, , ,yes,(n/a),(n/a),NULL Dev_200_Start,datetime,no,8, , ,yes,(n/a),(n/a),NULL Dev_300_Start,datetime,no,8, , ,yes,(n/a),(n/a),NULL Dev_400_Start,datetime,no,8, , ,yes,(n/a),(n/a),NULL Dev_500_Start,datetime,no,8, […]
2003-04-28
1 reads
RE: Recreating Transaction Log From Scratch
Try this CREATE PROCEDURE dbo.usp_ReCreateTranLog /************************************************************************* FILENAME: SQL SERVER OBJECT NAME: dbo.usp_ReCreateTranLog AUTHOR: Phillip Carter DATE WRITTEN: 26 Feb 2002 PURPOSE: Detach and reattach database without specifying transaction log. causing SQL Server to create log file with default size of 512kb ACTIONS: Ensure user is member of sysadmin role Ensure database specified is not a […]
2003-04-28
RE: Problem working with nvarchar over 6 digits
If Your Field is Numeric only and not over 50 characters long I suguest you use char(N) where N is the length of your ID number. It works great for me.
2003-04-28
1 reads
RE: Termainl Services Performance
We are running terminal and remote admin with SQL and the impact is not so high to stop using it.
2003-04-28
RE: tempdb is not getting recreated
Have you tried using Enterprise Manager, right clicking on TEMPDB, selecting properties and then checked to see the default size of the database? That's what TEMPDB will start at when it's rebuilt. -SQLBill
2003-04-28
1 reads
RE: Termainl Services Performance
Are you running the application terminal services or the remote admin? We run remote admin here and it doesn't impact very much. Running app mode will impact more as the resource requirements go up, but it depends on what they are doing as well. You'd have to measure the load change as more users connect. […]
2003-04-28
RE: "with sample xxx percent" is your friend ...
Havent seen that happen, but I guess it could happen if your data was skewed just do. I would think (but not know for sure) that rebuilding the index would eliminate the problem, so you'd only have worry about cases where a lot of data was added/updated that fell outside the stats you had AND […]
2003-04-28
2 reads
RE: tempdb is not getting recreated
Tempdb is recreated to a default size defined in master not based on model (I believe it is the size value in sysaltfiles). However, it is not uncommon the file is not deleted and when you shut down the SQL Service may need to delete yourself to correct. Delete the tempdb file then restart the […]
2003-04-28
1 reads
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers