Topics
Started by
Posts
Last post
How can i see the size of mdf and ldf of my database.?And how can i increase the size if the files
1 replies
If a field is typed as text, length(16) how many characters / bytes will it hold? Thanks
4 replies
i HAVE A TABLE WITH NO UNIQUE KEY AND HAS DUPLICATE RECORDS IN. i CAN GET THE DISTINCT RECORDS OUT …
4 replies
Hi I've developed a stored procedure to insert a record into a table. If the record already exists,…
2 replies
I am aware that there are a number of ways of finding out the params which need to be passed into a…
2 replies
I have constructed two select-statements, which in my opinion should do the same (see below). The f…
3 replies
Any way to force BCP or Bulk Insert to import a text file in exact original row order? BCP and bulk…
4 replies
Hi, i need to do some error handling in my stored proc i plan to use @@Error and if its not equal t…
3 replies
Can I use scope_identity() in a stored procedure on a column when there is no identity on that colu…
2 replies
Hello, Right now I have a package that imports the file that imported from the ftp server. Sometime…
1 replies
I have a table, machine_products (machine_id char(1), product_key int) Both columns make up the PK.…
8 replies
There is a index: CustomerInfo_1 with keys: customerId, EnteryDate DESC I could not find where the …
1 replies
Hi How do you insert a row into a table where one of the column has single quote ' as a part of the…
2 replies
How can I get the dynamic OrderBy to work properly? Below is a simple sample: DECLARE @test-2 SYS…
1 replies
Hi! I got two questions 1) performance comparison between sp and udf. which faster? 2) for query th…
2 replies
Viewing 15 topics - 15,436 through 15,450 (of 17,082 total)
You must be logged in to create new topics.