RE: ADO doesnt connect without network
I tried to disable the firewall, but it did not work the same!
2004-11-19
Expressions
RE: SQL UDF to return hours
Hi Dave!I am a newbie when it comes to SQL, sorry for inconvienience, your answer worked perfectly, but I meant to say minutesWith your above answer, can you change that to return MINUTES instead of hours and exclude holidays that are in TableA . Lets say TableA hasHolidayDate 2004-08-09 00:00:00.000 2004-09-24 00:00:00.000 2004-12-16 00:00:00.000 2004-12-26 00:00:00.000 […]
2004-11-15
1 reads
RE: Rollbacking changes by giving date as input
I am NOT an expert.But you can try this.1. Do a transaction backup.2. Then do a restore of your database to the date that you want to roll back.3. Backup or copy out your database.4. Restore your database back to today.5. Delete all records.6. Copy back from your backup (from step 3)This will not work […]
2004-11-08
RE: SQLServerCentrals Shabby State Managment
No. First test is to just visit the site, login, close the browser without logging out. Go back to the site. If you're asked to login, the cookie is not persisting.
2004-09-16
RE: Variable in Dynamic SQL
--I think this might solve your problem (you no longer need the @Out variable):Create Procedure RecCount (@Table as Varchar(20)) AsBegin Declare @strSQL as varchar(100) Declare @Out as int Set @strSQL='Select Count(*) from ' + @Table Exec(@strSQL)End------Hope this helps
2004-08-20
RE: Question of the Day for 07 May 2004
Have to laugh here, but too funny. I was just reading this last night.
2004-05-07
2004-01-22
1 reads
RE: Storing an Excel Sheet in an SQL field.
Ok, some thoughts about why you shouldn't put them in the DB. I will grant you this is a bit old school in thinking but it is something to consider. Why put something in a database -- You need to search on it -- You need to really control access and NTFS security is too […]
2003-06-23
RE: DBAs versus SQL Server
We have 39 servers running 42 instances. We have over 600 databases. There are three clustered servers. There is one full time DBA, one junior DBA and the manager of the group is a part time DBA. We hardly ever get involved in development DB design (no time). We spend most of our time doing […]
2003-06-05
1 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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