RE: How Can I Get a List of the Fields in a Table?
i put the table name in place of TableName in your code; but I'm getting an empty set when I run the code. how else do i need to modify the code?
2004-01-27
Tabular Model
RE: Deletign a log file: Urgent
I use these 2 statements as two different steps in a job to back up the log and then truncate it. Works well.Step 1BACKUP LOG [MyDB] TO DISK= 'D:\Backup\MySqlServer\MyDB\MyDbLog.dat' WITH NOINIT , RETAINDAYS=2, NOUNLOAD , NAME = N'MyDB Translog Backup', NOSKIP , STATS = 10, NOFORMATStep 2USE master BACKUP LOG MyDB WITH NO_LOG GO USE MyDB […]
2004-01-07
1 reads
RE: Structuring SQL to retrieve data from child recs
weissa, Can you answer jxflagg Last question? I have no clue about what are your presentation requeriments and That makes it harder for me so I am guessing now: Suppose you have TableChild (ChildID int, ParentID int , Property varchar (100)) You Could Do: Declare @strAllChilds varchar(4000) Declare @MasterRecordID int SET @MasterRecordID = X SELECT […]
2003-12-24
RE: How to change Working Directory
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-12-15
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