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?
...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?
...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
...
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
...
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.
...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.
...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 ???
