4-4-5 Calendar Functions, Part 1
New author Cliff Corder has a SQL Server function to report on a 4-4-5 Calendar Accounting Year.
2010-09-06 (first published: 2009-09-28)
22,638 reads
udf
RE: Looking for single system query to return the rowcount of all tables in a DB
or you can try this. sp_msforeachtable @command1 = 'print ''?''' , @command2 = 'select count (*) from ?' sp_msforeachtable will perform up to three commands on each table in the database. When running, it replaces the ? with the name of the table.
2005-05-13
Question of the Day for 30 May 2005
Comments posted to this topic are about the Question of the Day for 30 May 2005 posted at http://qa.sqlservercentral.com/testcenter/qod.asp?QuestionID=521.
2005-05-11
1 reads
2005-05-11
RE: Importing sign based decimal numbers
When you import the data apply a manual transform. Transforms use VBScript or JScript and you can fairly easily make a change like that as you are inserting into the table.
2004-09-22
Systems Thinking
Comments posted to this topic are about the content posted at http://www.thinking.net/Systems_Thinking/systems_thinking.html
2004-08-31
3 reads
RE: SQL 2K on win 2003
What do the last few lines of your sqlstp.log report? It should be in %SYSTEMROOT%. You can go from SQL Server 2000 RTM (the CD) straight to SP3 without applying the others.... the Service Packs are cumulative.As for the initial question, we're running Win2K3/SQL2KSP3 Active/Active. Experiencing some issues with distributed transactions and MS DTC, but we're […]
2004-02-05
Linked Server and Missing records!
Ok, this is one of the strangest things I have ever seen. First thing, the background: we have a DB2 system that we want to take out all the records from a handful of tables and place the data in SQL Server. There will be some manipulation to the data; but, even before that the […]
2004-02-05
1 reads
Debuggin backup jobs
I used the maintainence planner wizard to build my backup jobs, daily differentials, weekly fulls, integrity checks etc.The jobs are not succeeding. No backs are being created and all I get for a message is "Last step to run was Step 1"Does this mean that step 1 was the last job to succeed? Or that […]
2004-02-02
RE: Access to View SQL jobs
Trace yourself in profiler while you look at the jobs.. That should give you an idea of the permissions you need. Without testing anything I am guess readonly permissions in msdb will do the trick.
2004-01-30
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