3614 0
Free SQL Server Reporting Tools
In this article, I have provided list of free SQL server reporting tools with their features, so you can easily which sql server reporting tool will be good for your company.
Type
Article
3479 2
How to retrieve an int from Stored Procedure and not an objectResult using EF ???

Hi,

 

im trying to set data from my project (mvc.net,c#) by web service and im using a store Procedure to set the data.

after setting i should recive an int id of the record that was created.

my problem is that the SP returns an objectResult when i run it from my project but when i execute it in SQL it returns int...

How to retrieve an int from Stored Procedure using EF ???

...
Type
Question
3440 0
Get Date From Datetime in SQL Server
In this article, I have mentioned how to get date from datetime in sql server using various examples.
Type
Article
3394 0
Import data from Excel to SQL Server
In this article, I have provided step by step procedure to import excel in SQL Server database using SSMS or using SQL Query.
Type
Article
3386 0
SQL Server Management Studio (SSMS) Alternatives (Mac, Windows, Linux)
In this article, I have mentioned SQL Server management studio (SSMS) alternatives for windows, mac and Linux, which you can try to use.
Type
Article

3340 0
TRIM(), LTRIM(), RTRIM() Functions in SQL Server
In this article, I have discussed about SQL Server TRIM(), LTRIM(), RTRIM() Functions in SQL Server with example
Type
Article
3290 0
Extract String after a character or before character in SQL Server
In this article, i have mentioned how we can Extract String after a character or before character in SQL Server with examples
Type
Article
3221 2
how to take back up of all sql server databases?

I am using SQL server 2012 right, and I would like to know how can I take back up of all MS SQL server databases using a single script? or you can explain me a simple method.

 

...
Type
Question
3221 1
Database Threats and how to Prevent them

I am tasked with security of the systems database, as the previous operation lacked security and left gaping holes in the system. The Systems information was leaked, and clients records were leaked as well as workers salaries. I need to find One technique or strategy to prevent this information loss, and propose how we will prevent this in future. I am relatively new to DBMS, can you please help me.

...
Type
Question
3170 1
select values from one table and avg of column from another?

I have Two Tables, from one table I want to select all column but from the second table I want to fetch only one column with average value using avg function with related id 

How can I achieve this using SQL query?

...
Type
Question

Page 7 of 11