No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
Have resolved good amount of SQL Server related issues from small to big in terms of time taken as well as in terms of finances associated if not solved.
So, if you have SQL Server issues, I might have solution.
- Interests
- Football, Cricket
- PC Specs
- 2 Computers with 2 and 4 GB RAM 40 and 80 GB Hard Disk Pentium 5 processors. having Windows home and…
 | Hi All, When I run the query: [B]select (100/50)[/B] It give me "2"... good. But when I run the query: [B]select (50/100)[/B] I was expected it will give me 0.5... but it gives me 0 instead? Why? and How can I get the "0.5"?  |
| | I cant call : [111.111.111.1].Database.dbo.fn_test(@test) (Not working !) but i can call : Database.dbo.fn_test(@test) why ? and if no way to call this, can i populate in a function a TABLE variable using a Stored Procedure to do this ? CREATE FUNCTION fn_test(@idcode int,@idoper int) RETURNS TABLE AS RETURN (EXEC … |
| | Hello, I recently deleted some columns from a table with the statement DROP and I saw that database size doesn't change, it remains exactly the same(very big by the way). So I suposse DROP only take away the logical references but the COLUMN is still physically there. The question is: … |