A table variable only exists during the run of the process that created it as is immediately destoryed at the end and any pages in tempdb associated with it are freed. Basically each time the procedure completes execution the object is immediately destroyed.So unless the stored procedures that create them are looping back on themselves […]
2005-01-06
Hi, I am not an experienced guy in SQL Server. Please help me to solve my problem. I can connect through Static connection to SQL Server without any problem. Eg, Enterprise Manager or Power Builder etc. But when I connect through Query Analyzer or ODBC I getting the following error. ODBC: Msg 0, Level 16, […]
2005-01-06
1 reads
I want to lop off the 4th decimal from a column and update that column.Example:col_a1.23452.34563.4567I want col_a1.23402.34503.4560I thought it was update table set col_a = Trnucate(col_a,3) but this is wrong.
2004-09-10
1 reads
2004-07-13
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!
2004-07-12
As long as you can connect to them via linked server I really don't see why it would matter where they live as long as they can talk....
2004-07-05
Are you ready to take your SQL skills from theoretical to tactical? If you've...
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers