|
|
NO! That's horrible! Don't ever do that! 
I once had to maintain a program that did that, I changed it to use a proper date compare and it ran in a quarter of the time (ten minutes as opposed to forty minutes).
|
|
|
|
|
where datepart(mm,bdate)=datepart(mm,getdate()) and datepart(dd,bdate)=datepart(dd,getdate())
|
|
|
|
|
You could also test the difference between birthyear and current year and check using modulo 10 if the person having a big party 
|
|
|
|
|
Unless there's been space travel involved. 
|
|
|
|
|
Aah, you're right, it would calculate the birthday too early. Perhaps Microsoft should include a new concept called slow modulo just for this purpose I think it would be interesting to read about it in SQL Server 2385 Books Online September edition.
|
|
|
|
|
Hi,
if only someone would tell you to enter "SQL datepart" into Google, you might end up finding this[^].
Luc Pattyn [Forum Guidelines] [My Articles]
- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets
|
|
|
|
|
Hi everybody,
I have configured a little SSIS-package that downloads files and synchronize them with my DB.
After deploying it, I run it from the IS Package Store (or whatever it is called). No problems, everything did nice.
Then I created a job for the SQL-Server-Agent in order to have my package run by schedule. But there it just did nothing...
I've worked out all the security-level-related articles like http://support.microsoft.com/?scid=kb%3Ben-us%3B918760&x=16&y=12[^], but nothing helped...
But after activating the option "Run under 32bit environment" (you can find it under "Steps / Execution Options") it worked fine.
Of course I'm glad about it, but I don't see why this option should be activated on a 32bit-system? What's the point? Of course I want it to run under 32bit, BECAUSE my system is 32bit
Any explanations?
Have a nice weekend!
Phil
I won’t not use no double negatives.
|
|
|
|
|
What is a data type and how to retrieve it by c# coding?
|
|
|
|
|
|
Hi,
This is not necessary to insert sound file in database, you can store your file name or path into the database table and store your file to the particular folder inside your projects.
Cheers
Raj
|
|
|
|
|
I have created o form from which I want to be able to store typed in data to a table/query and from this table I am able to create report.
Problem is that I don't know the code for the button which will perform data entry and I will have blank form for another input
And also If typed in data already is in table/query then I want that is asks me if I want change data for that field in table/query.
I am a beginner.Thanks
|
|
|
|
|
|
i had inserted record in table but forget to give primary key....but now i need to give primary key to it..but i cant ???
|
|
|
|
|
If a table has a primary key on it, you won't be able to insert a record without specifying it (unless its an Identity). Can you give a bit more info?
Regards,
Rob Philpott.
|
|
|
|
|
From last 5 to 6 days , our sql Server behaving ubnormally .
CPU utilization goes to 100% , i stopped SQL Agent and Stopped DTC Service. but it did not help at all.
CPU was remains at 100% . then i stopped SQL server.
But after restarting ,CPU agians goes to 100%. I looked in the trace but i was not able to find any query or Stored Procedure which is taking the CPU cycles more than 1000 or 2000.
I am not able to rectify the problem..
Kindly help me out..
thanks in advance ..
i can provide some more details ,If any one needs it.
|
|
|
|
|
|
I am working on SQL server 2000 and i continuesly watching the Current activity in Process info option.
i found same type of process with 60 to 70 number of simulatenously running activities. they all running the Sp_Cursoropen Command and consuming maximum CPU cycles.
Example:-
ProcessID ContextID User Database Status Command Application
waittime CPU PhysicalIO MemeoryUsage
109 0 UApp Master Runnable Exec Sp_Cursoropen MicrosoftSQLServer
0 212810 23659 809
Kindly Help.. Looking for your Support.
|
|
|
|
|
You could check that it's not a locking issue using sp_lock or sp_lock2
|
|
|
|
|
Good Morining All
I have Cleints that uses my Application. My Application is Built in Tiers and i dont do database work in my pages, i just call fuctions of my DAL. now when Deploying my Database or Fixing bugs, i end up adding more Stored procedure. To some client i just give them the SP to create or Alter some i do it myself. Now i ask your advice. if is there a way to create a Script that will recreate my SP's on the destination Databases when i deploy my application or when a Client deploys the Application.
Thank you ,
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswam@its.co.za
|
|
|
|
|
|
sp_lock2 is a good tool for resolving lock blocks. If you find a locking issue, you can use KILL statement to kill the session
|
|
|
|
|
if yes then tell me the procedure to change it??
Thanks in advance.
|
|
|
|
|
First collect the current SQL Server instance name
select @@servername
Execute the below queries to change the SQL Server instance name
sp_dropserver ‘old_name’
go
sp_addserver ‘new_name’,‘local’
go
Restart the SQL Server service, to run the below commands:
net stop mssqlserver
net start mssqlserver
|
|
|
|
|
i want retrive value in featch three textboxs use stored procedur with asp.net code what fire Query
modified on Friday, February 13, 2009 1:09 AM
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
