Viewing 15 posts - 2,791 through 2,805 (of 13,469 total)
anoop.mig29 (12/11/2013)
At one of our client side we are not abled to get logged in sql server through windows login and we donot have sa pwd or any...
December 13, 2013 at 9:34 am
this generates the basics of what you are asking; you'll need to further filter on the datatype of the columns(text,image,bit, others?); the first version i tested returned an error for...
December 13, 2013 at 9:26 am
didn't notice this was for SQL2005, so the TIME datatype is out, but the other two converts i posted will work.
December 13, 2013 at 9:23 am
Dave i think the easiest is cast your datetime as TIME datatype, but here's a quick example of the three i could think of:
/*
create_date ...
December 13, 2013 at 9:21 am
darth.pathos 62444 (12/13/2013)
December 13, 2013 at 9:00 am
well, there is a few contributions here on SSC that does some of what you are after and much, much more:
http://www.sqlservercentral.com/search/?q=database+documentation&t=s&sort=relevance
one of the four links for "Comprehensive Database Documentation" is...
December 13, 2013 at 8:18 am
you have to rebuild all the indexes on the table, including the clustered index i believe in order to free the space to the database again.
December 13, 2013 at 7:36 am
not enough information for us to offer more than vague things to check.
performance tuning is a wide subject, and the tiny bit you gave us so far isn't enough to...
December 13, 2013 at 7:24 am
pietlinden (8/28/2013)
Wouldn't you use JET4.0 instead of ACE? ACE is the filetype for Access 2007 and beyond.
the ACE drivers are required for a SQL server 64 bit version to...
December 12, 2013 at 12:00 pm
i've heard the data dictionary as being the Extended Properties comments that are potentially included in a database to describe objects/tables /columns, but only if someone has gone to...
December 12, 2013 at 11:31 am
you have to change your query to query first from a Calendar table of some sort, which contains all possible dates.
then your CTE left joins to that Calendar table.
with that...
December 12, 2013 at 9:10 am
in the procedure itself, do you have something like RETURN @MyDateValue
the return of a stored procedure only can return an integer, and it typically means success(0) or failure(non zero) ,...
December 12, 2013 at 6:59 am
since it's happening on the server itself(local machine), look at the running processes, and see if there's an additional application or scheduled task or something that is running/trying to connect...
December 12, 2013 at 6:24 am
there is some support for patterns/regular expressions in SQL
this does what you are asking, i think. one expression tests exactly ten characters, the other test the first ten characters
WITH mySampleData(val)
AS
(
SELECT...
December 12, 2013 at 5:54 am
Stan for the portion where you stick the image into a table, you can do it via a CLR function;
the CLR would look like this:
[Microsoft.SqlServer.Server.SqlFunction()]
public static SqlBytes CLR_GetFileImage(SqlString RetailerId)
{
try...
December 12, 2013 at 5:43 am
Viewing 15 posts - 2,791 through 2,805 (of 13,469 total)