Topics
Started by
Posts
Last post
Hi, Is it possible to retrieve Error Description in T-Sql just like @@Error. Also, is it possible t…
2 replies
How do I test for tmp tables??? I want to test if the tmp table exists if so drop tmp table. Steve …
3 replies
Hi All, When using a query in a dts package, functions parse as valid SQL, however usually the dts …
1 replies
Hi, I run a bcp command inside my sql analyzer. I did this: master.dbo.xp_cmdshell "bcp dbname.dbow…
3 replies
Hi, I had never used bcp before. So I got a lot of questions to ask about bcp. First, how to run bc…
10 replies
Hi All, I want to use Begin Transaction and Commit Transaction in my trigger. But when I used it an…
4 replies
Hi, according the book, Microsoft SQL Server 2000 DBA Survival Guide, in order to achieve fast mode…
4 replies
Providing the following information:- SQL Server: 7.0 Database Name : TestDB Table Name: TestTBL (F…
3 replies
Question : Is ther a way to create a table using a dynamic name like : Declare @tablename as varcha…
6 replies
I developed this procedure that when executed will grant or revoke privlages to users or user group…
1 replies
Hi, I am trying to construct a dynamic sql containing a table varaible as this: declare @mv_table t…
3 replies
Hi, we are porting our software from oracle to sql server. In one of our tables in oracle db, we ha…
4 replies
How to lock a table in sqlserver?
2 replies
I came across this feature mentioned whereby you can store Word documents and conduct full text sea…
3 replies
I heard that all sp_ store procedures will be recompiled everytime you execute them, Is it true?
1 replies
Viewing 15 topics - 4,246 through 4,260 (of 4,455 total)
You must be logged in to create new topics.
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy