I like to use variable tables however, for me it all depends on what your script is doing. i usually create a script using both methods my self and then...

Not sure what you mean, can you provide some screen shots or what error do you get when you try to query a this table? can you see it in...

Try this

exec master..xp_cmdshell 'bcp "database.dbo.tablename" in "C:\location\file.bcp" -E -n -T -S'

EG

exec master..xp_cmdshell 'bcp "adventureworks.dbo.employee" in "C:\temp\employeer.bcp" -E -n -T -S'

Hi, i think i see what you trying to do, have a look at this SP that i created to get schema information about any table in a database, just...

DOH why dindt i think of that worked perfect thanks 🙂

Hi is this for you to take and learn or to provide to someone else?, i have some old SQL tests from way back at college you can have they...

Here is a script that i created a while ago to list out the table fragmentation of the whole DB, run it against your db. yer it runs through a...

thanks that makes sense cheers

so are you saying that when you do for example select * from products, the server returns an error instead of returing all the rows of data?

Never used Xquery, first time i have worked with bringing XML into SQL, the XML can be very large having over 100 sections of drawings.

i will have to have a...

Lo not sure if there is an easier way but, i had a large XML file that had multiple sections of the same data, same idea as the XML you...

I used the following method in the past to create a batch file, with the content of a SQL query, you may be able to use this method to complete...

Not too sure what your asking but as i read it, you want a script to look through your results and create a file called what ever your name colummn...

any reason why you dont want to use a trigger? there are some articles out there that give some adive on how to do it without a trigger but i...

I have often think about going solo; I am pondering towting for private work but, where do you start, how do you work out what is the going rate for...