I have a requirement to change the date to 1900-01-01 if its an invalid date like 2009-13-31 (I…
1 day, 16 hours ago
Hi Experts !
I have two select statements, in between select statement taking UNION ALL . I need to…
1 week, 3 days ago
By: Orlando Colamatteo
HiTo make it simpleI have a @StartDate and @EndDateI choose students with an admit date in th…
1 month ago
By: Jeff Moden
I created a date field [Datte] in SQL v2008. I then link with MS Access. No problem. Done this many…
1 month, 2 weeks ago
anyone know if SQL replication snapshot uses OS memory rather than the SQL allocated memory? Al…
2 months ago
I'm really a newbie in SQL, I hope you can help me with this.
I need to export a table in …
I have a client C/C++ app, which encrypts data using AES encryption algorithm and stores them i…
By: Erland Sommarskog
I have implemented a database in SQL-server 2008. In all tables, I have set all the primary key…
2 months, 2 weeks ago
i'm writing below this code..
@profile_name = 'local',@recipients='chintu…
2 months, 3 weeks ago
I want to insert record job allocations only for selected jobs
I know the following code won't work…
While executing DBCC CHECKDB i am getting following error
"Check terminated. A failure was detect…
2 months, 4 weeks ago
I run the SSIS and got these errors. Please help as data didn't go to the database.
3 months, 1 week ago
By: Mr. Brian Gale
This topic was modified 4 months ago by jtvevox.
4 months ago
I am in the process of cross training a DBA. At this point, he has very little knowledge of ERwin 7…
4 months, 1 week ago
Viewing 15 topics - 1 through 15 (of 30,205 total)
You must be logged in to create new topics.