2572 3
How should i display first 10 records at a time in sql (paging in SQL)?

How should i display 1st 10 records, then next 10 records then next 10 records in sql (paging in SQL)? 

And how should i display the same thing in view using see more link?

...
Type
Question
2272 2
Is sql server management studio free to use?

Hello, I can across a question earlier today while working at the office and would like to know if sql server management studio is free to use or we need to pay for it?

...
Type
Question
2251 0
Common Table Expressions (CTE) in Sql server
In this article, I have explained what is Common Table Expression (CTE), Advantages of using CTE and Recursive CTE in SQL using SQL server based example.
Type
Article
2250 2
Not able to start SQL server browser in windows

Today, I was trying to Start my SQL server browser using SQL server configuration manager in windows 10, but I cannot see any option to start it as it is blurred and not clickable, so cannot start SQL server browser, here is the screenshot of my pc

...

Type
Question
2112 0
Understanding SQL server COALESCE() with example (ISNULL comparison included)
In this article, I am going to provide you complete details of SQL server COALESCE function with example & will compare it with ISNULL.
Type
Article

2084 2
How to solve error "save changes is not permitted" in sql server?

I am using SQL server 2012 and when trying to edit design of already saved table, i am getting this error

Saving changes is not permitted. The change you have made requires the following table to be dropped and re-created. You have either made changes to a table that can't be recreated or enabled the option prevent saving changes that require the table to be re-created.

Here is the image of the error

...

Type
Question
1941 1
How to get the records of last month using sql query in SQL server?

Hello, I need to check my last month records in SQL server management studio, and I would like to know how can I get record of only last month from a table using SQL query, I have DateCreated column to check when the row was added in the table.

For example, as It's may,2018 and I would like to run a Query to get April,2018 records using sql server query.

If possible, I would also like to know, how to get last 30 days(not month) records in SQL server query.

Currently, I am using SQL server 2012.

...
Type
Question
1910 1
How to fix "SQL server configuration manager cannot connect to wmi provider" error?
In this article, I am going to provide your easy way to fix SQL server configuration manager cannot connect to wmi provider error.
Type
Article
1764 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
1757 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

Page 4 of 7